SELECT
    [Project5].[BookingId] AS [BookingId],
    [Project5].[BookingRef] AS [BookingRef],
    [Project5].[CustomerId] AS [CustomerId],
    [Project5].[FirstName] AS [FirstName],
    [Project5].[LastName] AS [LastName],
    [Project5].[Company] AS [Company],
    [Project5].[Email] AS [Email],
    [Project5].[AccountType] AS [AccountType],
    [Project5].[Price] AS [Price],
    [Project5].[FirstName1] AS [FirstName1],
    [Project5].[LastName1] AS [LastName1],
    [Project5].[PickupLocation_State] AS [PickupLocation_State],
    [Project5].[PickupLocation_Suburb] AS [PickupLocation_Suburb],
    [Project5].[PickupDateTime] AS [PickupDateTime],
    [Project5].[DropLocation_State] AS [DropLocation_State],
    [Project5].[DropLocation_Suburb] AS [DropLocation_Suburb],
    [Project5].[DropDateTime] AS [DropDateTime],
    [Project5].[C2] AS [C1],
    [Project5].[C3] AS [C2],
    [Project5].[DeliverySpeed] AS [DeliverySpeed],
    [Project5].[C4] AS [C3],
    [Project5].[C5] AS [C4],
    [Project5].[C10] AS [C5],
    [Project5].[IsPreAuthorised] AS [IsPreAuthorised],
    [Project5].[C6] AS [C6],
    [Project5].[C7] AS [C7],
    [Project5].[CreatedDateTime] AS [CreatedDateTime],
    [Project5].[PickupActual] AS [PickupActual],
    [Project5].[DropActual] AS [DropActual],
    [Project5].[OrderNumber] AS [OrderNumber],
    [Project5].[DropLocation_ContactName] AS [DropLocation_ContactName],
    [Project5].[C8] AS [C8],
    [Project5].[C9] AS [C9],
    [Project5].[IsInterstate] AS [IsInterstate],
    [Project5].[C11] AS [C10],
    [Project5].[FoodReadyETA] AS [FoodReadyETA],
    [Project5].[Source] AS [Source],
    [Project5].[C12] AS [C11],
    [Project5].[Vehicle] AS [Vehicle],
    [Project5].[IsFreeDelivery] AS [IsFreeDelivery],
    [Project5].[IsIncorrectDrop] AS [IsIncorrectDrop],
    [Project5].[IsCancel] AS [IsCancel]
    FROM ( SELECT
        [Project4].[C1] AS [C1],
        [Project4].[BookingId] AS [BookingId],
        [Project4].[CustomerId] AS [CustomerId],
        [Project4].[PickupLocation_Suburb] AS [PickupLocation_Suburb],
        [Project4].[PickupLocation_State] AS [PickupLocation_State],
        [Project4].[DropLocation_ContactName] AS [DropLocation_ContactName],
        [Project4].[DropLocation_Suburb] AS [DropLocation_Suburb],
        [Project4].[DropLocation_State] AS [DropLocation_State],
        [Project4].[Vehicle] AS [Vehicle],
        [Project4].[PickupDateTime] AS [PickupDateTime],
        [Project4].[DeliverySpeed] AS [DeliverySpeed],
        [Project4].[DropDateTime] AS [DropDateTime],
        [Project4].[Price] AS [Price],
        [Project4].[CreatedDateTime] AS [CreatedDateTime],
        [Project4].[BookingRef] AS [BookingRef],
        [Project4].[Source] AS [Source],
        [Project4].[IsInterstate] AS [IsInterstate],
        [Project4].[IsPreAuthorised] AS [IsPreAuthorised],
        [Project4].[OrderNumber] AS [OrderNumber],
        [Project4].[FoodReadyETA] AS [FoodReadyETA],
        [Project4].[IsCancel] AS [IsCancel],
        [Project4].[IsFreeDelivery] AS [IsFreeDelivery],
        [Project4].[FirstName] AS [FirstName],
        [Project4].[LastName] AS [LastName],
        [Project4].[Email] AS [Email],
        [Project4].[Company] AS [Company],
        [Project4].[AccountType] AS [AccountType],
        [Project4].[DropActual] AS [DropActual],
        [Project4].[PickupActual] AS [PickupActual],
        [Project4].[IsIncorrectDrop] AS [IsIncorrectDrop],
        [Project4].[FirstName1] AS [FirstName1],
        [Project4].[LastName1] AS [LastName1],
        [Project4].[Price] +  CAST( [Project4].[BookingFee] AS decimal(19,0)) AS [C2],
        CASE WHEN ([Project4].[Status] IS NULL) THEN N'' ELSE [Project4].[Status] END AS [C3],
        CASE WHEN ([Project4].[CalculatedPickupETA] IS NULL) THEN [Project4].[PickupETA] ELSE [Project4].[CalculatedPickupETA] END AS [C4],
        CASE WHEN ([Project4].[CalculatedDropETA] IS NULL) THEN [Project4].[DropETA] ELSE [Project4].[CalculatedDropETA] END AS [C5],
        CASE WHEN ([Project4].[Score] IS NULL) THEN 0 ELSE [Project4].[Score] END AS [C6],
        CASE WHEN ([Project4].[SecondaryScore] IS NULL) THEN 0 ELSE [Project4].[SecondaryScore] END AS [C7],
        CASE WHEN ([Project4].[BookingId1] IS NOT NULL) THEN [Project4].[Price1] ELSE [Project4].[CourierPrice] END AS [C8],
        CASE WHEN (([Project4].[IsPreAuthorised] <> 1) AND ((0 = [Project4].[Source]) OR (8 = [Project4].[Source]) OR (9 = [Project4].[Source])) AND (1 = [Project4].[AccountType]) AND (([Project4].[Status] IS NULL) OR ((LEN([Project4].[Status])) = 0))) THEN cast(1 as bit) WHEN ( NOT (([Project4].[IsPreAuthorised] <> 1) AND ((0 = [Project4].[Source]) OR (8 = [Project4].[Source]) OR (9 = [Project4].[Source])) AND (1 = [Project4].[AccountType]) AND (([Project4].[Status] IS NULL) OR ((LEN([Project4].[Status])) = 0)))) THEN cast(0 as bit) END AS [C9],
        [Project4].[C2] AS [C10],
        [Project4].[C3] AS [C11],
        [Project4].[C4] AS [C12]
        FROM ( SELECT
            [Project3].[C1] AS [C1],
            [Project3].[BookingId] AS [BookingId],
            [Project3].[CustomerId] AS [CustomerId],
            [Project3].[PickupLocation_Suburb] AS [PickupLocation_Suburb],
            [Project3].[PickupLocation_State] AS [PickupLocation_State],
            [Project3].[DropLocation_ContactName] AS [DropLocation_ContactName],
            [Project3].[DropLocation_Suburb] AS [DropLocation_Suburb],
            [Project3].[DropLocation_State] AS [DropLocation_State],
            [Project3].[Vehicle] AS [Vehicle],
            [Project3].[PickupDateTime] AS [PickupDateTime],
            [Project3].[DeliverySpeed] AS [DeliverySpeed],
            [Project3].[DropDateTime] AS [DropDateTime],
            [Project3].[Price] AS [Price],
            [Project3].[CreatedDateTime] AS [CreatedDateTime],
            [Project3].[BookingRef] AS [BookingRef],
            [Project3].[Source] AS [Source],
            [Project3].[IsInterstate] AS [IsInterstate],
            [Project3].[BookingFee] AS [BookingFee],
            [Project3].[IsPreAuthorised] AS [IsPreAuthorised],
            [Project3].[OrderNumber] AS [OrderNumber],
            [Project3].[FoodReadyETA] AS [FoodReadyETA],
            [Project3].[IsCancel] AS [IsCancel],
            [Project3].[IsFreeDelivery] AS [IsFreeDelivery],
            [Project3].[CourierPrice] AS [CourierPrice],
            [Project3].[FirstName] AS [FirstName],
            [Project3].[LastName] AS [LastName],
            [Project3].[Email] AS [Email],
            [Project3].[Company] AS [Company],
            [Project3].[AccountType] AS [AccountType],
            [Project3].[BookingId1] AS [BookingId1],
            [Project3].[Status] AS [Status],
            [Project3].[Price1] AS [Price1],
            [Project3].[PickupETA] AS [PickupETA],
            [Project3].[DropETA] AS [DropETA],
            [Project3].[DropActual] AS [DropActual],
            [Project3].[PickupActual] AS [PickupActual],
            [Project3].[CalculatedPickupETA] AS [CalculatedPickupETA],
            [Project3].[CalculatedDropETA] AS [CalculatedDropETA],
            [Project3].[IsIncorrectDrop] AS [IsIncorrectDrop],
            [Project3].[FirstName1] AS [FirstName1],
            [Project3].[LastName1] AS [LastName1],
            [Project3].[Score] AS [Score],
            [Project3].[SecondaryScore] AS [SecondaryScore],
            [Project3].[C2] AS [C2],
            [Project3].[C3] AS [C3],
            (SELECT
                COUNT(1) AS [A1]
                FROM [dbo].[BookingSMSAudits] AS [Extent9]
                WHERE ([Project3].[BookingId] = [Extent9].[BookingId]) AND ( NOT (([Extent9].[Status] IS NULL) OR ((LEN([Extent9].[Status])) = 0))) AN...