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