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