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=202 AND p.iUserType='2' AND iCityID IN (2329,2401,16288,2246,2287,2400,2312,2275,5189,2421,2280,2311,2368,5214,2384,2431,2256,2281,5227,2424,5368,5410,5200,5405,2219,2370,2258,2277,5151,2231,2362,2247,5185,5253,2248,2393,5204) ORDER BY FIELD(iCityID, 2329,2401,16288,2246,2287,2400,2312,2275,5189,2421,2280,2311,2368,5214,2384,2431,2256,2281,5227,2424,5368,5410,5200,5405,2219,2370,2258,2277,5151,2231,2362,2247,5185,5253,2248,2393,5204) ASC, p.tmPosted DESC LIMIT 24
Call Center Jobs, BPO Jobs by Consultant in Hopkinsville
