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