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