SELECT p.iPostID, p.iPostType, p.iAdType, p.iUserType, p.strTitle, p.iSubType, p.iItemType, p.iPrice, p.iPriceUnit, json_unquote(p.jsonLocation->"$.city") AS city, p.jsonExtra, p.tmPosted, p.iShowImg, p.strImages, p.strVideos, p.strPostURL FROM posts p WHERE p.iActive=1 AND p.iPostType=12 AND iPostID IN (SELECT t.iPostID FROM posttext t WHERE t.iDomID=101 AND MATCH (t.strSearch) AGAINST ('+where to +post +advertisements +for +free' IN BOOLEAN MODE)) AND iCityID IN (68256,70128,68709,68419,69934,69196,69872,67797,68410,69935,68052,68792,67226,67332,69121,69101,68024,67661,70061,69210,67973,67584,67065,68412,68720) ORDER BY FIELD(iCityID, 68256,70128,68709,68419,69934,69196,69872,67797,68410,69935,68052,68792,67226,67332,69121,69101,68024,67661,70061,69210,67973,67584,67065,68412,68720) ASC, p.tmPosted DESC LIMIT 24