Closed

Generate a search query SQL for Items

Hi,

I want to generate a search query for "Items". This will allow users to search for albums and photos because both of them have a one-to-one relationship to items. To accomplish this, I will need to come up with a query that performs a union on the results from friends, friends of friends, public and everything in the white list. I will also have to remove results from the black list. As input, I will receive the user's id and their search query. Please check the attached schema.

Clarification:

Each Item has a privacy_id which states whether or not it sharable to no one, friends, friends of friends, or everyone. There is also an privacy_include and

privacy_exclude table that are the white list and black list respectively.

As a user performing a search I should receive only the items I am allowed to see. So automatically give the user results that are labeled public, then search through their friends to find photos only sharable, and etc.

It would help if you had the friends table... which I have attached with the updated schema.

A note about the friends table... to prevent duplicate entries in the table, the user with the greater user id will always be user 2 and the user with the smaller id will be user 1 in the table.

Deadline is very important!

Payment: after successful completion of work.

Thanks!

Skills: Database Administration, MySQL, Oracle, PHP, SQL

See more: union find, this is a search, search black, n query, black search, query table, sql table remove, duplicate table, schema sql, sql query help, generate table php, sql query search xml files, mascot123, sql query generate sales, sql query generate report, check sql, search query, schema search, duplicate input, generate query, generate users, need white list, sql query sql query, sql query tree items, white list

About the Employer:
( 7 reviews ) Dhaka, Bangladesh

Project ID: #2637577

16 freelancers are bidding on average $677 for this job

metodi25sl

will need database(copy or access) before start, ready to start, can be done in 1 day.

$32 USD in 1 day
(76 Reviews)
6.3
diegogarcia0531

Hi, I can do this job, I am SQL, PL-SQL expert

$35 USD in 1 day
(22 Reviews)
5.2
alesix

The attached file doesn't contain a database schema. Maybe you've uploaded the wrong document?

$9999 USD in 99 days
(52 Reviews)
5.1
ultrasonicsoft

Hi, We are expert in MS-SQL. We could deliver you this query asap with good database performance criteria applied. Regards

$31 USD in 1 day
(4 Reviews)
2.1
mkhalidhafeez

Ready to work now...

$30 USD in 1 day
(2 Reviews)
1.1
NetBusinessIT

Hi, I've done alot of work like this before during my 9 years of experience as an IT Consultant.

$300 USD in 7 days
(0 Reviews)
0.0
DWjI386Mw

Custom software development: w w w . The Administrator removed this message for containing contact details which breaches our Terms of Service . i o

$40 USD in 1 day
(0 Reviews)
0.0
juliarocha

Please hire me

$30 USD in 1 day
(0 Reviews)
0.0
ayamas123

Hello, I can start working on this asap. Thanks

$30 USD in 2 days
(0 Reviews)
0.0
boechat

I need a database access and one day to apply any modifications that you will ask if you need.

$70 USD in 2 days
(0 Reviews)
0.0
nphelps88

I can create this query for you in a day or two maximum. I write SQL queries and PL/SQL scripts every day for my full time work. I can certainly handle this, although I require full details of schema and/or DB access More

$30 USD in 2 days
(0 Reviews)
0.0
ykouman

Normally this should be an easy task. All i need is the schema of the relevant tables (as another bidder mentioned, you have not yet uploaded the schema diagram). I am looking forward to doing business with you.

$30 USD in 1 day
(0 Reviews)
0.0
PETRA

Can you tell me where is the database schema? In the attached jpg-file you can not find any!

$50 USD in 1 day
(0 Reviews)
0.0
Nyllian

I see that not many people here have that much experiance in oracle. I can help you with that in PL/SQL.

$50 USD in 1 day
(0 Reviews)
0.0
uandme

I have quite much experience in ERD design, SQL query and DB administration. Let me help you on this semester project.

$30 USD in 2 days
(0 Reviews)
0.0
S856aYkZN

Custom software development: w w w . The Administrator removed this message for containing contact details which breaches our Terms of Service . i o

$40 USD in 1 day
(0 Reviews)
0.0