mysql分类汇总查询

功能：实负分类汇总以减少结果的条数

代码如下：

 

SET @qlc = '2021091';

SET @kl8 = '2021211';

SET @3d = '2021211';

SET @ssq = '202108911111';
(
    SELECT
        place_code,
        '3d',
        issue_code,
        SUM(bet_money),
        '0',
        DATE_FORMAT( bet_time, '%Y-%m-%d' ),
        '直投',
        '快乐8新版' 
    FROM
        t_d3_bet 
    WHERE
        1 = 1 
        AND issue_code = @3d --         AND place_code = '40080209'
        
        AND STATUS_CODE IN ( 1, 3, 7 ) 
            GROUP BY
        place_code 
    ) UNION ALL
    (
    SELECT
        place_code,
        '3d',
        issue_code,
        SUM(bet_money),
        '0',
        DATE_FORMAT( bet_time, '%Y-%m-%d' ),
        '多期',
        '快乐8新版' 
    FROM
        t_multi_details_d3 
    WHERE
        1 = 1 
        AND issue_code = @3d --         AND place_code = '40080209'
        
        AND STATUS_CODE IN ( 1, 3, 7 ) 
    GROUP BY
        place_code 
    ) UNION ALL
    (
    SELECT
        place_code,
        '3d',
        issue_code,
        SUM(bet_money),
        '0',
        DATE_FORMAT( BET_TICKET_TIME, '%Y-%m-%d' ),
        '拼号',
        '快乐8新版' 
    FROM
        t_spell_bet 
    WHERE
        1 = 1 
        AND issue_code = @3d --         AND place_code = '40080209'
        
        AND STATUS_CODE IN ( 1, 3, 7 ) 
        AND GAME_CODE = 'd3' 
    GROUP BY
        place_code 
    ) UNION ALL
    (
    SELECT
        place_code,
        '快乐8',
        issue_code,
        SUM(bet_money),
        '0',
        DATE_FORMAT( bet_time, '%Y-%m-%d' ),
        '直投',
        '快乐8新版' 
    FROM
        t_kl8_bet 
    WHERE
        issue_code = @kl8 
        AND STATUS_CODE IN ( 1, 3, 7 ) 
    GROUP BY
        place_code 
    ) UNION ALL
    (
    SELECT
        place_code,
        '快乐8',
        issue_code,
        SUM(bet_money),
        '0',
        DATE_FORMAT( bet_time, '%Y-%m-%d' ),
        '多期',
        '快乐8新版' 
    FROM
        t_multi_details_kl8 
    WHERE
        issue_code = @kl8 
    AND STATUS_CODE IN ( 1, 3, 7 )
        GROUP BY
        place_code 
    ) UNION ALL
    (
    SELECT
        place_code,
        '快乐8',
        issue_code,
        SUM(bet_money),
        '0',
        DATE_FORMAT( BET_TICKET_TIME, '%Y-%m-%d' ),
        '拼号',
        '快乐8新版' 
    FROM
        t_spell_bet 
    WHERE
        issue_code = @kl8 
        AND STATUS_CODE IN ( 1, 3, 7 ) 
        AND GAME_CODE = 'KL8' 
    GROUP BY
        place_code 
    ) UNION ALL
    (
    SELECT
        place_code,
        '七乐彩',
        issue_code,
        SUM(bet_money),
        '0',
        DATE_FORMAT( bet_time, '%Y-%m-%d' ),
        '直投',
        '快乐8新版' 
    FROM
        t_qlc_bet 
    WHERE
        issue_code = @qlc 
        AND STATUS_CODE IN ( 1, 3, 7 ) 
    GROUP BY
        place_code 
    ) UNION ALL
    (
    SELECT
        place_code,
        '七乐彩',
        issue_code,
        SUM(bet_money),
        '0',
        DATE_FORMAT( bet_time, '%Y-%m-%d' ),
        '多期',
        '快乐8新版' 
    FROM
        t_multi_details_qlc 
    WHERE
        issue_code = @qlc 
        AND STATUS_CODE IN ( 1, 3, 7 ) 
    GROUP BY
        place_code 
    ) UNION ALL
    (
    SELECT
        place_code,
        '七乐彩',
        issue_code,
        SUM(bet_money),
        '0',
        DATE_FORMAT( BET_TICKET_TIME, '%Y-%m-%d' ),
        '拼号',
        '快乐8新版' 
    FROM
        t_spell_bet 
    WHERE
        issue_code = @qlc 
        AND STATUS_CODE IN ( 1, 3, 7 ) 
        AND GAME_CODE = 'QLC' 
    GROUP BY
        place_code 
    ) UNION ALL
    (
    SELECT
        place_code,
        '双色球',
        issue_code,
        SUM(bet_money),
        '0',
        DATE_FORMAT( bet_time, '%Y-%m-%d' ),
        '直投',
        '快乐8新版' 
    FROM
        t_ssq_bet 
    WHERE
        issue_code = @ssq 
        AND STATUS_CODE IN ( 1, 3, 7 ) 
    GROUP BY
        place_code 
    ) UNION ALL
    (
    SELECT
        place_code,
        '双色球',
        issue_code,
        SUM(bet_money),
        '0',
        DATE_FORMAT( bet_time, '%Y-%m-%d' ),
        '多期',
        '快乐8新版' 
    FROM
        t_multi_details_ssq 
    WHERE
        issue_code = @ssq 
        AND STATUS_CODE IN ( 1, 3, 7 ) 
    GROUP BY
        place_code 
    ) UNION ALL
    (
    SELECT
        place_code,
        '双色球',
        issue_code,
        SUM(bet_money),
        '0',
        DATE_FORMAT( BET_TICKET_TIME, '%Y-%m-%d' ),
        '拼号',
        '快乐8新版' 
    FROM
        t_spell_bet 
    WHERE
        issue_code = @ssq 
        AND STATUS_CODE IN ( 1, 3, 7 ) 
        AND GAME_CODE = 'SSQ' 
    GROUP BY
    place_code 
    )