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