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