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