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

moduleid=23&fields=areaid&condition=status=3 and areaid in (4,61,603,604,605,606,607,608,609,610,62,611,612,613,614,615,63,616,617,618,619,620,621,622,64,624,625,626,627,628,629,630,631,65,632,66,633,634,67,635,636,637,638,639,640,641,68,642,643,644,645,646,647,648,649,69,650,651,652,653,654,655,656,657,658,70,659,660,661,662,663,664,665,71,666,667,668,669,670,671,672,673,72,674,675,676,677,678,679,680,73,681,682,683,684,74,685,686,687,688,689,690)&pagesize=4000&group=areaid&template=list_select_city¤turl=https://quanguoweixiu.com/wxwd/sfgs/&showall=1&debug=1
SELECT areaid FROM dt_article_23 ya JOIN (SELECT itemid FROM dt_article_23 WHERE status=3 and areaid in (4,61,603,604,605,606,607,608,609,610,62,611,612,613,614,615,63,616,617,618,619,620,621,622,64,624,625,626,627,628,629,630,631,65,632,66,633,634,67,635,636,637,638,639,640,641,68,642,643,644,645,646,647,648,649,69,650,651,652,653,654,655,656,657,658,70,659,660,661,662,663,664,665,71,666,667,668,669,670,671,672,673,72,674,675,676,677,678,679,680,73,681,682,683,684,74,685,686,687,688,689,690) GROUP BY areaid LIMIT 0,4000) yb on ya.itemid=yb.itemid