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 p.iPostType=12 AND iPostID IN (SELECT t.iPostID FROM posttext t WHERE t.iDomID=1 AND MATCH (t.strSearch) AGAINST ('+weekly +store +flyers' IN BOOLEAN MODE)) AND iCityID IN (1145,594,1007,1103,1104,932,843,1109,842,866,907,1217,803,1073,604,1263,603,602,1167,912,1163,800,1129,746,1128,673,776,1212,1120,16484,723,1125,1021,1045,1216,1250,726,1196,737,669,571,1193,652,651,1119,573,871,825,829,16297,12,16488,16601,780,956,890,597,1249,1049,16329,625,739,1098,687,16312,624,16286,662,740,1018,1201,1181,989,1111,1158,1261,929,16326,1130,1091,924,939,596,1278,626,856,1271,590,1144,905,1208,613,595,1058,1225,622,751,1009,721,834,16489,717,867,16494,16482,1135,1206,1248,1172,772,1136,1169,16485,1108,1148,1162,1150,598,1076,894,799,813,16318,16317,1214,697,16493,1293,947,1226,1131,1174,1127,1276,16316,1033,773,1244,1280) ORDER BY FIELD(iCityID, 1145,594,1007,1103,1104,932,843,1109,842,866,907,1217,803,1073,604,1263,603,602,1167,912,1163,800,1129,746,1128,673,776,1212,1120,16484,723,1125,1021,1045,1216,1250,726,1196,737,669,571,1193,652,651,1119,573,871,825,829,16297,12,16488,16601,780,956,890,597,1249,1049,16329,625,739,1098,687,16312,624,16286,662,740,1018,1201,1181,989,1111,1158,1261,929,16326,1130,1091,924,939,596,1278,626,856,1271,590,1144,905,1208,613,595,1058,1225,622,751,1009,721,834,16489,717,867,16494,16482,1135,1206,1248,1172,772,1136,1169,16485,1108,1148,1162,1150,598,1076,894,799,813,16318,16317,1214,697,16493,1293,947,1226,1131,1174,1127,1276,16316,1033,773,1244,1280) ASC, p.tmPosted DESC LIMIT 24
weekly store flyers, Community Classifieds, Local Events, Friends, Activities in Seminole
