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

moduleid=23&fields=areaid&condition=status=3 and areaid in (25,321,2721,2722,2723,2724,2725,2726,2727,2728,2729,2730,2731,2732,2733,2734,2735,2736,2737,2738,2739,2740,2741,322,2752,2753,2754,2755,2756,2757,2758,2759,2760,323,2761,2762,2763,2764,2765,2766,2767,2768,2769,2770,2771,2772,2773,324,2774,2775,2776,2777,325,2778,2779,2780,2781,2782,2783,2784,326,2785,2786,2787,2788,2789,2790,327,2791,2792,2793,2794,2795,2796,2797,2798,2799,2800,2801,2802,2803,2804,2805,2806,2807,2808,328,2809,2810,2811,2812,2813,329,2814,2815,2816,2817,2818,2819,2820,330,2821,2822,2823,2824,2825,2826,2827,2828,331,2829,2830,2831,2832,2833,2834,2835,2836,2837,2838,2839,2840,2841,2842,2843,2844,2845,332,2846,2847,2848,2849,2850,2851,333,2852,2853,2854,2855,2856,2857,2858,2859,2860,334,2861,2862,2863,2864,2865,335,2866,2867,2868,2869,2870,336,2871,2872,2873,2874,2875,337,2876,2877,2878,2879,2880,2881,2882,2883,338,2884,2885,2886,2887,2888,2889,2890,2891,2892,2893,339,2894,2895,2896,2897,340,2898,2899,2900,2901,2902,2903,341,2904,2905,2906,2907,2908,2909,2910)&pagesize=4000&group=areaid&template=list_select_city¤turl=https://aq.quanguoweixiu.com/wxwd/sfsc-cscd/&showall=1&debug=1
SELECT areaid FROM dt_article_23 ya JOIN (SELECT itemid FROM dt_article_23 WHERE status=3 and areaid in (25,321,2721,2722,2723,2724,2725,2726,2727,2728,2729,2730,2731,2732,2733,2734,2735,2736,2737,2738,2739,2740,2741,322,2752,2753,2754,2755,2756,2757,2758,2759,2760,323,2761,2762,2763,2764,2765,2766,2767,2768,2769,2770,2771,2772,2773,324,2774,2775,2776,2777,325,2778,2779,2780,2781,2782,2783,2784,326,2785,2786,2787,2788,2789,2790,327,2791,2792,2793,2794,2795,2796,2797,2798,2799,2800,2801,2802,2803,2804,2805,2806,2807,2808,328,2809,2810,2811,2812,2813,329,2814,2815,2816,2817,2818,2819,2820,330,2821,2822,2823,2824,2825,2826,2827,2828,331,2829,2830,2831,2832,2833,2834,2835,2836,2837,2838,2839,2840,2841,2842,2843,2844,2845,332,2846,2847,2848,2849,2850,2851,333,2852,2853,2854,2855,2856,2857,2858,2859,2860,334,2861,2862,2863,2864,2865,335,2866,2867,2868,2869,2870,336,2871,2872,2873,2874,2875,337,2876,2877,2878,2879,2880,2881,2882,2883,338,2884,2885,2886,2887,2888,2889,2890,2891,2892,2893,339,2894,2895,2896,2897,340,2898,2899,2900,2901,2902,2903,341,2904,2905,2906,2907,2908,2909,2910) GROUP BY areaid LIMIT 0,4000) yb on ya.itemid=yb.itemid
全部 成都

moduleid=23&fields=areaid&condition=status=3 and areaid in (321,2721,2722,2723,2724,2725,2726,2727,2728,2729,2730,2731,2732,2733,2734,2735,2736,2737,2738,2739,2740,2741)&pagesize=4000&group=areaid&template=list_select_area¤turl=https://aq.quanguoweixiu.com/wxwd/sfsc-cscd/&showall=1&debug=1
SELECT areaid FROM dt_article_23 ya JOIN (SELECT itemid FROM dt_article_23 WHERE status=3 and areaid in (321,2721,2722,2723,2724,2725,2726,2727,2728,2729,2730,2731,2732,2733,2734,2735,2736,2737,2738,2739,2740,2741) GROUP BY areaid LIMIT 0,4000) yb on ya.itemid=yb.itemid
全部 锦江区