SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND wp_posts.ID NOT IN (871) AND (
wp_term_relationships.term_taxonomy_id IN (40,91,48,49,51,52,53,86)
) AND wp_posts.post_type = 'listing' AND ((wp_posts.post_status = 'publish')) AND wp_posts.ID in (select pm.post_id from wp_postmeta pm where pm.meta_key ='post_city_id' and FIND_IN_SET( 4, pm.meta_value )) AND (wp_posts.ID in (559,1634,852,347,454,1163,1228,840,923,512,410,1008,1143,825,915,362,492,459,1002,1048,875,877,929,958,539,398,1000,1150,904,415,1032,1236,891,902,936,431,471,810,483,1272,836,906,931,389,1172,1193,1200,1226,136,889,933,950,960,515,419,428,1029,1224,1525,704,1531,1394,794,798,813,819,830,856,858,860,862,938,940,434,645,1534,1648,921,1246,1370,1458,1562,802,506,503,353,377,308,800,1119,1261,534,659,1062,653,672,687,300,1285,1487,325,319,1014,1216,1233,1529,1676,895,518,1669,135,881,541,360,494,1099,887,1219,1357,548,1457,1469,821,873,546,553,321,1016,1038,946,526,1055,1083,1555,374,489,304,1643,528,467,332,1122,1425,1641,134,838,544,439,465,1324,1480,925,1508,942,294,316,1042,523,351,298,1568,648,641,274,1010,1035,1108,1315,1338,355,406,286,461,1046,520,292,1630,530,1018,1065,948,666,1377,885,917,656,1373,1674,962,282,276,323,1050,1053,1071,808,954,696,683,278,1221,1564,124,126,133,842,893,693,412,296,1068,1078,1148,1251,1601,662,685,280,854,919,952,956,437,1086,897,944,1060,1541,550,386,691,1076,1299,1537,1624,125,127,129,130,131,815,680,676,669,288,1333,562,425,1388,1489,1349,310,1131,865,700,1169,473,806,913,330,1355,1399,1413,456,1044,1081,1437,1483,383,338,306,1096,1154,1296,1040,1211,336,1579,1616,792,964,408,702,651,1124,823,556,1553,832,664,1103,1186,1207,1405,1463,883,910,486,302,334,1020,804,908,341,394,328,1126,1146,1152,1570,1204,899,367,828,1347,128,643,290,469,314,312,1074,1134,1473,1093,1477,132,343,380,1304,404,463,1524,844,358,345,402,1558,349,1270,1486,869,537,371,1182,1231,817,689,1253,1538,796,1652,1166,422,1291,927,1116,1257,1518,1263,1175,879,1026,1267,1572,1265,1023,1248,1259,396,392,475,1241,532,480,400,497,501,1238,478,1255,1090,1141)) GROUP BY wp_posts.ID ORDER BY RAND() LIMIT 0, 3