SELECT 
    o.orgname AS 'организация',
    p.tel AS 'номер',
    p.tipe AS 'тип',
    p.ttype AS 'описание',
    COUNT(IF((p.tipe = 'А'
            AND (NOT (d.code != '16' AND d.code != '17'
            AND d.code != '18'
            AND d.code != '19'
            AND d.longz = '00:00:00')
            AND (d.longz >= '00:00:00')))
            OR ((p.tipe = 'BATC' OR p.tipe = 'ВАТС')
            AND (d.longz >= '00:00:10'
            OR ((d.code2 = 'пропущенный')
            OR (d.code2 = 'Пропущенный')))),
        d.id,
        NULL)) AS total2,
    COUNT(IF((p.tipe = 'А' AND (d.longz > '00:00:00'))
            OR ((p.tipe = 'BATC' OR p.tipe = 'ВАТС')
            AND (d.longz > '00:00:10'
            AND (d.code2 = 'успешный'
            OR d.code2 = 'Успешный'))),
        d.id,
        NULL)) AS usp,
    COUNT(IF(((d.code = '17')
            AND (d.longz = '00:00:00')),
        d.id,
        NULL)) AS zan,
    COUNT(IF((p.tipe = 'А'
            AND ((d.code = '16' OR d.code = '18'
            OR d.code = '19'))
            AND d.longz = '00:00:00')
            OR ((p.tipe = 'BATC' OR p.tipe = 'ВАТС')
            AND (d.code2 = 'пропущенный'
            OR d.code2 = 'Пропущенный')),
        d.id,
        NULL)) AS bo
FROM
    (sp_org o
    JOIN sp_phone p ON p.id_org = o.id)
        JOIN
    `data` d ON d.tel = p.id
WHERE
    o.id IN (3)
        AND ((d.date BETWEEN '2020-12-21 00:00' AND '2020-12-21 23:59')
        OR d.date IS NULL)
GROUP BY p.id
ORDER BY o.orgname
;