moduleid=23&fields=areaid&condition=status=3 and areaid in (31,393,3324,3325,3326,3327,3328,3329,3330,3331,3332,3333,3334,3335,3336,3337,3338,3339,3340,3341,3342,3343,3344,3345,3346,3347,3348,3349,3350,3351,3352,3353,3354,3355,3356,3357,3358,3359,3360,3361,3362,3363)&pagesize=4000&group=areaid&template=list_select_city¤turl=https://aq.quanguoweixiu.com/wxwd/sfcq/&showall=1&debug=1
SELECT areaid FROM dt_article_23 ya JOIN (SELECT itemid FROM dt_article_23 WHERE status=3 and areaid in (31,393,3324,3325,3326,3327,3328,3329,3330,3331,3332,3333,3334,3335,3336,3337,3338,3339,3340,3341,3342,3343,3344,3345,3346,3347,3348,3349,3350,3351,3352,3353,3354,3355,3356,3357,3358,3359,3360,3361,3362,3363) GROUP BY areaid LIMIT 0,4000) yb on ya.itemid=yb.itemid
全部
重庆
