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 ('+free +classified +listing +sites' IN BOOLEAN MODE)) AND iCityID IN (10196,10692,10960,10301,10862,11078,11030,10416,10256,10591,10945,10670,10842,11070,6874,10722,10430,6875,11047,10946,11107,10205,10619,10966,10474,10645,10744,11007,10466,10657,11119,10682,10656,10846,10843,10511,10786,10403,11025,10761,10465,10557,16206,10326,10439,10348,10250,10737,10667,10712,11050,10838,10624,16219,16217,10304,10710,10965,10295,10956,10685,10374,10663,10255,10582,10390,10600,10673,10975,10828,10375,10245,10340,10296,10317,10819,10285,11114,10658,10696,11074,10813,11005,10287,11046,10720,10552,11058,10431,10728,10811,11077,10742,10399,10878,10850,10620,10283,10952) ORDER BY FIELD(iCityID, 10196,10692,10960,10301,10862,11078,11030,10416,10256,10591,10945,10670,10842,11070,6874,10722,10430,6875,11047,10946,11107,10205,10619,10966,10474,10645,10744,11007,10466,10657,11119,10682,10656,10846,10843,10511,10786,10403,11025,10761,10465,10557,16206,10326,10439,10348,10250,10737,10667,10712,11050,10838,10624,16219,16217,10304,10710,10965,10295,10956,10685,10374,10663,10255,10582,10390,10600,10673,10975,10828,10375,10245,10340,10296,10317,10819,10285,11114,10658,10696,11074,10813,11005,10287,11046,10720,10552,11058,10431,10728,10811,11077,10742,10399,10878,10850,10620,10283,10952) ASC, p.tmPosted DESC LIMIT 24
free classified listing sites, Community Classifieds, Local Events, Friends, Activities in Auburn
