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