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