[eluser]megabyte[/eluser]
I didnt build this database but have to try and deal with its issues,
I need to cobine two tables
SELECT AdID, CityID, OrderSequence FROM ad_listing WHERE CityID = 484 AND Active = 1 GROUP BY ad_listing.AdID ORDER BY OrderSequence
SELECT AdID, CityID, OrderSequence FROM ad_listing_cities WHERE CityID = 484 GROUP BY AdID ORDER BY OrderSequence
And then order by OrderSequence and only show id Active = 1