Help on MYSQL query

Help on MYSQL query is project number 87172 posted at GetAFreelancer.com. Click here to post your own project.

Status:	Closed (Cancelled by the Site Administrator)
Selected Providers:	-
Budget:	$30-100
Created:	09/07/2006 at 7:10 EDT
Bidding Ends:	09/08/2006 at 7:10 EDT
Project Creator:	timmy01   Buyer Rating: (11 reviews)
Description:	Hi, I am looking for a programmer who has lots of knowlegde of MYSQL databases and PHP. I am stuck on this issue trying to fix something like this: mysql query: /////////////////////////////////////////// SELECT table1.city_id, table2.main_id, table3.city_name, COUNT(*) AS count FROM table1, table2, table3 WHERE table2.main_id=table1.main_id AND table2.description_id='1' AND table2.country='uk' AND table1.city_id=table3.city_id AND table3.language='de' GROUP BY city_id ORDER BY city_name ASC /////////////////////////////////////////// What i want you do is help me fixing these few issue's: -> get the city names of the tables that do cointain information of the previous selected language -> count the total row -> ORDER the result by city name ASC We are talking about 1 database with 3 tables the problem is that in the table that holds all the citynames some cities are not translated in the language we are looking for. In that case the english version should be selected by default. So all you have to do is get us the correct Query. everything else is already working. We do want to chat on the MSN. I think in total it will take max. 1 hour or maybe 0,5 hour. Regards!
Job Type:	PHP
Database:	MySQL
Operating system:	Linux
Bid count:	13
Average bid:	N/A