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=9 AND p.iUserType='2' AND iCityID IN (1134,968,895,713,811,716,1285,925,654,1034,1025,778,567,748,1245,887,934,787,759,666,733,1284,16284,1251,980,711,1221,923,745,16321,16114,574,1159,999,585,672,1029,611,1066,1292,1055,682,1030,16305,1195,824,979,735,712,1017,1065,665,783,789,601,1011,1243,1154,1282,744,1220,1010,734,1194,990,1189,882,1279,593,1197,971,1012,719,977,578,1273,1090,1086,1171,951,579,1161,833,1215,709,835,1151,708,637,1064,972,1289,16486,827,674,874,1031,810,656,914,1093,1124,771,797,645,670,16296,1032,877,1149,948,957,926,1207,16303,677,657,1114,691,639,1272,1081,754,706,647,1153,891) ORDER BY FIELD(iCityID, 1134,968,895,713,811,716,1285,925,654,1034,1025,778,567,748,1245,887,934,787,759,666,733,1284,16284,1251,980,711,1221,923,745,16321,16114,574,1159,999,585,672,1029,611,1066,1292,1055,682,1030,16305,1195,824,979,735,712,1017,1065,665,783,789,601,1011,1243,1154,1282,744,1220,1010,734,1194,990,1189,882,1279,593,1197,971,1012,719,977,578,1273,1090,1086,1171,951,579,1161,833,1215,709,835,1151,708,637,1064,972,1289,16486,827,674,874,1031,810,656,914,1093,1124,771,797,645,670,16296,1032,877,1149,948,957,926,1207,16303,677,657,1114,691,639,1272,1081,754,706,647,1153,891) ASC, p.tmPosted DESC LIMIT 24 Agricultural Land for Sale by Agent in Sanford