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