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