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