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 iSubType=102 AND p.iAdType='1' AND p.iUserType='2' AND p.iItemType='2' AND s.iCondition='2' AND iCityID IN (68158,69621,67434,68960,68676,67333,69473,69684,68991,67190,68242,67823,69959,67493,67426,68106,69265,68323,69485,70003,68466,68339,67136,67173,69744,67654,68822,67081,69102,68486,68267,68920,67585,68639,68874,67272,68927,68260,69275,70157,67565,69598,67896,69916,69138,70287,68119,68122,69635,68007,68021,69116,68682,68631,68137,69246,67914,67541,68770,70014,69034,67992,69441,69322,69855,68666,68177,67707,70036,69445) ORDER BY FIELD(iCityID, 68158,69621,67434,68960,68676,67333,69473,69684,68991,67190,68242,67823,69959,67493,67426,68106,69265,68323,69485,70003,68466,68339,67136,67173,69744,67654,68822,67081,69102,68486,68267,68920,67585,68639,68874,67272,68927,68260,69275,70157,67565,69598,67896,69916,69138,70287,68119,68122,69635,68007,68021,69116,68682,68631,68137,69246,67914,67541,68770,70014,69034,67992,69441,69322,69855,68666,68177,67707,70036,69445) ASC, p.tmPosted DESC LIMIT 24
New Semi trucks for Sale by Dealer in Muzaffarnagar
