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