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