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