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='2' AND p.iItemType='30' AND iCityID IN (13102,13053,13132,13108,14777,14771,13124,13127,13204,13071,13133,13060) ORDER BY FIELD(iCityID, 13102,13053,13132,13108,14777,14771,13124,13127,13204,13071,13133,13060) ASC, p.tmPosted DESC LIMIT 24
Truck Parts Wanted to Buy in Gila Bend
