Completed

modify sql query

I am looking for a freelancer who can modify the following query:

$sql2 = mysql_query("SELECT * FROM googleimagefound WHERE image_id IN (SELECT id FROM googleimage WHERE user_id = ".$_SESSION['id'].") AND deleted = 0 AND status = 2 ".$queryAddition.$whitelist." ".$prefered_ip." ".$prefered_tld." ".$domain." ORDER BY first_found DESC LIMIT $offset, $rowsperpage");

By using the new query, all data rows shall be shown where:

1. image_id IN (SELECT id FROM googleimage WHERE user_id = ".$_SESSION['id'].") AND deleted = 0 AND status = 2 AND [the end of the TLD of urls stored in the field page_url in table googleimagefound is "de", "at", "ch")

OR

2. image_id IN (SELECT id FROM googleimage WHERE user_id = ".$_SESSION['id'].") AND deleted = 0 AND status = 2 ".$queryAddition.$whitelist." ".$prefered_ip." ".$prefered_tld." ".$domain." ORDER BY first_found DESC LIMIT $offset, $rowsperpage");

means the first part shall be added to the query.

Skills: MySQL, PHP, Software Architecture, SQL

See more: freelancer sql c#, pass query frm front end end php sql, php html query sql, uusing data adaptor aspnet query sql server database, parent child query sql server, sql front end web, net query sql mobile table example, parent child query sql, query sql 2005 csv, query sql parent child result set, web sql front end

About the Employer:
( 105 reviews ) Lüneburg, Germany

Project ID: #9221261

Awarded to:

NoumanHumayun

Hi, I am new to Freelancer but I am no less than any of expert developers here, All I want is you to be a satisfied client and award me 5 star review IFF you like my work, Which you will As you can see I am already More

€10 EUR in 0 days
(2 Reviews)
1.6

3 freelancers are bidding on average €13 for this job

bluewhaleindia

Hello There, We have understood your project scope and had done similar projects in the past. This is Dhinesh from Blue Whale Solutions. We are a 1000+ employee firm, we would like to introduce our self’s and establi More

€22 EUR in 1 day
(9 Reviews)
4.7
mahmoudgamal008

I have more than 5 years of experience in databases and mysql. I wrote hundreds and hundreds of SQL queries. I have more than 1800 answers in Stackoverflow(Q&A Site) [login to view URL] More

€14 EUR in 0 days
(14 Reviews)
3.7
apatel7777

Hi Sir, I have 8+ year of experience in different different technology, I have worked on asp.net,windows application,jquery,sql,mysql and angularjs etc. i have gone through the your requirement. i am ready to start More

€14 EUR in 1 day
(2 Reviews)
1.9