全部 北京 安徽 福建 甘肃 广东 广西 湖南 江苏 陕西 四川 重庆

moduleid=23&fields=areaid&condition=status=3 and areaid in (6,96,852,853,854,855,856,857,858,859,860,861,862,863,97,864,865,866,867,868,869,870,871,872,873,874,875,876,877,878,879,880,98,881,882,883,884,885,886,887,888,889,890,891,892,99,893,894,895,896,100,897,898,899,900,901,902,903,101,904,905,906,907,102,908,909,910,911,912,103,913,914,915,916,917,918,919,920,921,922,923,104,924,925,926,927,105,928,929,930,931,932,933,106,934,935,936,937,938,939,940,941,942,943,107,944,945,946,947,108,948,949,950,951,952,953,954,109,955,956,957,958,959,960)&pagesize=4000&group=areaid&template=list_select_city¤turl=https://gz.quanguoweixiu.com/wxwd/sfgx/&showall=1&debug=1
SELECT areaid FROM dt_article_23 ya JOIN (SELECT itemid FROM dt_article_23 WHERE status=3 and areaid in (6,96,852,853,854,855,856,857,858,859,860,861,862,863,97,864,865,866,867,868,869,870,871,872,873,874,875,876,877,878,879,880,98,881,882,883,884,885,886,887,888,889,890,891,892,99,893,894,895,896,100,897,898,899,900,901,902,903,101,904,905,906,907,102,908,909,910,911,912,103,913,914,915,916,917,918,919,920,921,922,923,104,924,925,926,927,105,928,929,930,931,932,933,106,934,935,936,937,938,939,940,941,942,943,107,944,945,946,947,108,948,949,950,951,952,953,954,109,955,956,957,958,959,960) GROUP BY areaid LIMIT 0,4000) yb on ya.itemid=yb.itemid