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.iItemType='20' AND s.iCondition='1' AND iCityID IN (68187,68739,69053,67404,68593,69299,70392,68190,68075,68484,66956,69110,68179,70111,69062,68559,67586,69293,68542,69129,67470,68523,69097,68050,68507,67638,67523,69672,69276,67413,69115,68072,68828) ORDER BY FIELD(iCityID, 68187,68739,69053,67404,68593,69299,70392,68190,68075,68484,66956,69110,68179,70111,69062,68559,67586,69293,68542,69129,67470,68523,69097,68050,68507,67638,67523,69672,69276,67413,69115,68072,68828) ASC, p.tmPosted DESC LIMIT 24
Used Other Commercial Vehicles for Sale in Mundargi
