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=105 AND p.iItemType='4' AND iCityID IN (2050,2213,2115,2090,2080,2134,2158,2111,2163,2054,2082,2164,2053,2068,2086,2159,2039) ORDER BY FIELD(iCityID, 2050,2213,2115,2090,2080,2134,2158,2111,2163,2054,2082,2164,2053,2068,2086,2159,2039) ASC, p.tmPosted DESC LIMIT 24
Trucks Wanted to Buy, Rent & Lease in Burlington
