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