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