Error

SELECT
    [GroupBy1].[A1] AS [C1]
    FROM ( SELECT
        COUNT([Limit1].[C2]) AS [A1]
        FROM ( SELECT TOP (10) [Project1].[C2] AS [C2]
            FROM ( SELECT
                NEWID() AS [C1],
                1 AS [C2]
                FROM [dbo].[VehicleOffers] AS [Extent1]
            )  AS [Project1]
            ORDER BY [Project1].[C1] DESC
        )  AS [Limit1]
    )  AS [GroupBy1]


-- Executing asynchronously at 02.11.2016 20:42:03 +01:00



SELECT
    [UnionAll1].[Id] AS [C1],
    [UnionAll1].[Id1] AS [C2],
    [UnionAll1].[Id2] AS [C3],
    [UnionAll1].[Id3] AS [C4],
    [UnionAll1].[CategoryId] AS [C5],
    [UnionAll1].[C3] AS [C6],
    [UnionAll1].[Id4] AS [C7],
    [UnionAll1].[Authorization] AS [C8],
    [UnionAll1].[Price] AS [C9],
    [UnionAll1].[Title] AS [C10],
    [UnionAll1].[Description] AS [C11],
    [UnionAll1].[Edited] AS [C12],
    [UnionAll1].[Added] AS [C13],
    [UnionAll1].[EndDate] AS [C14],
    [UnionAll1].[IsAccepted] AS [C15],
    [UnionAll1].[CategoryId1] AS [C16],
    [UnionAll1].[OfferQrCodeId] AS [C17],
    [UnionAll1].[SellerId] AS [C18],
    [UnionAll1].[PromotionLeft] AS [C19],
    [UnionAll1].[UnregisterUserInfoId] AS [C20],
    [UnionAll1].[CommentsEnabled] AS [C21],
    [UnionAll1].[CommentsModerated] AS [C22],
    [UnionAll1].[UseState] AS [C23],
    [UnionAll1].[FirstRegistration] AS [C24],
    [UnionAll1].[FirstPolandRegistration] AS [C25],
    [UnionAll1].[Places] AS [C26],
    [UnionAll1].[Doors] AS [C27],
    [UnionAll1].[Year] AS [C28],
    [UnionAll1].[CarMakeId] AS [C29],
    [UnionAll1].[CarModelId] AS [C30],
    [UnionAll1].[CarGenerationId] AS [C31],
    [UnionAll1].[VehicleBodyworkId] AS [C32],
    [UnionAll1].[CarBodyworkColorId] AS [C33],
    [UnionAll1].[CarBodyworkPaintId] AS [C34],
    [UnionAll1].[CarEngineId] AS [C35],
    [UnionAll1].[OriginCountry] AS [C36],
    [UnionAll1].[FirstRegistrationCountry] AS [C37],
    [UnionAll1].[CurrentRegistrationCountry] AS [C38],
    [UnionAll1].[GearboxId] AS [C39],
    [UnionAll1].[Gears] AS [C40],
    [UnionAll1].[EngineHorsePowers] AS [C41],
    [UnionAll1].[EngineCapacity] AS [C42],
    [UnionAll1].[EngineFuel] AS [C43],
    [UnionAll1].[Segment] AS [C44],
    [UnionAll1].[CarState] AS [C45],
    [UnionAll1].[Mileage] AS [C46],
    [UnionAll1].[CarStatusId] AS [C47],
    [UnionAll1].[WheelDriveId] AS [C48],
    [UnionAll1].[VinNumber] AS [C49],
    [UnionAll1].[Id5] AS [C50],
    [UnionAll1].[Name] AS [C51],
    [UnionAll1].[Id6] AS [C52],
    [UnionAll1].[Name1] AS [C53],
    [UnionAll1].[MakeId] AS [C54],
    [UnionAll1].[CategoryId2] AS [C55],
    [UnionAll1].[Segment1] AS [C56],
    [UnionAll1].[IsMaintained] AS [C57],
    [UnionAll1].[Id7] AS [C58],
    [UnionAll1].[Name2] AS [C59],
    [UnionAll1].[CarModelId1] AS [C60],
    [UnionAll1].[Segment2] AS [C61],
    [UnionAll1].[IsMaintained1] AS [C62],
    [UnionAll1].[C4] AS [C63],
    [UnionAll1].[Id8] AS [C64],
    [UnionAll1].[Name3] AS [C65],
    [UnionAll1].[Capacity] AS [C66],
    [UnionAll1].[HorsePowers] AS [C67],
    [UnionAll1].[Fuel] AS [C68],
    [UnionAll1].[C5] AS [C69],
    [UnionAll1].[C6] AS [C70],
    [UnionAll1].[Id9] AS [C71],
    [UnionAll1].[Order] AS [C72],
    [UnionAll1].[Hide] AS [C73],
    [UnionAll1].[Name4] AS [C74],
    [UnionAll1].[C1] AS [C75],
    [UnionAll1].[Id10] AS [C76],
    [UnionAll1].[Name5] AS [C77],
    [UnionAll1].[Price1] AS [C78],
    [UnionAll1].[ReplacedIn] AS [C79],
    [UnionAll1].[QuantityInCycle] AS [C80],
    [UnionAll1].[C7] AS [C81],
    [UnionAll1].[C8] AS [C82],
    [UnionAll1].[C9] AS [C83],
    [UnionAll1].[C10] AS [C84],
    [UnionAll1].[C11] AS [C85],
    [UnionAll1].[C12] AS [C86],
    [UnionAll1].[C13] AS [C87]
    FROM  (SELECT
        CASE WHEN ([Join9].[Promotion_Id] IS NULL) THEN CAST(NULL AS int) ELSE 1 END AS [C1],
        [Limit1].[C1] AS [C2],
        [Limit1].[Id1] AS [Id],
        [Limit1].[Id6] AS [Id1],
        [Limit1].[Id7] AS [Id2],
        [Limit1].[Id5] AS [Id3],
        [Limit1].[CategoryId] AS [CategoryId],
        [Limit1].[C2] AS [C3],
        [Limit1].[Id] AS [Id4],
        [Limit1].[Authorization] AS [Authorization],
        [Limit1].[Price] AS [Price],
        [Limit1].[Title] AS [Title],
        [Limit1].[Description] AS [Description],
        [Limit1].[Edited] AS [Edited],
        [Limit1].[Added] AS [Added],
        [Limit1].[EndDate] AS [EndDate],
        [Limit1].[IsAccepted] AS [IsAccepted],
        [Limit1].[CategoryId] AS [CategoryId1],
        [Limit1].[OfferQrCodeId] AS [OfferQrCodeId],
        [Limit1].[SellerId] AS [SellerId],
        [Limit1].[PromotionLeft] AS [PromotionLeft],
        [Limit1].[UnregisterUserInfoId] AS [UnregisterUserInfoId],
        [Limit1].[CommentsEnabled] AS [CommentsEnabled],
        [Limit1].[CommentsModerated] AS [CommentsModerated],
        [Limit1].[UseState] AS [UseState],
        [Limit1].[FirstRegistration] AS [FirstRegistration],
        [Limit1].[FirstPolandRegistration] AS [FirstPolandRegistration],
        [Limit1].[Places] AS [Places],
        [Limit1].[Doors] AS [Doors],
        [Limit1].[Year] AS [Year],
        [Limit1].[CarMakeId] AS [CarMakeId],
        [Limit1].[CarModelId] AS [CarModelId],
        [Limit1].[CarGenerationId] AS [CarGenerationId],
        [Limit1].[VehicleBodyworkId] AS [VehicleBodyworkId],
        [Limit1].[CarBodyworkColorId] AS [CarBodyworkColorId],
        [Limit1].[CarBodyworkPaintId] AS [CarBodyworkPaintId],
        [Limit1].[CarEngineId] AS [CarEngineId],
        [Limit1].[OriginCountry] AS [OriginCountry],
        [Limit1].[FirstRegistrationCountry] AS [FirstRegistrationCountry],
        [Limit1].[CurrentRegistrationCountry] AS [CurrentRegistrationCountry],
        [Limit1].[GearboxId] AS [GearboxId],
        [Limit1].[Gears] AS [Gears],
        [Limit1].[EngineHorsePowers] AS [EngineHorsePowers],
        [Limit1].[EngineCapacity] AS [EngineCapacity],
        [Limit1].[EngineFuel] AS [EngineFuel],
        [Limit1].[Segment] AS [Segment],
        [Limit1].[CarState] AS [CarState],
        [Limit1].[Mileage] AS [Mileage],
        [Limit1].[CarStatusId] AS [CarStatusId],
        [Limit1].[WheelDriveId] AS [WheelDriveId],
        [Limit1].[VinNumber] AS [VinNumber],
        [Limit1].[Id2] AS [Id5],
        [Limit1].[Name] AS [Name],
        [Limit1].[Id3] AS [Id6],
        [Limit1].[Name1] AS [Name1],
        [Limit1].[MakeId] AS [MakeId],
        [Limit1].[CategoryId1] AS [CategoryId2],
        [Limit1].[Segment1] AS [Segment1],
        [Limit1].[IsMaintained] AS [IsMaintained],
        [Limit1].[Id4] AS [Id7],
        [Limit1].[Name2] AS [Name2],
        [Limit1].[CarModelId1] AS [CarModelId1],
        [Limit1].[Segment2] AS [Segment2],
        [Limit1].[IsMaintained1] AS [IsMaintained1],
        [Limit1].[C3] AS [C4],
        [Limit1].[Id5] AS [Id8],
        [Limit1].[Name3] AS [Name3],
        [Limit1].[Capacity] AS [Capacity],
        [Limit1].[HorsePowers] AS [HorsePowers],
        [Limit1].[Fuel] AS [Fuel],
        [Limit1].[C4] AS [C5],
        [Limit1].[C5] AS [C6],
        [Limit1].[Id8] AS [Id9],
        [Limit1].[Order] AS [Order],
        [Limit1].[Hide] AS [Hide],
        [Limit1].[Name4] AS [Name4],
        [Join9].[Id] AS [Id10],
        [Join9].[Name] AS [Name5],
        [Join9].[Price] AS [Price1],
        [Join9].[ReplacedIn] AS [ReplacedIn],
        [Join9].[QuantityInCycle] AS [QuantityInCycle],
        CAST(NULL AS varchar(1)) AS [C7],
        CAST(NULL AS bigint) AS [C8],
        CAST(NULL AS varchar(1)) AS [C9],
        CAST(NULL AS varchar(1)) AS [C10],
        CAST(NULL AS bigint) AS [C11],
        CAST(NULL AS varchar(1)) AS [C12],
        CAST(NULL AS datetime2) AS [C13]
        FROM   (SELECT TOP (10) [Project3].[C1] AS [C1], [Project3].[Id] AS [Id], [Project3].[Authorization] AS [Authorization], [Project3].[Price] AS [Price], [Project3].[Title] AS [Title], [Project3].[Description] AS [Description], [Project3].[Edited] AS [Edited], [Project3].[Added] AS [Added], [Project3].[EndDate] AS [EndDate], [Project3].[IsAccepted] AS [IsAccepted], [Project3].[CategoryId] AS [CategoryId], [Project3].[OfferQrCodeId] AS [OfferQrCodeId], [Project3].[SellerId] AS [SellerId], [Project3].[PromotionLeft] AS [PromotionLeft], [Project3].[UnregisterUserInfoId] AS [UnregisterUserInfoId], [Project3].[CommentsEnabled] AS [CommentsEnabled], [Project3].[CommentsModerated] AS [CommentsModerated], [Project3].[UseState] AS [UseState], [Project3].[Id1] AS [Id1], [Project3].[FirstRegistration] AS [FirstRegistration], [Project3].[FirstPolandRegistration] AS [FirstPolandRegistration], [Project3].[Places] AS [Places], [Project3].[Doors] AS [Doors], [Project3].[Year] AS [Year], [Project3].[CarMakeId] AS [CarMakeId], [Project3].[CarModelId] AS [CarModelId], [Project3].[CarGenerationId] AS [CarGenerationId], [Project3].[VehicleBodyworkId] AS [VehicleBodyworkId], [Project3].[CarBodyworkColorId] AS [CarBodyworkColorId], [Project3].[CarBodyworkPaintId] AS [CarBodyworkPaintId], [Project3].[CarEngineId] AS [CarEngineId], [Project3].[OriginCountry] AS [OriginCountry], [Project3].[FirstRegistrationCountry] AS [FirstRegistrationCountry], [Project3].[CurrentRegistrationCountry] AS [CurrentRegistrationCountry], [Project3].[GearboxId] AS [GearboxId], [Project3].[Gears] AS [Gears], [Project3].[EngineHorsePowers] AS [EngineHorsePowers], [Project3].[EngineCapacity] AS [EngineCapacity], [Project3].[EngineFuel] AS [EngineFuel], [Project3].[Segment] AS [Segment], [Project3].[CarState] AS [CarState], [Project3].[Mileage] AS [Mileage], [Project3].[CarStatusId] AS [CarStatusId], [Project3].[WheelDriveId] AS [WheelDriveId], [Project3].[VinNumber] AS [VinNumber], [Project3].[C2] AS [C2], [Project3].[Id2] AS [Id2], [Project3].[Name] AS [Name], [Project3].[Id3] AS [Id3], [Project3].[Name1] AS [Name1], [Project3].[MakeId] AS [MakeId], [Project3].[CategoryId1] AS [CategoryId1], [Project3].[Segment1] AS [Segment1], [Project3].[IsMaintained] AS [IsMaintained], [Project3].[Id4] AS [Id4], [Project3].[Name2] AS [Name2], [Project3].[CarModelId1] AS [CarModelId1], [Project3].[Segment2] AS [Segment2], [Project3].[IsMaintained1] AS [IsMaintained1], [Project3].[Id5] AS [Id5], [Project3].[Name3] AS [Name3], [Project3].[Capacity] AS [Capacity], [Project3].[HorsePowers] AS [HorsePowers], [Project3].[Fuel] AS [Fuel], [Project3].[Id6] AS [Id6], [Project3].[Id7] AS [Id7], [Project3].[C3] AS [C3], [Project3].[C4] AS [C4], [Project3].[C5] AS [C5], [Project3].[Id8] AS [Id8], [Project3].[Order] AS [Order], [Project3].[Hide] AS [Hide], [Project3].[Name4] AS [Name4]
            FROM ( SELECT
                NEWID() AS [C1],
                [Extent1].[Id] AS [Id],
                [Extent1].[Authorization] AS [Authorization],
                [Extent1].[Price] AS [Price],
                [Extent1].[Title] AS [Title],
                [Extent1].[Description] AS [Description],
                [Extent1].[Edited] AS [Edited],
                [Extent1].[Added] AS [Added],
                [Extent1].[EndDate] AS [EndDate],
                [Extent1].[IsAccepted] AS [IsAccepted],
                [Extent1].[CategoryId] AS [CategoryId],
                [Extent1].[OfferQrCodeId] AS [OfferQrCodeId],
                [Extent1].[SellerId] AS [SellerId],
                [Extent1].[PromotionLeft] AS [PromotionLeft],
                [Extent1].[UnregisterUserInfoId] AS [UnregisterUserInfoId],
                [Extent1].[CommentsEnabled] AS [CommentsEnabled],
                [Extent1].[CommentsModerated] AS [CommentsModerated],
                [Extent1].[UseState] AS [UseState],
                [Extent2].[Id] AS [Id1],
                [Extent2].[FirstRegistration] AS [FirstRegistration],
                [Extent2].[FirstPolandRegistration] AS [FirstPolandRegistration],
                [Extent2].[Places] AS [Places],
                [Extent2].[Doors] AS [Doors],
                [Extent2].[Year] AS [Year],
                [Extent2].[CarMakeId] AS [CarMakeId],
                [Extent2].[CarModelId] AS [CarModelId],
                [Extent2].[CarGenerationId] AS [CarGenerationId],
                [Extent2].[VehicleBodyworkId] AS [VehicleBodyworkId],
                [Extent2].[CarBodyworkColorId] AS [CarBodyworkColorId],
                [Extent2].[CarBodyworkPaintId] AS [CarBodyworkPaintId],
                [Extent2].[CarEngineId] AS [CarEngineId],
                [Extent2].[OriginCountry] AS [OriginCountry],
                [Extent2].[FirstRegistrationCountry] AS [FirstRegistrationCountry],
                [Extent2].[CurrentRegistrationCountry] AS [CurrentRegistrationCountry],
                [Extent2].[GearboxId] AS [GearboxId],
                [Extent2].[Gears] AS [Gears],
                [Extent2].[EngineHorsePowers] AS [EngineHorsePowers],
                [Extent2].[EngineCapacity] AS [EngineCapacity],
                [Extent2].[EngineFuel] AS [EngineFuel],
                [Extent2].[Segment] AS [Segment],
                [Extent2].[CarState] AS [CarState],
                [Extent2].[Mileage] AS [Mileage],
                [Extent2].[CarStatusId] AS [CarStatusId],
                [Extent2].[WheelDriveId] AS [WheelDriveId],
                [Extent2].[VinNumber] AS [VinNumber],
                '0X0X' AS [C2],
                [Extent3].[Id] AS [Id2],
                [Extent3].[Name] AS [Name],
                [Extent4].[Id] AS [Id3],
                [Extent4].[Name] AS [Name1],
                [Extent4].[MakeId] AS [MakeId],
                [Extent4].[CategoryId] AS [CategoryId1],
                [Extent4].[Segment] AS [Segment1],
                [Extent4].[IsMaintained] AS [IsMaintained],
                [Extent5].[Id] AS [Id4],
                [Extent5].[Name] AS [Name2],
                [Extent5].[CarModelId] AS [CarModelId1],
                [Extent5].[Segment] AS [Segment2],
                [Extent5].[IsMaintained] AS [IsMaintained1],
                [Join6].[Id9] AS [Id5],
                [Join6].[Name] AS [Name3],
                [Join6].[Capacity] AS [Capacity],
                [Join6].[HorsePowers] AS [HorsePowers],
                [Join6].[Fuel] AS [Fuel],
                [Join6].[Id10] AS [Id6],
                [Join6].[Id11] AS [Id7],
                CASE WHEN ([Join6].[Id9] IS NULL) THEN CAST(NULL AS varchar(1)) WHEN (( NOT (([Join6].[C11] = 1) AND ([Join6].[C11] IS NOT NULL))) AND ( NOT (([Join6].[C12] = 1) AND ([Join6].[C12] IS NOT NULL)))) THEN '9X' WHEN (([Join6].[C11] = 1) AND ([Join6].[C11] IS NOT NULL)) THEN '9X0X' ELSE '9X1X' END AS [C3],
                CASE WHEN ([Join6].[Id9] IS NULL) THEN CAST(NULL AS int) WHEN (( NOT (([Join6].[C11] = 1) AND ([Join6].[C11] IS NOT NULL))) AND ( NOT (([Join6].[C12] = 1) AND ([Join6].[C12] IS NOT NULL)))) THEN CAST(NULL AS int) WHEN (([Join6].[C11] = 1) AND ([Join6].[C11] IS NOT NULL)) THEN [Join6].[CarModelId] END AS [C4],
                CASE WHEN ([Join6].[Id9] IS NULL) THEN CAST(NULL AS int) WHEN (( NOT (([Join6].[C11] = 1) AND ([Join6].[C11] IS NOT NULL))) AND ( NOT (([Join6].[C12] = 1) AND ([Join6].[C12] IS NOT NULL)))) THEN CAST(NULL AS int) WHEN (([Join6].[C11] = 1) AND ([Join6].[C11] IS NOT NULL)) THEN CAST(NULL AS int) ELSE [Join6].[CarGenerationId] END AS [C5],
                [Extent9].[Id] AS [Id8],
                [Extent9].[Order] AS [Order],
                [Extent9].[Hide] AS [Hide],
                [Extent9].[Name] AS [Name4]
                FROM       [dbo].[Offers] AS [Extent1]
                INNER JOIN [dbo].[VehicleOffers] AS [Extent2] ON [Extent1].[Id] = [Extent2].[Id]
                INNER JOIN [dbo].[CarMakes] AS [Extent3] ON [Extent2].[CarMakeId] = [Extent3].[Id]
                INNER JOIN [dbo].[CarModels] AS [Extent4] ON [Extent2].[CarModelId] = [Extent4].[Id]
                LEFT OUTER JOIN [dbo].[CarModelGenerations] AS [Extent5] ON [Extent2].[CarGenerationId] = [Extent5].[Id]
                LEFT OUTER JOIN  (SELECT [Extent6].[Id] AS [Id9], [Extent6].[Name] AS [Name], [Extent6].[Capacity] AS [Capacity], [Extent6].[HorsePowers] AS [HorsePowers], [Extent6].[Fuel] AS [Fuel], [Project1].[Id] AS [Id10], [Project1].[CarModelId] AS [CarModelId], [Project1].[C1] AS [C11], [Project2].[Id] AS [Id11], [Project2].[CarGenerationId] AS [CarGenerationId], [Project2].[C1] AS [C12]
                    FROM   [dbo].[CarEngines] AS [Extent6]
                    LEFT OUTER JOIN  (SELECT
                        [Extent7].[Id] AS [Id],
                        [Extent7].[CarModelId] AS [CarModelId],
                        cast(1 as bit) AS [C1]
                        FROM [dbo].[CarModelEngines] AS [Extent7] ) AS [Project1] ON [Extent6].[Id] = [Project1].[Id]
                    LEFT OUTER JOIN  (SELECT
                        [Extent8].[Id] AS [Id],
                        [Extent8].[CarGenerationId] AS [CarGenerationId],
                        cast(1 as bit) AS [C1]
                        FROM [dbo].[CarGenerationEngines] AS [Extent8] ) AS [Project2] ON [Extent6].[Id] = [Project2].[Id] ) AS [Join6] ON [Extent2].[CarEngineId] = [Join6].[Id9]
                INNER JOIN [dbo].[VehicleGearboxes] AS [Extent9] ON [Extent2].[GearboxId] = [Extent9].[Id]
            )  AS [Project3]
            ORDER BY [Project3].[C1] DESC ) AS [Limit1]
        LEFT OUTER JOIN  (SELECT [Extent10].[Promotion_Id] AS [Promotion_Id], [Extent10].[Offer_Id] AS [Offer_Id], [Extent11].[Id] AS [Id], [Extent11].[Name] AS [Name], [Extent11].[Price] AS [Price], [Extent11].[ReplacedIn] AS [ReplacedIn], [Extent11].[QuantityInCycle] AS [QuantityInCycle]
            FROM  [dbo].[PromotionOffers] AS [Extent10]
            INNER JOIN [dbo].[Promotions] AS [Extent11] ON [Extent11].[Id] = [Extent10].[Promotion_Id] ) AS [Join9] ON [Limit1].[Id] = [Join9].[Offer_Id]
    UNION ALL
        SELECT
        2 AS [C1],
        [Limit2].[C2] AS [C2],
        [Limit2].[Id1] AS [Id],
        [Limit2].[Id6] AS [Id1],
        [Limit2].[Id7] AS [Id2],
        [Limit2].[Id5] AS [Id3],
        [Limit2].[CategoryId] AS [CategoryId],
        [Limit2].[C1] AS [C3],
        [Limit2].[Id] AS [Id4],
        [Limit2].[Authorization] AS [Authorization],
        [Limit2].[Price] AS [Price],
        [Limit2].[Title] AS [Title],
        [Limit2].[Description] AS [Description],
        [Limit2].[Edited] AS [Edited],
        [Limit2].[Added] AS [Added],
        [Limit2].[EndDate] AS [EndDate],
        [Limit2].[IsAccepted] AS [IsAccepted],
        [Limit2].[CategoryId] AS [CategoryId1],
        [Limit2].[OfferQrCodeId] AS [OfferQrCodeId],
        [Limit2].[SellerId] AS [SellerId],
        [Limit2].[PromotionLeft] AS [PromotionLeft],
        [Limit2].[UnregisterUserInfoId] AS [UnregisterUserInfoId],
        [Limit2].[CommentsEnabled] AS [CommentsEnabled],
        [Limit2].[CommentsModerated] AS [CommentsModerated],
        [Limit2].[UseState] AS [UseState],
        [Limit2].[FirstRegistration] AS [FirstRegistration],
        [Limit2].[FirstPolandRegistration] AS [FirstPolandRegistration],
        [Limit2].[Places] AS [Places],
        [Limit2].[Doors] AS [Doors],
        [Limit2].[Year] AS [Year],
        [Limit2].[CarMakeId] AS [CarMakeId],
        [Limit2].[CarModelId] AS [CarModelId],
        [Limit2].[CarGenerationId] AS [CarGenerationId],
        [Limit2].[VehicleBodyworkId] AS [VehicleBodyworkId],
        [Limit2].[CarBodyworkColorId] AS [CarBodyworkColorId],
        [Limit2].[CarBodyworkPaintId] AS [CarBodyworkPaintId],
        [Limit2].[CarEngineId] AS [CarEngineId],
        [Limit2].[OriginCountry] AS [OriginCountry],
        [Limit2].[FirstRegistrationCountry] AS [FirstRegistrationCountry],
        [Limit2].[CurrentRegistrationCountry] AS [CurrentRegistrationCountry],
        [Limit2].[GearboxId] AS [GearboxId],
        [Limit2].[Gears] AS [Gears],
        [Limit2].[EngineHorsePowers] AS [EngineHorsePowers],
        [Limit2].[EngineCapacity] AS [EngineCapacity],
        [Limit2].[EngineFuel] AS [EngineFuel],
        [Limit2].[Segment] AS [Segment],
        [Limit2].[CarState] AS [CarState],
        [Limit2].[Mileage] AS [Mileage],
        [Limit2].[CarStatusId] AS [CarStatusId],
        [Limit2].[WheelDriveId] AS [WheelDriveId],
        [Limit2].[VinNumber] AS [VinNumber],
        [Limit2].[Id2] AS [Id5],
        [Limit2].[Name] AS [Name],
        [Limit2].[Id3] AS [Id6],
        [Limit2].[Name1] AS [Name1],
        [Limit2].[MakeId] AS [MakeId],
        [Limit2].[CategoryId1] AS [CategoryId2],
        [Limit2].[Segment1] AS [Segment1],
        [Limit2].[IsMaintained] AS [IsMaintained],
        [Limit2].[Id4] AS [Id7],
        [Limit2].[Name2] AS [Name2],
        [Limit2].[CarModelId1] AS [CarModelId1],
        [Limit2].[Segment2] AS [Segment2],
        [Limit2].[IsMaintained1] AS [IsMaintained1],
        [Limit2].[C3] AS [C4],
        [Limit2].[Id5] AS [Id8],
        [Limit2].[Name3] AS [Name3],
        [Limit2].[Capacity] AS [Capacity],
        [Limit2].[HorsePowers] AS [HorsePowers],
        [Limit2].[Fuel] AS [Fuel],
        [Limit2].[C4] AS [C5],
        [Limit2].[C5] AS [C6],
        [Limit2].[Id8] AS [Id9],
        [Limit2].[Order] AS [Order],
        [Limit2].[Hide] AS [Hide],
        [Limit2].[Name4] AS [Name4],
        CAST(NULL AS int) AS [C7],
        CAST(NULL AS varchar(1)) AS [C8],
        CAST(NULL AS decimal(18,2)) AS [C9],
        CAST(NULL AS float) AS [C10],
        CAST(NULL AS int) AS [C11],
        '18X0X' AS [C12],
        [Join19].[PhotoStorageEntry_Id] AS [PhotoStorageEntry_Id],
        [Join19].[FileName] AS [FileName],
        [Join19].[StoredFileName] AS [StoredFileName],
        [Join19].[Size] AS [Size],
        [Join19].[MimeType] AS [MimeType],
        [Join19].[Uploaded] AS [Uploaded]
        FROM   (SELECT TOP (10) [Project7].[Id] AS [Id], [Project7].[Authorization] AS [Authorization], [Project7].[Price] AS [Price], [Project7].[Title] AS [Title], [Project7].[Description] AS [Description], [Project7].[Edited] AS [Edited], [Project7].[Added] AS [Added], [Project7].[EndDate] AS [EndDate], [Project7].[IsAccepted] AS [IsAccepted], [Project7].[CategoryId] AS [CategoryId], [Project7].[OfferQrCodeId] AS [OfferQrCodeId], [Project7].[SellerId] AS [SellerId], [Project7].[PromotionLeft] AS [PromotionLeft], [Project7].[UnregisterUserInfoId] AS [UnregisterUserInfoId], [Project7].[CommentsEnabled] AS [CommentsEnabled], [Project7].[CommentsModerated] AS [CommentsModerated], [Project7].[UseState] AS [UseState], [Project7].[Id1] AS [Id1], [Project7].[FirstRegistration] AS [FirstRegistration], [Project7].[FirstPolandRegistration] AS [FirstPolandRegistration], [Project7].[Places] AS [Places], [Project7].[Doors] AS [Doors], [Project7].[Year] AS [Year], [Project7].[CarMakeId] AS [CarMakeId], [Project7].[CarModelId] AS [CarModelId], [Project7].[CarGenerationId] AS [CarGenerationId], [Project7].[VehicleBodyworkId] AS [VehicleBodyworkId], [Project7].[CarBodyworkColorId] AS [CarBodyworkColorId], [Project7].[CarBodyworkPaintId] AS [CarBodyworkPaintId], [Project7].[CarEngineId] AS [CarEngineId], [Project7].[OriginCountry] AS [OriginCountry], [Project7].[FirstRegistrationCountry] AS [FirstRegistrationCountry], [Project7].[CurrentRegistrationCountry] AS [CurrentRegistrationCountry], [Project7].[GearboxId] AS [GearboxId], [Project7].[Gears] AS [Gears], [Project7].[EngineHorsePowers] AS [EngineHorsePowers], [Project7].[EngineCapacity] AS [EngineCapacity], [Project7].[EngineFuel] AS [EngineFuel], [Project7].[Segment] AS [Segment], [Project7].[CarState] AS [CarState], [Project7].[Mileage] AS [Mileage], [Project7].[CarStatusId] AS [CarStatusId], [Project7].[WheelDriveId] AS [WheelDriveId], [Project7].[VinNumber] AS [VinNumber], [Project7].[C1] AS [C1], [Project7].[C2] AS [C2], [Project7].[Id2] AS [Id2], [Project7].[Name] AS [Name], [Project7].[Id3] AS [Id3], [Project7].[Name1] AS [Name1], [Project7].[MakeId] AS [MakeId], [Project7].[CategoryId1] AS [CategoryId1], [Project7].[Segment1] AS [Segment1], [Project7].[IsMaintained] AS [IsMaintained], [Project7].[Id4] AS [Id4], [Project7].[Name2] AS [Name2], [Project7].[CarModelId1] AS [CarModelId1], [Project7].[Segment2] AS [Segment2], [Project7].[IsMaintained1] AS [IsMaintained1], [Project7].[Id5] AS [Id5], [Project7].[Name3] AS [Name3], [Project7].[Capacity] AS [Capacity], [Project7].[HorsePowers] AS [HorsePowers], [Project7].[Fuel] AS [Fuel], [Project7].[Id6] AS [Id6], [Project7].[Id7] AS [Id7], [Project7].[C3] AS [C3], [Project7].[C4] AS [C4], [Project7].[C5] AS [C5], [Project7].[Id8] AS [Id8], [Project7].[Order] AS [Order], [Project7].[Hide] AS [Hide], [Project7].[Name4] AS [Name4]
            FROM ( SELECT
                [Extent12].[Id] AS [Id],
                [Extent12].[Authorization] AS [Authorization],
                [Extent12].[Price] AS [Price],
                [Extent12].[Title] AS [Title],
                [Extent12].[Description] AS [Description],
                [Extent12].[Edited] AS [Edited],
                [Extent12].[Added] AS [Added],
                [Extent12].[EndDate] AS [EndDate],
                [Extent12].[IsAccepted] AS [IsAccepted],
                [Extent12].[CategoryId] AS [CategoryId],
                [Extent12].[OfferQrCodeId] AS [OfferQrCodeId],
                [Extent12].[SellerId] AS [SellerId],
                [Extent12].[PromotionLeft] AS [PromotionLeft],
                [Extent12].[UnregisterUserInfoId] AS [UnregisterUserInfoId],
                [Extent12].[CommentsEnabled] AS [CommentsEnabled],
                [Extent12].[CommentsModerated] AS [CommentsModerated],
                [Extent12].[UseState] AS [UseState],
                [Extent13].[Id] AS [Id1],
                [Extent13].[FirstRegistration] AS [FirstRegistration],
                [Extent13].[FirstPolandRegistration] AS [FirstPolandRegistration],
                [Extent13].[Places] AS [Places],
                [Extent13].[Doors] AS [Doors],
                [Extent13].[Year] AS [Year],
                [Extent13].[CarMakeId] AS [CarMakeId],
                [Extent13].[CarModelId] AS [CarModelId],
                [Extent13].[CarGenerationId] AS [CarGenerationId],
                [Extent13].[VehicleBodyworkId] AS [VehicleBodyworkId],
                [Extent13].[CarBodyworkColorId] AS [CarBodyworkColorId],
                [Extent13].[CarBodyworkPaintId] AS [CarBodyworkPaintId],
                [Extent13].[CarEngineId] AS [CarEngineId],
                [Extent13].[OriginCountry] AS [OriginCountry],
                [Extent13].[FirstRegistrationCountry] AS [FirstRegistrationCountry],
                [Extent13].[CurrentRegistrationCountry] AS [CurrentRegistrationCountry],
                [Extent13].[GearboxId] AS [GearboxId],
                [Extent13].[Gears] AS [Gears],
                [Extent13].[EngineHorsePowers] AS [EngineHorsePowers],
                [Extent13].[EngineCapacity] AS [EngineCapacity],
                [Extent13].[EngineFuel] AS [EngineFuel],
                [Extent13].[Segment] AS [Segment],
                [Extent13].[CarState] AS [CarState],
                [Extent13].[Mileage] AS [Mileage],
                [Extent13].[CarStatusId] AS [CarStatusId],
                [Extent13].[WheelDriveId] AS [WheelDriveId],
                [Extent13].[VinNumber] AS [VinNumber],
                '0X0X' AS [C1],
                NEWID() AS [C2],
                [Extent14].[Id] AS [Id2],
                [Extent14].[Name] AS [Name],
                [Extent15].[Id] AS [Id3],
                [Extent15].[Name] AS [Name1],
                [Extent15].[MakeId] AS [MakeId],
                [Extent15].[CategoryId] AS [CategoryId1],
                [Extent15].[Segment] AS [Segment1],
                [Extent15].[IsMaintained] AS [IsMaintained],
                [Extent16].[Id] AS [Id4],
                [Extent16].[Name] AS [Name2],
                [Extent16].[CarModelId] AS [CarModelId1],
                [Extent16].[Segment] AS [Segment2],
                [Extent16].[IsMaintained] AS [IsMaintained1],
                [Join16].[Id12] AS [Id5],
                [Join16].[Name] AS [Name3],
                [Join16].[Capacity] AS [Capacity],
                [Join16].[HorsePowers] AS [HorsePowers],
                [Join16].[Fuel] AS [Fuel],
                [Join16].[Id13] AS [Id6],
                [Join16].[Id14] AS [Id7],
                CASE WHEN ([Join16].[Id12] IS NULL) THEN CAST(NULL AS varchar(1)) WHEN (( NOT (([Join16].[C13] = 1) AND ([Join16].[C13] IS NOT NULL))) AND ( NOT (([Join16].[C14] = 1) AND ([Join16].[C14] IS NOT NULL)))) THEN '9X' WHEN (([Join16].[C13] = 1) AND ([Join16].[C13] IS NOT NULL)) THEN '9X0X' ELSE '9X1X' END AS [C3],
                CASE WHEN ([Join16].[Id12] IS NULL) THEN CAST(NULL AS int) WHEN (( NOT (([Join16].[C13] = 1) AND ([Join16].[C13] IS NOT NULL))) AND ( NOT (([Join16].[C14] = 1) AND ([Join16].[C14] IS NOT NULL)))) THEN CAST(NULL AS int) WHEN (([Join16].[C13] = 1) AND ([Join16].[C13] IS NOT NULL)) THEN [Join16].[CarModelId] END AS [C4],
                CASE WHEN ([Join16].[Id12] IS NULL) THEN CAST(NULL AS int) WHEN (( NOT (([Join16].[C13] = 1) AND ([Join16].[C13] IS NOT NULL))) AND ( NOT (([Join16].[C14] = 1) AND ([Join16].[C14] IS NOT NULL)))) THEN CAST(NULL AS int) WHEN (([Join16].[C13] = 1) AND ([Join16].[C13] IS NOT NULL)) THEN CAST(NULL AS int) ELSE [Join16].[CarGenerationId] END AS [C5],
                [Extent20].[Id] AS [Id8],
                [Extent20].[Order] AS [Order],
                [Extent20].[Hide] AS [Hide],
                [Extent20].[Name] AS [Name4]
                FROM       [dbo].[Offers] AS [Extent12]
                INNER JOIN [dbo].[VehicleOffers] AS [Extent13] ON [Extent12].[Id] = [Extent13].[Id]
                INNER JOIN [dbo].[CarMakes] AS [Extent14] ON [Extent13].[CarMakeId] = [Extent14].[Id]
                INNER JOIN [dbo].[CarModels] AS [Extent15] ON [Extent13].[CarModelId] = [Extent15].[Id]
                LEFT OUTER JOIN [dbo].[CarModelGenerations] AS [Extent16] ON [Extent13].[CarGenerationId] = [Extent16].[Id]
                LEFT OUTER JOIN  (SELECT [Extent17].[Id] AS [Id12], [Extent17].[Name] AS [Name], [Extent17].[Capacity] AS [Capacity], [Extent17].[HorsePowers] AS [HorsePowers], [Extent17].[Fuel] AS [Fuel], [Project5].[Id] AS [Id13], [Project5].[CarModelId] AS [CarModelId], [Project5].[C1] AS [C13], [Project6].[Id] AS [Id14], [Project6].[CarGenerationId] AS [CarGenerationId], [Project6].[C1] AS [C14]
                    FROM   [dbo].[CarEngines] AS [Extent17]
                    LEFT OUTER JOIN  (SELECT
                        [Extent18].[Id] AS [Id],
                        [Extent18].[CarModelId] AS [CarModelId],
                        cast(1 as bit) AS [C1]
                        FROM [dbo].[CarModelEngines] AS [Extent18] ) AS [Project5] ON [Extent17].[Id] = [Project5].[Id]
                    LEFT OUTER JOIN  (SELECT
                        [Extent19].[Id] AS [Id],
                        [Extent19].[CarGenerationId] AS [CarGenerationId],
                        cast(1 as bit) AS [C1]
                        FROM [dbo].[CarGenerationEngines] AS [Extent19] ) AS [Project6] ON [Extent17].[Id] = [Project6].[Id] ) AS [Join16] ON [Extent13].[CarEngineId] = [Join16].[Id12]
                INNER JOIN [dbo].[VehicleGearboxes] AS [Extent20] ON [Extent13].[GearboxId] = [Extent20].[Id]
            )  AS [Project7]
            ORDER BY [Project7].[C2] DESC ) AS [Limit2]
        INNER JOIN  (SELECT [Extent21].[PhotoStorageEntry_Id] AS [PhotoStorageEntry_Id], [Extent21].[Offer_Id] AS [Offer_Id], [Extent22].[FileName] AS [FileName], [Extent22].[StoredFileName] AS [StoredFileName], [Extent22].[Size] AS [Size], [Extent22].[MimeType] AS [MimeType], [Extent22].[Uploaded] AS [Uploaded]
            FROM  [dbo].[PhotoStorageEntryOffers] AS [Extent21]
            INNER JOIN [dbo].[StorageEntries] AS [Extent22] ON [Extent21].[PhotoStorageEntry_Id] = [Extent22].[Id] ) AS [Join19] ON [Limit2].[Id] = [Join19].[Offer_Id]) AS [UnionAll1]
    ORDER BY [UnionAll1].[C2] DESC, [UnionAll1].[Id] ASC, [UnionAll1].[Id1] ASC, [UnionAll1].[Id2] ASC, [UnionAll1].[Id3] ASC, [UnionAll1].[Id4] ASC, [UnionAll1].[Id5] ASC, [UnionAll1].[Id6] ASC, [UnionAll1].[Id7] ASC, [UnionAll1].[Id9] ASC, [UnionAll1].[C1] ASC