moduleid=23&fields=areaid&condition=status=3 and areaid in (2,35,397,398,399,400,401,402,403,404,405,406,407,36,408,409,410,411,412,413,414,37,415,416,417,418,419,38,420,421,422,423,39,424,425,426,427,428,429,430,431,40,432,433,434,435,436,437,438,439,440,441,442,443,41,444,445,446,447,42,448,449,450,451,452,453,43,454,455,456,457,458,459,460,44,461,462,463,464,465,466,467,45,468,469,470,471,46,472,473,474,475,476,47,477,478,479,480,48,481,482,483,484,485,486,487,49,488,489,490,491,492,493,494,50,495,496,497,498,3400,3401,3402,3403,3404,3405,3406,3407)&pagesize=4000&group=areaid&template=list_select_city¤turl=https://aq.quanguoweixiu.com/wxwd/sfah-csaq/&showall=1&debug=1
SELECT areaid FROM dt_article_23 ya JOIN (SELECT itemid FROM dt_article_23 WHERE status=3 and areaid in (2,35,397,398,399,400,401,402,403,404,405,406,407,36,408,409,410,411,412,413,414,37,415,416,417,418,419,38,420,421,422,423,39,424,425,426,427,428,429,430,431,40,432,433,434,435,436,437,438,439,440,441,442,443,41,444,445,446,447,42,448,449,450,451,452,453,43,454,455,456,457,458,459,460,44,461,462,463,464,465,466,467,45,468,469,470,471,46,472,473,474,475,476,47,477,478,479,480,48,481,482,483,484,485,486,487,49,488,489,490,491,492,493,494,50,495,496,497,498,3400,3401,3402,3403,3404,3405,3406,3407) GROUP BY areaid LIMIT 0,4000) yb on ya.itemid=yb.itemid
全部
安庆
