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