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