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=110 AND p.iAdType='1' AND p.iItemType='1' AND iCityID IN (70167,67561,68760,67381,68294,67296,69356,67867,67550,67372,67562,69597,67096,70186,68869,69723,67068,68985,67819,68989,69685,68953,68829,70062,69238,68388,68877,69118,66969,68081,67485,69161,69768,70185,69028,69100,67410,69712,70038,69304,67424,69400,67340,67116,69494,69022,70102,67575,70005,69829,69045,68170) ORDER BY FIELD(iCityID, 70167,67561,68760,67381,68294,67296,69356,67867,67550,67372,67562,69597,67096,70186,68869,69723,67068,68985,67819,68989,69685,68953,68829,70062,69238,68388,68877,69118,66969,68081,67485,69161,69768,70185,69028,69100,67410,69712,70038,69304,67424,69400,67340,67116,69494,69022,70102,67575,70005,69829,69045,68170) ASC, p.tmPosted DESC LIMIT 24
Car Parts for Sale, Offering for Sale in Amanpur
