moduleid=23&fields=areaid&condition=status=3 and areaid in (1,51,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516)&pagesize=4000&group=areaid&template=list_select_city¤turl=https://aq.quanguoweixiu.com/wxwd_2/sfbj/&showall=1&debug=1
SELECT areaid FROM dt_article_23 ya JOIN (SELECT itemid FROM dt_article_23 WHERE status=3 and areaid in (1,51,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516) GROUP BY areaid LIMIT 0,4000) yb on ya.itemid=yb.itemid
全部
北京
