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