JETSETREPORT
Invalid query: Select c.*, ci.name cityname, ci.country citycountry FROM view_listitems as c Join cities as ci on (c.cityID = ci.cityID) Where 1 = 1 AND itemid in (select min(itemid) from view_listitems group by listid) Order By listid