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 ('+local +advertising +sites' IN BOOLEAN MODE)) AND iCityID IN (67309,67514,67262,68508,68605,68428,68620,70088,69192,67549,67793,66999,70174,69073,67268,67780,69103,69055,69842,68205,69625,68549,67740,67394,69094,68278) ORDER BY FIELD(iCityID, 67309,67514,67262,68508,68605,68428,68620,70088,69192,67549,67793,66999,70174,69073,67268,67780,69103,69055,69842,68205,69625,68549,67740,67394,69094,68278) ASC, p.tmPosted DESC LIMIT 24
local advertising sites, Community Classifieds, Local Events, Friends, Activities in Somvarpet
