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