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.iItemType='11' AND iCityID IN (13506,13980,13666,13590,14120,13986,13915,13511,14130,13913,13900,13503,13906,14034,13313,13765,13442,13359,14040,13835,13508,16349,16348,13966,13516,13905,13671,14005,13641,14166,13318,13485,13559,13642,13427,13577,16351,13231,14081,13686,14053,13241,13914,13623,13965,13645,13621,13417,13803,13800,13799,13311,13451,13389,14157,13607,13964,14017,13879,13253,13669,13661,13357,14163,14065,13902,13317,13753,13976,13436,13562,13600,16476,13941,13473,13584,13422,13653,14118,13678,13658,13555,13971,13872,13916,13824,13770,14097,13605,16383,13237,13657,13656,13672,13897) ORDER BY FIELD(iCityID, 13506,13980,13666,13590,14120,13986,13915,13511,14130,13913,13900,13503,13906,14034,13313,13765,13442,13359,14040,13835,13508,16349,16348,13966,13516,13905,13671,14005,13641,14166,13318,13485,13559,13642,13427,13577,16351,13231,14081,13686,14053,13241,13914,13623,13965,13645,13621,13417,13803,13800,13799,13311,13451,13389,14157,13607,13964,14017,13879,13253,13669,13661,13357,14163,14065,13902,13317,13753,13976,13436,13562,13600,16476,13941,13473,13584,13422,13653,14118,13678,13658,13555,13971,13872,13916,13824,13770,14097,13605,16383,13237,13657,13656,13672,13897) ASC, p.tmPosted DESC LIMIT 24 Differentials for Sale in Escondido