moduleid=23&fields=areaid&condition=status=3 and areaid in (23,310,2595,2596,2597,2598,2599,2600,2601,2602,2603,2604,2605,2606,2607,311,2608,2609,2610,2611,2612,2613,2614,2615,2616,2617,312,2618,2619,2620,2621,2622,2623,2624,2625,2626,2627,2628,2629,313,2630,2631,2632,2633,2634,2635,2636,2637,2638,2639,2640,314,2641,2642,2643,2644,2645,2646,2647,315,2648,2649,2650,2651,316,2652,2653,2654,2655,2656,2657,2658,2659,2660,2661,2662,317,2663,2664,2665,2666,2667,2668,2669,2670,2671,2672,2673,2674,2675,2676,318,2677,2678,2679,2680,2681,2682,2683,2684,2685,2686,2687,2688,2689,319,2690,2691,2692,2693,2694,2695,2696,2697,2698,2699,2700,2701)&pagesize=4000&group=areaid&template=list_select_city¤turl=https://aq.quanguoweixiu.com/wxwd_2/sfshanx-csxa/&showall=1&debug=1
SELECT areaid FROM dt_article_23 ya JOIN (SELECT itemid FROM dt_article_23 WHERE status=3 and areaid in (23,310,2595,2596,2597,2598,2599,2600,2601,2602,2603,2604,2605,2606,2607,311,2608,2609,2610,2611,2612,2613,2614,2615,2616,2617,312,2618,2619,2620,2621,2622,2623,2624,2625,2626,2627,2628,2629,313,2630,2631,2632,2633,2634,2635,2636,2637,2638,2639,2640,314,2641,2642,2643,2644,2645,2646,2647,315,2648,2649,2650,2651,316,2652,2653,2654,2655,2656,2657,2658,2659,2660,2661,2662,317,2663,2664,2665,2666,2667,2668,2669,2670,2671,2672,2673,2674,2675,2676,318,2677,2678,2679,2680,2681,2682,2683,2684,2685,2686,2687,2688,2689,319,2690,2691,2692,2693,2694,2695,2696,2697,2698,2699,2700,2701) GROUP BY areaid LIMIT 0,4000) yb on ya.itemid=yb.itemid
全部
西安
