SELECT
        [tbl_Contact].[Name] AS [ContactName],
        [tbl_Contact].[ID] AS [ContactID],
        (SELECT
                COUNT(*) AS [CountIncident]
        FROM
                [tbl_Incident] AS [tbl_Incident]
        WHERE
                ([tbl_Incident].[OwnerID] = [tbl_Contact].[ID] AND
                [tbl_Incident].[StatusID] = :StatusID AND
                [tbl_Incident].[ActualStart] BETWEEN :FromDate AND :ToDate)) AS [CountIncident],
        (SELECT
                COUNT(*) AS [CompleteIncident]
        FROM
                [tbl_Incident] AS [tbl_Incident]
        WHERE
                ([tbl_Incident].[OwnerID] = [tbl_Contact].[ID] AND
                [tbl_Incident].[StatusID] = :CompleteID AND
                [tbl_Incident].[ActualStart] BETWEEN :FromDate AND :ToDate)) AS [CompleteIncident],
        (SELECT
                COUNT(*) AS [NewIncident]
        FROM
                [tbl_Incident] AS [tbl_Incident]
        WHERE
                ([tbl_Incident].[OwnerID] = [tbl_Contact].[ID] AND
                [tbl_Incident].[StatusID] = :NewID AND
                [tbl_Incident].[ActualStart] BETWEEN :FromDate AND :ToDate)) AS [NewIncident],
        (SELECT
                COUNT(*) AS [TaskCount]
        FROM
                [tbl_Task] AS [tbl_Task]
        WHERE
                ([tbl_Task].[OwnerID] = [tbl_Contact].[ID] AND
                [tbl_Task].[StatusID] = :TaskCancel AND
                [tbl_Task].[ActualStartDate] BETWEEN :FromDate AND :ToDate)) AS [TaskCancel],
        (SELECT
                COUNT(*) AS [TaskCount]
        FROM
                [tbl_Task] AS [tbl_Task]
        WHERE
                ([tbl_Task].[OwnerID] = [tbl_Contact].[ID] AND
                [tbl_Task].[StatusID] = :TaskFinish AND
                [tbl_Task].[ActualStartDate] BETWEEN :FromDate AND :ToDate)) AS [TaskFinish],
        (SELECT
                COUNT(*) AS [TaskCount]
        FROM
                [tbl_Task] AS [tbl_Task]
        WHERE
                ([tbl_Task].[OwnerID] = [tbl_Contact].[ID] AND
                [tbl_Task].[StatusID] = :TaskOpen AND
                [tbl_Task].[ActualStartDate] BETWEEN :FromDate AND :ToDate)) AS [TaskOpen],
        (SELECT
                COUNT(*) AS [TaskCount]
        FROM
                [tbl_Task] AS [tbl_Task]
        WHERE
                ([tbl_Task].[OwnerID] = [tbl_Contact].[ID] AND
                [tbl_Task].[StatusID] = :TaskWork AND
                [tbl_Task].[ActualStartDate] BETWEEN :FromDate AND :ToDate)) AS [TaskWork],
        :FromDate AS [FromDate],
        :ToDate AS [ToDate],
        [tbl_Incident].[ID] AS [ID]
FROM
        [tbl_Contact] AS [tbl_Contact]
LEFT OUTER JOIN
        [tbl_Incident] AS [tbl_Incident] ON [tbl_Incident].[ContactID] = [tbl_Contact].[ID]

SELECT
        [tbl_Screen].[ID] AS [ID],
        [tbl_Screen].[CreatedOn] AS [CreatedOn],
        [tbl_Screen].[CreatedByID] AS [CreatedByID],
        [CreatedBy].[Name] AS [CreatedByName],
        [tbl_Screen].[ModifiedOn] AS [ModifiedOn],
        [tbl_Screen].[ModifiedByID] AS [ModifiedByID],
        [ModifiedBy].[Name] AS [ModifiedByName],
        [tbl_Screen].[Name] AS [Name],
        [tbl_Screen].[ScreenStatusID] AS [ScreenStatusID],
        [ScreenStatus].[STATUS] AS [ScreenStatusName],
        [tbl_Screen].[ScreenOnOffID] AS [ScreenOnOffID],
        [ScreenOnOff].[ScreenOnOff] AS [ScreenOnOffName],
        [tbl_Screen].[RoutionDiscID] AS [RoutionDiscID],
        [RoutineDisconnection].[Name] AS [RoutionDiscName],
        [tbl_Screen].[ScreenPath] AS [ScreenPath],
        [tbl_Screen].[StartRoutineDisconnection] AS [StartRoutineDisconnection],
        [tbl_Screen].[EndRoutineDisconnection] AS [EndRoutineDisconnection],
        CAST(CONVERT(VARCHAR(8), [tbl_Screen].[DeletedOnDate], 112) AS DATETIME) AS [DeletedOnDate],
        [tbl_Screen].[TurnOnDate] AS [TurnOnDate]
FROM
        [dbo].[tbl_Screen] AS [tbl_Screen]
LEFT OUTER JOIN
        [dbo].[tbl_Contact] AS [CreatedBy] ON [CreatedBy].[ID] = [tbl_Screen].[CreatedByID]
LEFT OUTER JOIN
        [dbo].[tbl_Contact] AS [ModifiedBy] ON [ModifiedBy].[ID] = [tbl_Screen].[ModifiedByID]
LEFT OUTER JOIN
        [dbo].[tbl_Resolution] AS [Resolution] ON [Resolution].[ID] = [tbl_Screen].[ResolutionID]
LEFT OUTER JOIN
        [dbo].[tbl_ScreenType] AS [Type] ON [Type].[ID] = [tbl_Screen].[TypeID]
LEFT OUTER JOIN
        [dbo].[tbl_ScreenStatus] AS [ScreenStatus] ON [ScreenStatus].[ID] = [tbl_Screen].[ScreenStatusID]
LEFT OUTER JOIN
        [dbo].[tbl_ScreenOnOff] AS [ScreenOnOff] ON [ScreenOnOff].[ID] = [tbl_Screen].[ScreenOnOffID]
LEFT OUTER JOIN
        [dbo].[tbl_RoutineDisconnection] AS [RoutineDisconnection] ON [RoutineDisconnection].[ID] = [tbl_Screen].[RoutionDiscID]
WHERE((([tbl_Screen].[ScreenStatusID] = :StatusIDIsntWorking AND
        NOT [tbl_Screen].[TurnOnDate] = :TimeIsNull) OR
        [tbl_Screen].[ScreenStatusID] = :StatusIDWorking OR
        ([tbl_Screen].[ScreenStatusID] = :StatusIDDeleting AND
        NOT [tbl_Screen].[DeletedOnDate] = :TimeIsNull) OR
        [tbl_Screen].[ScreenStatusID] = :StatusIDNoConnection))
ORDER BY
        8 ASC