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 +paper +advertising' IN BOOLEAN MODE)) AND iCityID IN (67867,69356,67381,67561,70167,67068,70186,68829,68869,67296,67096,67550,68877,68760,69685,68294,67424,67562,69723,68388,69768,69494,66969,69238,69829,68198,67372,68953,69597,68992,67819,69320,70102,69712,70181,69314,68985,68241,69028,68989,67410,67340,68778,69593,68633,68835,69321,67172,68798,70062) ORDER BY FIELD(iCityID, 67867,69356,67381,67561,70167,67068,70186,68829,68869,67296,67096,67550,68877,68760,69685,68294,67424,67562,69723,68388,69768,69494,66969,69238,69829,68198,67372,68953,69597,68992,67819,69320,70102,69712,70181,69314,68985,68241,69028,68989,67410,67340,68778,69593,68633,68835,69321,67172,68798,70062) ASC, p.tmPosted DESC LIMIT 24
local paper advertising, Community Classifieds, Local Events, Friends, Activities in Patiali
