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=101 AND MATCH (t.strSearch) AGAINST ('+best +car +sites +online' IN BOOLEAN MODE)) AND iCityID IN (68571,70385,67343,70071,70344,70351,67679,69632,68347,70224,68059,69974,68485,67663,70180,70381,69633,69352,69232,68298) ORDER BY FIELD(iCityID, 68571,70385,67343,70071,70344,70351,67679,69632,68347,70224,68059,69974,68485,67663,70180,70381,69633,69352,69232,68298) ASC, p.tmPosted DESC LIMIT 24
best car sites online, Automobile Classifieds, Used Cars, Used Motorcycles, Commercial Vehicles, Trucks in Kothapet
