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