SELECT
            operator_id, operator_number
        FROM (
                SELECT DISTINCT a.operator_id, uon.prefix AS operator_number
                FROM sber.dbo.sb_strah_ank a WITH(nolock)
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = a.operator_uid
                WHERE 1=1
                AND tematika IS NOT NULL
                AND call_time >='20180120'
                AND call_time <'20180321'
                AND a.operator_id IN (SELECT Name AS Name FROM oktell_settings..A_Users)
                UNION ALL
                SELECT DISTINCT u.Name, uon.prefix AS operator_number
                FROM sb_strah.common.CALL c WITH(nolock)
                LEFT JOIN oktell_settings.dbo.A_Users u WITH(nolock) ON u.id = c.operator_id
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = u.id
                WHERE 1=1
                AND task_id = '5726DBC4-201C-403B-A731-094985DDDEDE'
                AND dt_call >='20180120'
                AND dt_call <'20180321'
                AND u.Name NOT IN ('admin')
                UNION ALL
                SELECT DISTINCT u.Name, uon.prefix AS operator_number
                FROM sb_strah.common.CALL c WITH(nolock)
                LEFT JOIN oktell_settings.dbo.A_Users u WITH(nolock) ON u.id = c.operator_id
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = u.id
                WHERE 1=1
                AND task_id = '8284ED9A-7C81-423C-B161-0EF301282C5E'
                AND dt_call >='20180120'
                AND dt_call <'20180321'
                AND u.Name NOT IN ('admin')
                UNION ALL
                SELECT DISTINCT u.Name, uon.prefix AS operator_number
                FROM sb_strah.common.CALL c WITH(nolock)
                LEFT JOIN oktell_settings.dbo.A_Users u WITH(nolock) ON u.id = c.operator_id
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = u.id
                WHERE 1=1
                AND task_id = '48713AFE-3983-491E-9746-1223E789C619'
                AND dt_call >='20180120'
                AND dt_call <'20180321'
                AND u.Name NOT IN ('admin')
                UNION ALL
                SELECT DISTINCT u.Name, uon.prefix AS operator_number
                FROM sb_strah.common.CALL c WITH(nolock)
                LEFT JOIN oktell_settings.dbo.A_Users u WITH(nolock) ON u.id = c.operator_id
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = u.id
                WHERE 1=1
                AND task_id = 'F2309E7E-2AE1-4BB3-8FC6-166AB2546AE5'
                AND dt_call >='20180120'
                AND dt_call <'20180321'
                AND u.Name NOT IN ('admin')
                UNION ALL
                SELECT DISTINCT u.Name, uon.prefix AS operator_number
                FROM sb_strah.common.CALL c WITH(nolock)
                LEFT JOIN oktell_settings.dbo.A_Users u WITH(nolock) ON u.id = c.operator_id
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = u.id
                WHERE 1=1
                AND task_id = 'B1BEBBD8-2790-4106-BFA2-1E2FBE9F45A5'
                AND dt_call >='20180120'
                AND dt_call <'20180321'
                AND u.Name NOT IN ('admin')
                UNION ALL
                SELECT DISTINCT u.Name, uon.prefix AS operator_number
                FROM sb_strah.common.CALL c WITH(nolock)
                LEFT JOIN oktell_settings.dbo.A_Users u WITH(nolock) ON u.id = c.operator_id
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = u.id
                WHERE 1=1
                AND task_id = '90FB8825-0E46-4F8D-92CB-2FF739BABED7'
                AND dt_call >='20180120'
                AND dt_call <'20180321'
                AND u.Name NOT IN ('admin')
                UNION ALL
                SELECT DISTINCT u.Name, uon.prefix AS operator_number
                FROM sb_strah.common.CALL c WITH(nolock)
                LEFT JOIN oktell_settings.dbo.A_Users u WITH(nolock) ON u.id = c.operator_id
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = u.id
                WHERE 1=1
                AND task_id = 'C066362A-AE07-43FC-9820-3268624A81EC'
                AND dt_call >='20180120'
                AND dt_call <'20180321'
                AND u.Name NOT IN ('admin')
                UNION ALL
                SELECT DISTINCT u.Name, uon.prefix AS operator_number
                FROM sb_strah.common.CALL c WITH(nolock)
                LEFT JOIN oktell_settings.dbo.A_Users u WITH(nolock) ON u.id = c.operator_id
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = u.id
                WHERE 1=1
                AND task_id = '121A4F7F-B143-4BA2-A776-354F28445B57'
                AND dt_call >='20180120'
                AND dt_call <'20180321'
                AND u.Name NOT IN ('admin')
                UNION ALL
                SELECT DISTINCT u.Name, uon.prefix AS operator_number
                FROM sb_strah.common.CALL c WITH(nolock)
                LEFT JOIN oktell_settings.dbo.A_Users u WITH(nolock) ON u.id = c.operator_id
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = u.id
                WHERE 1=1
                AND task_id = '20DFD704-BEB3-48AC-B900-3D4B00F7EDCD'
                AND dt_call >='20180120'
                AND dt_call <'20180321'
                AND u.Name NOT IN ('admin')
                UNION ALL
                SELECT DISTINCT u.Name, uon.prefix AS operator_number
                FROM sb_strah.common.CALL c WITH(nolock)
                LEFT JOIN oktell_settings.dbo.A_Users u WITH(nolock) ON u.id = c.operator_id
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = u.id
                WHERE 1=1
                AND task_id = 'FC168E48-F6C2-4E8B-B8F9-40627F57A8DA'
                AND dt_call >='20180120'
                AND dt_call <'20180321'
                AND u.Name NOT IN ('admin')
                UNION ALL
                SELECT DISTINCT u.Name, uon.prefix AS operator_number
                FROM sb_strah.common.CALL c WITH(nolock)
                LEFT JOIN oktell_settings.dbo.A_Users u WITH(nolock) ON u.id = c.operator_id
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = u.id
                WHERE 1=1
                AND task_id = 'EB89AF1A-C2B9-4692-9AB7-4272DB12B5BE'
                AND dt_call >='20180120'
                AND dt_call <'20180321'
                AND u.Name NOT IN ('admin')
                UNION ALL
                SELECT DISTINCT u.Name, uon.prefix AS operator_number
                FROM sb_strah.common.CALL c WITH(nolock)
                LEFT JOIN oktell_settings.dbo.A_Users u WITH(nolock) ON u.id = c.operator_id
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = u.id
                WHERE 1=1
                AND task_id = 'E26B7C95-E5DB-469D-BD67-4B8549B7AA09'
                AND dt_call >='20180120'
                AND dt_call <'20180321'
                AND u.Name NOT IN ('admin')
                UNION ALL
                SELECT DISTINCT u.Name, uon.prefix AS operator_number
                FROM sb_strah.common.CALL c WITH(nolock)
                LEFT JOIN oktell_settings.dbo.A_Users u WITH(nolock) ON u.id = c.operator_id
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = u.id
                WHERE 1=1
                AND task_id = 'B45AEA88-F3D4-40B1-BD8C-4BE9C1DE9181'
                AND dt_call >='20180120'
                AND dt_call <'20180321'
                AND u.Name NOT IN ('admin')
                UNION ALL
                SELECT DISTINCT u.Name, uon.prefix AS operator_number
                FROM sb_strah.common.CALL c WITH(nolock)
                LEFT JOIN oktell_settings.dbo.A_Users u WITH(nolock) ON u.id = c.operator_id
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = u.id
                WHERE 1=1
                AND task_id = '365FF6A9-0335-4DCC-A27D-5333181918F9'
                AND dt_call >='20180120'
                AND dt_call <'20180321'
                AND u.Name NOT IN ('admin')
                UNION ALL
                SELECT DISTINCT u.Name, uon.prefix AS operator_number
                FROM sb_strah.common.CALL c WITH(nolock)
                LEFT JOIN oktell_settings.dbo.A_Users u WITH(nolock) ON u.id = c.operator_id
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = u.id
                WHERE 1=1
                AND task_id = 'BCFACAA2-0285-4514-96E1-62C0755B8710'
                AND dt_call >='20180120'
                AND dt_call <'20180321'
                AND u.Name NOT IN ('admin')
                UNION ALL
                SELECT DISTINCT u.Name, uon.prefix AS operator_number
                FROM sb_strah.common.CALL c WITH(nolock)
                LEFT JOIN oktell_settings.dbo.A_Users u WITH(nolock) ON u.id = c.operator_id
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = u.id
                WHERE 1=1
                AND task_id = 'C5646BB6-B6BF-4827-8782-642F57DB5322'
                AND dt_call >='20180120'
                AND dt_call <'20180321'
                AND u.Name NOT IN ('admin')
                UNION
                SELECT DISTINCT a.operator_id, uon.prefix AS operator_number
                FROM sber.dbo.sb_strah_ank a WITH(nolock)
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = a.operator_uid
                WHERE 1=1
                AND tematika IS NOT NULL
                AND call_time >='20180120'
                AND call_time <'20180321'
                AND a.operator_id IN (SELECT Name AS Name FROM oktell_settings..A_Users)
                UNION ALL
                SELECT DISTINCT u.Name, uon.prefix AS operator_number
                FROM sb_strah.common.CALL c WITH(nolock)
                LEFT JOIN oktell_settings.dbo.A_Users u WITH(nolock) ON u.id = c.operator_id
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = u.id
                WHERE 1=1
                AND task_id = '2AAD55A5-CB75-47B0-8898-6F3D8F1BD7F5'
                AND dt_call >='20180120'
                AND dt_call <'20180321'
                AND u.Name NOT IN ('admin')
                UNION ALL
                SELECT DISTINCT u.Name, uon.prefix AS operator_number
                FROM sb_strah.common.CALL c WITH(nolock)
                LEFT JOIN oktell_settings.dbo.A_Users u WITH(nolock) ON u.id = c.operator_id
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = u.id
                WHERE 1=1
                AND task_id = 'AF556FA3-FC2E-4C2D-8141-760C39A29953'
                AND dt_call >='20180120'
                AND dt_call <'20180321'
                AND u.Name NOT IN ('admin')
                UNION ALL
                SELECT DISTINCT u.Name, uon.prefix AS operator_number
                FROM sb_strah.common.CALL c WITH(nolock)
                LEFT JOIN oktell_settings.dbo.A_Users u WITH(nolock) ON u.id = c.operator_id
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = u.id
                WHERE 1=1
                AND task_id = '6326224B-7774-4BDA-9A15-8BBF24038380'
                AND dt_call >='20180120'
                AND dt_call <'20180321'
                AND u.Name NOT IN ('admin')
                UNION
                SELECT DISTINCT a.operator_id, uon.prefix AS operator_number
                FROM sber.dbo.sb_strah_ank a WITH(nolock)
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = a.operator_uid
                WHERE 1=1
                AND tematika IS NOT NULL
                AND call_time >='20180120'
                AND call_time <'20180321'
                AND a.operator_id IN (SELECT Name AS Name FROM oktell_settings..A_Users)
                UNION ALL
                SELECT DISTINCT u.Name, uon.prefix AS operator_number
                FROM sb_strah.common.CALL c WITH(nolock)
                LEFT JOIN oktell_settings.dbo.A_Users u WITH(nolock) ON u.id = c.operator_id
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = u.id
                WHERE 1=1
                AND task_id = 'EE4A4EF0-367B-4AF0-8B57-A007E43C6AF6'
                AND dt_call >='20180120'
                AND dt_call <'20180321'
                AND u.Name NOT IN ('admin')
                UNION ALL
                SELECT DISTINCT u.Name, uon.prefix AS operator_number
                FROM sb_strah.common.CALL c WITH(nolock)
                LEFT JOIN oktell_settings.dbo.A_Users u WITH(nolock) ON u.id = c.operator_id
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = u.id
                WHERE 1=1
                AND task_id = '11D07265-7A46-438C-90B0-A604905CBD02'
                AND dt_call >='20180120'
                AND dt_call <'20180321'
                AND u.Name NOT IN ('admin')
                UNION ALL
                SELECT DISTINCT u.Name, uon.prefix AS operator_number
                FROM sb_strah.common.CALL c WITH(nolock)
                LEFT JOIN oktell_settings.dbo.A_Users u WITH(nolock) ON u.id = c.operator_id
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = u.id
                WHERE 1=1
                AND task_id = 'E8BC42AF-2642-41FE-8756-ACC338546739'
                AND dt_call >='20180120'
                AND dt_call <'20180321'
                AND u.Name NOT IN ('admin')
                UNION ALL
                SELECT DISTINCT u.Name, uon.prefix AS operator_number
                FROM sb_strah.common.CALL c WITH(nolock)
                LEFT JOIN oktell_settings.dbo.A_Users u WITH(nolock) ON u.id = c.operator_id
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = u.id
                WHERE 1=1
                AND task_id = '17403199-B21C-4892-85D1-BF02195DCB03'
                AND dt_call >='20180120'
                AND dt_call <'20180321'
                AND u.Name NOT IN ('admin')
                UNION
                SELECT DISTINCT a.operator_id, uon.prefix AS operator_number
                FROM sber.dbo.sb_strah_ank a WITH(nolock)
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = a.operator_uid
                WHERE 1=1
                AND tematika IS NOT NULL
                AND call_time >='20180120'
                AND call_time <'20180321'
                AND a.operator_id IN (SELECT Name AS Name FROM oktell_settings..A_Users)
                UNION ALL
                SELECT DISTINCT u.Name, uon.prefix AS operator_number
                FROM sb_strah.common.CALL c WITH(nolock)
                LEFT JOIN oktell_settings.dbo.A_Users u WITH(nolock) ON u.id = c.operator_id
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = u.id
                WHERE 1=1
                AND task_id = '11AD5DA8-AAD0-4EB5-99BE-C3C482590AAC'
                AND dt_call >='20180120'
                AND dt_call <'20180321'
                AND u.Name NOT IN ('admin')
                UNION ALL
                SELECT DISTINCT u.Name, uon.prefix AS operator_number
                FROM sb_strah.common.CALL c WITH(nolock)
                LEFT JOIN oktell_settings.dbo.A_Users u WITH(nolock) ON u.id = c.operator_id
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = u.id
                WHERE 1=1
                AND task_id = 'E6086E00-13FF-4E82-B677-CEF60AD989A3'
                AND dt_call >='20180120'
                AND dt_call <'20180321'
                AND u.Name NOT IN ('admin')
                UNION ALL
                SELECT DISTINCT u.Name, uon.prefix AS operator_number
                FROM sb_strah.common.CALL c WITH(nolock)
                LEFT JOIN oktell_settings.dbo.A_Users u WITH(nolock) ON u.id = c.operator_id
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = u.id
                WHERE 1=1
                AND task_id = '6C36B267-4AAC-4A79-B5CA-D9ED1D36BEBF'
                AND dt_call >='20180120'
                AND dt_call <'20180321'
                AND u.Name NOT IN ('admin')
                UNION ALL
                SELECT DISTINCT u.Name, uon.prefix AS operator_number
                FROM sb_strah.common.CALL c WITH(nolock)
                LEFT JOIN oktell_settings.dbo.A_Users u WITH(nolock) ON u.id = c.operator_id
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = u.id
                WHERE 1=1
                AND task_id = '68F02C84-1CFB-4BBA-9874-DBF4D169C6E8'
                AND dt_call >='20180120'
                AND dt_call <'20180321'
                AND u.Name NOT IN ('admin')
                UNION
                SELECT DISTINCT a.operator_id, uon.prefix AS operator_number
                FROM sber.dbo.sb_strah_ank a WITH(nolock)
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = a.operator_uid
                WHERE 1=1
                AND tematika IS NOT NULL
                AND call_time >='20180120'
                AND call_time <'20180321'
                AND a.operator_id IN (SELECT Name AS Name FROM oktell_settings..A_Users)
                UNION
                SELECT DISTINCT a.operator_id, uon.prefix AS operator_number
                FROM sber.dbo.sb_strah_out_ank a WITH(nolock)
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = a.operator_uid
                WHERE 1=1
                AND tematika IS NOT NULL
                AND call_time >='20180120'
                AND call_time <'20180321'
                AND a.operator_id IN (SELECT Name AS Name FROM oktell_settings..A_Users)
                UNION ALL
                SELECT DISTINCT u.Name, uon.prefix AS operator_number
                FROM sb_strah.common.CALL c WITH(nolock)
                LEFT JOIN oktell_settings.dbo.A_Users u WITH(nolock) ON u.id = c.operator_id
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = u.id
                WHERE 1=1
                AND task_id = '634E84D0-168F-4D46-B179-E15D95BC9362'
                AND dt_call >='20180120'
                AND dt_call <'20180321'
                AND u.Name NOT IN ('admin')
                UNION ALL
                SELECT DISTINCT u.Name, uon.prefix AS operator_number
                FROM sb_strah.common.CALL c WITH(nolock)
                LEFT JOIN oktell_settings.dbo.A_Users u WITH(nolock) ON u.id = c.operator_id
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = u.id
                WHERE 1=1
                AND task_id = '09CB26D5-DB2B-438E-84E3-EBF63D407ABC'
                AND dt_call >='20180120'
                AND dt_call <'20180321'
                AND u.Name NOT IN ('admin')
                UNION
                SELECT DISTINCT a.operator_id, uon.prefix AS operator_number
                FROM sber.dbo.sb_strah_out_ank a WITH(nolock)
                LEFT JOIN utils..operator_numbers uon ON uon.operator_id = a.operator_uid
                WHERE 1=1
                AND tematika IS NOT NULL
                AND call_time >='20180120'
                AND call_time <'20180321'
                AND a.operator_id IN (SELECT Name AS Name FROM oktell_settings..A_Users)
                ) u
        ORDER BY operator_id