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 ('+store +sale +ads' IN BOOLEAN MODE)) AND iCityID IN (1139,1080,1252,808,880,1118,1257,940,1040,1112,884,1046,794,1042,892,898,1117,897,1005,1041,581,1247,1146,906,1166,928,16572,836,564,860,623,1016,861,920,1202,1230,715,873,817,823,617,615,16306,616,714,1057,822,1200,1085,1095,919,844,865,685,679,1043,1084,944,1147,599,1179,1203,1036,1002,600,1038,1191,1008,909,996,1219,1156,1013,858,908,1277,1113,16132,1184,910,1240,1077,16298,760,633,16130,955,1094,629,1110,1068,707,705,1265,840,683,1173,1270,1186,1253,828,1061) ORDER BY FIELD(iCityID, 1139,1080,1252,808,880,1118,1257,940,1040,1112,884,1046,794,1042,892,898,1117,897,1005,1041,581,1247,1146,906,1166,928,16572,836,564,860,623,1016,861,920,1202,1230,715,873,817,823,617,615,16306,616,714,1057,822,1200,1085,1095,919,844,865,685,679,1043,1084,944,1147,599,1179,1203,1036,1002,600,1038,1191,1008,909,996,1219,1156,1013,858,908,1277,1113,16132,1184,910,1240,1077,16298,760,633,16130,955,1094,629,1110,1068,707,705,1265,840,683,1173,1270,1186,1253,828,1061) ASC, p.tmPosted DESC LIMIT 24
store sale ads, Community Classifieds, Local Events, Friends, Activities in Schall Circle
