Invalid query: Select c.*, ci.name cityname, ci.country citycountry FROM nightlife as c Join cities as ci on (c.cityID = ci.cityID) Where 1 = 1 AND cityID = 88 Order By DateCreated desc