SELECT
                PR.Id AS ProgramId,
                PM.Id AS ProgramModuleId,
                PM.[Name] AS ProgramModuleName
                ,CASE
                    WHEN UEOL.[OrderLineId] IS NULL THEN 1
                    ELSE ISNULL(P.[IsPaid], 0)
                END AS IsPaid,
                CASE
                    WHEN UEOL.[OrderLineId] IS NULL THEN 1
                    ELSE 0
                END AS IsFree,
                PM.[Order] AS [Order]
            FROM        [dbo].[exam_UserExams] UE
            INNER JOIN  [dbo].[exam_ExamModules] EM             ON EM.Id = ue.ExamModuleId AND UE.ClientId = 3918
            INNER JOIN  [dbo].[exam_ProgramProgramModules] PPM  ON EM.ProgramModuleId = PPM.ProgramModuleId
            INNER JOIN  [dbo].[exam_ProgramModules] PM          ON PM.Id = PPM.ProgramModuleId
            INNER JOIN  [dbo].[exam_Programs] PR                ON PR.Id = PPM.ProgramId
            INNER JOIN  [dbo].[exam_CoursePrograms] CP          ON CP.ProgramId = PR.Id AND CP.CourseId = 7
            LEFT JOIN   [dbo].[finance_UserExamOrderLines] UEOL ON UEOL.[UserExamId] = UE.[Id]
            LEFT JOIN   [dbo].[finance_PaymentOrderLines] POL   ON POL.[OrderLineId] = UEOL.[OrderLineId]
            LEFT JOIN   [dbo].[finance_Payments] P              ON P.[Id] = POL.[PaymentId]
            GROUP BY    PR.Id, PM.Id, PM.[Name], PM.ProgramModuleType, PM.[Order], P.[IsPaid], UEOL.[OrderLineId]
            ORDER BY    PM.[Order]