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