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