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 ('+sites +for +cars +for +sale' IN BOOLEAN MODE)) AND iCityID IN (12200,12019,11878,12324,11895,11637,11787,12204,11949,12269,11775,12135,11584,11876,11987,12169,12057,12138,12082,11698,12187,11979,11959,12136,12125,11659,11863,12247,11972,11658,12004,12388,12128,11783,12347,11950,12241,11789,11995,12050,4905,11858,11734,4850,4879,12014,4869,4893,4805,11565,11999,12390,4903,11699,4896,4889,11730,11692,4817,12209,11988,11939,11709,12155,4876,12060,12143,16243,12211,4902,11953,4900,11871,4798,12000,11921,11757,4864,11579,4822,11627,11742,4825,4802,11975,11639,4874,4831,4843,11828,12217,11663,11938,12049,4777,11689,11776,12199,12067,11983,4797,12029,4815,12189,11646,12376,11551,4899,4849,12076,4870,11790,12090,4826,12306,12089,12219,11961,4820,4840,4836,4856,4878,12148,4859,4848,12384,11726,12178,4880,4782,12182,12325,12195,4783,12131,12284,12085,11906,4881,12093,12310,4824,12342,11550,11811,12296,4830,4863,4814,4847,11624,11754,2954,11629,4813,12245,11556,12371,12034,4812,12042,12353,12363,11971,12266,2901,12395,16635,12311,12238,11936,11715,12394,16190,4792,11855,11767,2923,12220,12360,12229,11923,12033,11997,16636,12242,12224,16146,12192,4779,11815,3057,12177,11887,12061,12024,11930,11955,11898,12168,3074,12018,11894,11947,12295,12053,12129,12047,12243,4854,12348,11571,12162,12230,4788,2863,12142,12181,12255,12123,12206,12205,12272,11977,12281,11860,11909,4809,11780,16199,11781,2915,11619,4867,11844,4853,12107,11825,2975,3014,12086,2977,2829,11615,2779,2867,16234,3046,4844,3012,4794) ORDER BY FIELD(iCityID, 12200,12019,11878,12324,11895,11637,11787,12204,11949,12269,11775,12135,11584,11876,11987,12169,12057,12138,12082,11698,12187,11979,11959,12136,12125,11659,11863,12247,11972,11658,12004,12388,12128,11783,12347,11950,12241,11789,11995,12050,4905,11858,11734,4850,4879,12014,4869,4893,4805,11565,11999,12390,4903,11699,4896,4889,11730,11692,4817,12209,11988,11939,11709,12155,4876,12060,12143,16243,12211,4902,11953,4900,11871,4798,12000,11921,11757,4864,11579,4822,11627,11742,4825,4802,11975,11639,4874,4831,4843,11828,12217,11663,11938,12049,4777,11689,11776,12199,12067,11983,4797,12029,4815,12189,11646,12376,11551,4899,4849,12076,4870,11790,12090,4826,12306,12089,12219,11961,4820,4840,4836,4856,4878,12148,4859,4848,12384,11726,12178,4880,4782,12182,12325,12195,4783,12131,12284,12085,11906,4881,12093,12310,4824,12342,11550,11811,12296,4830,4863,4814,4847,11624,11754,2954,11629,4813,12245,11556,12371,12034,4812,12042,12353,12363,11971,12266,2901,12395,16635,12311,12238,11936,11715,12394,16190,4792,11855,11767,2923,12220,12360,12229,11923,12033,11997,16636,12242,12224,16146,12192,4779,11815,3057,12177,11887,12061,12024,11930,11955,11898,12168,3074,12018,11894,11947,12295,12053,12129,12047,12243,4854,12348,11571,12162,12230,4788,2863,12142,12181,12255,12123,12206,12205,12272,11977,12281,11860,11909,4809,11780,16199,11781,2915,11619,4867,11844,4853,12107,11825,2975,3014,12086,2977,2829,11615,2779,2867,16234,3046,4844,3012,4794) ASC, p.tmPosted DESC LIMIT 24
sites for cars for sale, Automobile Classifieds, Used Cars, Used Motorcycles, Commercial Vehicles, Trucks in Royalton
