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