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=2 AND iPostID IN (SELECT t.iPostID FROM posttext t WHERE t.iDomID=1 AND MATCH (t.strSearch) AGAINST ('+the +invention of +car' IN BOOLEAN MODE)) AND iCityID IN (5054,4986,5113,5102,4980,5055,5083,4988,4955,5063,5017,4910,5040,5082,3727,3722,5041,4054,4061,5070,5022,5024,5052,4021,5044,4913) ORDER BY FIELD(iCityID, 5054,4986,5113,5102,4980,5055,5083,4988,4955,5063,5017,4910,5040,5082,3727,3722,5041,4054,4061,5070,5022,5024,5052,4021,5044,4913) ASC, p.tmPosted DESC LIMIT 24
the invention of car, Automobile Classifieds, Used Cars, Used Motorcycles, Commercial Vehicles, Trucks in Murrells Inlet
