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