help with a mysql sql statement

[eluser]darkhouse[/eluser]
Ok, how about this:

SELECT l.*, ci.*
FROM ad_listing l
JOIN ad_listing_categories ca ON l.AdID = ca.AdID --do you even need this?
LEFT JOIN ad_listing_cities ci ON l.AdID = ci.AdID
WHERE l.active = 1 AND (ci.CityID = 192 OR l.CityID = 192)

You don't need to group by CityID because there's only 1, so that's why you'll only get 1 result.