exec sp_executesql N'SELECT
    [Project16].[ProductId] AS [ProductId],
    [Project16].[SAPArtikelNummer] AS [SAPArtikelNummer],
    [Project16].[Merk] AS [Merk],
    [Project16].[TypeNummer] AS [TypeNummer],
    [Project16].[SpecificatieCode] AS [SpecificatieCode],
    [Project16].[FiliaalStatusCode] AS [FiliaalStatusCode],
    [Project16].[EAN] AS [EAN],
    [Project16].[Code] AS [Code],
    [Project16].[Code1] AS [Code1],
    [Project16].[Code2] AS [Code2],
    [Project16].[Code3] AS [Code3],
    [Project16].[Code4] AS [Code4],
    [Project16].[HierarchyID] AS [HierarchyID],
    [Project16].[HierarchyID1] AS [HierarchyID1],
    [Project16].[HierarchyID2] AS [HierarchyID2],
    [Project16].[FeatureId] AS [FeatureId],
    [Project16].[C1] AS [C1],
    [Project16].[Name] AS [Name],
    [Project16].[Name1] AS [Name1],
    [Project16].[Name2] AS [Name2],
    [Project16].[Mandatory] AS [Mandatory],
    [Project16].[C2] AS [C2],
    [Project16].[C3] AS [C3],
    [Project16].[FredhopperTypeId] AS [FredhopperTypeId],
    [Project16].[Value] AS [Value]
    FROM ( SELECT
        [Project15].[ProductId] AS [ProductId],
        [Project15].[FeatureId] AS [FeatureId],
        [Project15].[Value] AS [Value],
        [Project15].[SAPArtikelNummer] AS [SAPArtikelNummer],
        [Project15].[Merk] AS [Merk],
        [Project15].[TypeNummer] AS [TypeNummer],
        [Project15].[FiliaalStatusCode] AS [FiliaalStatusCode],
        [Project15].[SpecificatieCode] AS [SpecificatieCode],
        [Project15].[EAN] AS [EAN],
        [Project15].[Code] AS [Code],
        [Project15].[Code1] AS [Code1],
        [Project15].[Code2] AS [Code2],
        [Project15].[Code3] AS [Code3],
        [Project15].[Code4] AS [Code4],
        [Project15].[HierarchyID] AS [HierarchyID],
        [Project15].[HierarchyID1] AS [HierarchyID1],
        [Project15].[HierarchyID2] AS [HierarchyID2],
        [Project15].[Name] AS [Name],
        [Project15].[FredhopperTypeId] AS [FredhopperTypeId],
        [Project15].[Mandatory] AS [Mandatory],
        [Project15].[Name1] AS [Name1],
        [Project15].[Name2] AS [Name2],
        [Project15].[C1] AS [C1],
        [Project15].[C2] AS [C2],
        [Project15].[C3] AS [C3]
        FROM ( SELECT
            [Project13].[ProductId] AS [ProductId],
            [Project13].[FeatureId] AS [FeatureId],
            [Project13].[Value] AS [Value],
            [Project13].[SAPArtikelNummer] AS [SAPArtikelNummer],
            [Project13].[Merk] AS [Merk],
            [Project13].[TypeNummer] AS [TypeNummer],
            [Project13].[FiliaalStatusCode] AS [FiliaalStatusCode],
            [Project13].[SpecificatieCode] AS [SpecificatieCode],
            [Project13].[EAN] AS [EAN],
            [Project13].[Code] AS [Code],
            [Project13].[Code1] AS [Code1],
            [Project13].[Code2] AS [Code2],
            [Project13].[Code3] AS [Code3],
            [Project13].[Code4] AS [Code4],
            [Project13].[HierarchyID] AS [HierarchyID],
            [Project13].[HierarchyID1] AS [HierarchyID1],
            [Project13].[HierarchyID2] AS [HierarchyID2],
            [Project13].[Name] AS [Name],
            [Project13].[FredhopperTypeId] AS [FredhopperTypeId],
            [Project13].[Mandatory] AS [Mandatory],
            [Project13].[Name1] AS [Name1],
            [Project13].[Name2] AS [Name2],
            [Project13].[C1] AS [C1],
            [Project13].[C2] AS [C2],
            (SELECT TOP (1)
                [Extent33].[WebVisible] AS [WebVisible]
                FROM  [features].[ProductGroupFeatures] AS [Extent33]
                INNER JOIN [dbo].[Product] AS [Extent34] ON [Extent33].[ProductGroupId] = [Extent34].[ProductGroupId]
                WHERE ([Project13].[FeatureId] = [Extent33].[FeatureId]) AND ([Project13].[ProductId] = [Extent34].[ProductID]) AND ([Extent33].[FeatureId] = [Project13].[FeatureId])) AS [C3]
            FROM ( SELECT
                [Project12].[ProductId] AS [ProductId],
                [Project12].[FeatureId] AS [FeatureId],
                [Project12].[Value] AS [Value],
                [Project12].[SAPArtikelNummer] AS [SAPArtikelNummer],
                [Project12].[Merk] AS [Merk],
                [Project12].[TypeNummer] AS [TypeNummer],
                [Project12].[FiliaalStatusCode] AS [FiliaalStatusCode],
                [Project12].[SpecificatieCode] AS [SpecificatieCode],
                [Project12].[EAN] AS [EAN],
                [Project12].[Code] AS [Code],
                [Project12].[Code1] AS [Code1],
                [Project12].[Code2] AS [Code2],
                [Project12].[Code3] AS [Code3],
                [Project12].[Code4] AS [Code4],
                [Project12].[HierarchyID] AS [HierarchyID],
                [Project12].[HierarchyID1] AS [HierarchyID1],
                [Project12].[HierarchyID2] AS [HierarchyID2],
                [Project12].[Name] AS [Name],
                [Project12].[FredhopperTypeId] AS [FredhopperTypeId],
                [Project12].[Mandatory] AS [Mandatory],
                [Project12].[Name1] AS [Name1],
                [Project12].[Name2] AS [Name2],
                [Project12].[C1] AS [C1],
                [Project12].[C2] AS [C2]
                FROM ( SELECT
                    [Project10].[ProductId] AS [ProductId],
                    [Project10].[FeatureId] AS [FeatureId],
                    [Project10].[Value] AS [Value],
                    [Project10].[SAPArtikelNummer] AS [SAPArtikelNummer],
                    [Project10].[Merk] AS [Merk],
                    [Project10].[TypeNummer] AS [TypeNummer],
                    [Project10].[FiliaalStatusCode] AS [FiliaalStatusCode],
                    [Project10].[SpecificatieCode] AS [SpecificatieCode],
                    [Project10].[EAN] AS [EAN],
                    [Project10].[Code] AS [Code],
                    [Project10].[Code1] AS [Code1],
                    [Project10].[Code2] AS [Code2],
                    [Project10].[Code3] AS [Code3],
                    [Project10].[Code4] AS [Code4],
                    [Project10].[HierarchyID] AS [HierarchyID],
                    [Project10].[HierarchyID1] AS [HierarchyID1],
                    [Project10].[HierarchyID2] AS [HierarchyID2],
                    [Project10].[Id] AS [Id],
                    [Project10].[Name] AS [Name],
                    [Project10].[UnitId] AS [UnitId],
                    [Project10].[DataTypeId] AS [DataTypeId],
                    [Project10].[FredhopperTypeId] AS [FredhopperTypeId],
                    [Project10].[Mandatory] AS [Mandatory],
                    [Project10].[ID1] AS [ID1],
                    [Project10].[Name1] AS [Name1],
                    [Project10].[ID2] AS [ID2],
                    [Project10].[Name2] AS [Name2],
                    [Project10].[C1] AS [C1],
                    (SELECT TOP (1)
                        [Extent31].[WebSummaryPosition] AS [WebSummaryPosition]
                        FROM  [features].[ProductGroupFeatures] AS [Extent31]
                        INNER JOIN [dbo].[Product] AS [Extent32] ON [Extent31].[ProductGroupId] = [Extent32].[ProductGroupId]
                        WHERE ([Project10].[FeatureId] = [Extent31].[FeatureId]) AND ([Project10].[ProductId] = [Extent32].[ProductID]) AND ([Extent31].[FeatureId] = [Project10].[FeatureId])) AS [C2]
                    FROM ( SELECT
                        [Project9].[ProductId] AS [ProductId],
                        [Project9].[FeatureId] AS [FeatureId],
                        [Project9].[Value] AS [Value],
                        [Project9].[SAPArtikelNummer] AS [SAPArtikelNummer],
                        [Project9].[Merk] AS [Merk],
                        [Project9].[TypeNummer] AS [TypeNummer],
                        [Project9].[FiliaalStatusCode] AS [FiliaalStatusCode],
                        [Project9].[SpecificatieCode] AS [SpecificatieCode],
                        [Project9].[EAN] AS [EAN],
                        [Project9].[Code] AS [Code],
                        [Project9].[Code1] AS [Code1],
                        [Project9].[Code2] AS [Code2],
                        [Project9].[Code3] AS [Code3],
                        [Project9].[Code4] AS [Code4],
                        [Project9].[HierarchyID] AS [HierarchyID],
                        [Project9].[HierarchyID1] AS [HierarchyID1],
                        [Project9].[HierarchyID2] AS [HierarchyID2],
                        [Extent28].[Id] AS [Id],
                        [Extent28].[Name] AS [Name],
                        [Extent28].[UnitId] AS [UnitId],
                        [Extent28].[DataTypeId] AS [DataTypeId],
                        [Extent28].[FredhopperTypeId] AS [FredhopperTypeId],
                        [Extent28].[Mandatory] AS [Mandatory],
                        [Extent29].[Id] AS [ID1],
                        [Extent29].[Name] AS [Name1],
                        [Extent30].[Id] AS [ID2],
                        [Extent30].[Name] AS [Name2],
                        [Project9].[C1] AS [C1]
                        FROM     (SELECT
                            [Project7].[ProductId] AS [ProductId],
                            [Project7].[FeatureId] AS [FeatureId],
                            [Project7].[Value] AS [Value],
                            [Project7].[SAPArtikelNummer] AS [SAPArtikelNummer],
                            [Project7].[Merk] AS [Merk],
                            [Project7].[TypeNummer] AS [TypeNummer],
                            [Project7].[FiliaalStatusCode] AS [FiliaalStatusCode],
                            [Project7].[SpecificatieCode] AS [SpecificatieCode],
                            [Project7].[EAN] AS [EAN],
                            [Project7].[Code] AS [Code],
                            [Project7].[Code1] AS [Code1],
                            [Project7].[Code2] AS [Code2],
                            [Project7].[Code3] AS [Code3],
                            [Project7].[Code4] AS [Code4],
                            [Project7].[HierarchyID] AS [HierarchyID],
                            [Project7].[HierarchyID1] AS [HierarchyID1],
                            [Project7].[WebFamilyID] AS [WebFamilyID],
                            [Project7].[ID] AS [ID],
                            [Project7].[WebCategoryID] AS [WebCategoryID],
                            [Project7].[ID1] AS [ID1],
                            [Project7].[WebUniverseID] AS [WebUniverseID],
                            [Project7].[ID2] AS [ID2],
                            [Project7].[HierarchyID2] AS [HierarchyID2],
                            (SELECT TOP (1)
                                [Extent26].[FeatureGroup] AS [FeatureGroup]
                                FROM  [features].[ProductGroupFeatures] AS [Extent26]
                                INNER JOIN [dbo].[Product] AS [Extent27] ON [Extent26].[ProductGroupId] = [Extent27].[ProductGroupId]
                                WHERE ([Project7].[FeatureId] = [Extent26].[FeatureId]) AND ([Project7].[ProductId] = [Extent27].[ProductID]) AND ([Extent26].[FeatureId] = [Project7].[FeatureId])) AS [C1]
                            FROM ( SELECT
                                [Project6].[ProductId] AS [ProductId],
                                [Project6].[FeatureId] AS [FeatureId],
                                [Project6].[Value] AS [Value],
                                [Project6].[SAPArtikelNummer] AS [SAPArtikelNummer],
                                [Project6].[Merk] AS [Merk],
                                [Project6].[TypeNummer] AS [TypeNummer],
                                [Project6].[FiliaalStatusCode] AS [FiliaalStatusCode],
                                [Project6].[SpecificatieCode] AS [SpecificatieCode],
                                [Project6].[EAN] AS [EAN],
                                [Project6].[Code] AS [Code],
                                [Project6].[Code1] AS [Code1],
                                [Project6].[Code2] AS [Code2],
                                [Project6].[Code3] AS [Code3],
                                [Project6].[Code4] AS [Code4],
                                [Project6].[HierarchyID] AS [HierarchyID],
                                [Project6].[HierarchyID1] AS [HierarchyID1],
                                [Limit3].[WebFamilyID] AS [WebFamilyID],
                                [Extent23].[ID] AS [ID],
                                [Extent23].[WebCategoryID] AS [WebCategoryID],
                                [Extent24].[ID] AS [ID1],
                                [Extent24].[WebUniverseID] AS [WebUniverseID],
                                [Extent25].[ID] AS [ID2],
                                [Extent25].[HierarchyID] AS [HierarchyID2]
                                FROM      (SELECT
                                    [Project5].[ProductId] AS [ProductId],
                                    [Project5].[FeatureId] AS [FeatureId],
                                    [Project5].[Value] AS [Value],
                                    [Project5].[SAPArtikelNummer] AS [SAPArtikelNummer],
                                    [Project5].[Merk] AS [Merk],
                                    [Project5].[TypeNummer] AS [TypeNummer],
                                    [Project5].[FiliaalStatusCode] AS [FiliaalStatusCode],
                                    [Project5].[SpecificatieCode] AS [SpecificatieCode],
                                    [Project5].[EAN] AS [EAN],
                                    [Project5].[Code] AS [Code],
                                    [Project5].[Code1] AS [Code1],
                                    [Project5].[Code2] AS [Code2],
                                    [Project5].[Code3] AS [Code3],
                                    [Project5].[Code4] AS [Code4],
                                    [Project5].[HierarchyID] AS [HierarchyID],
                                    [Limit2].[WebFamilyID] AS [WebFamilyID],
                                    [Extent19].[ID] AS [ID],
                                    [Extent19].[WebCategoryID] AS [WebCategoryID],
                                    [Extent20].[ID] AS [ID1],
                                    [Extent20].[HierarchyID] AS [HierarchyID1]
                                    FROM     (SELECT
                                        [Filter5].[ProductId1] AS [ProductId],
                                        [Filter5].[FeatureId] AS [FeatureId],
                                        [Filter5].[Value] AS [Value],
                                        [Filter5].[SAPArtikelNummer] AS [SAPArtikelNummer],
                                        [Filter5].[Merk] AS [Merk],
                                        [Filter5].[TypeNummer] AS [TypeNummer],
                                        [Filter5].[FiliaalStatusCode] AS [FiliaalStatusCode],
                                        [Filter5].[SpecificatieCode] AS [SpecificatieCode],
                                        [Filter5].[EAN] AS [EAN],
                                        [Filter5].[Code1] AS [Code],
                                        [Filter5].[Code2] AS [Code1],
                                        [Filter5].[Code3] AS [Code2],
                                        [Filter5].[Code4] AS [Code3],
                                        [Filter5].[Code5] AS [Code4],
                                        [Limit1].[WebFamilyID] AS [WebFamilyID],
                                        [Extent16].[ID] AS [ID],
                                        [Extent16].[HierarchyID] AS [HierarchyID]
                                        FROM    (SELECT [Extent1].[ProductId] AS [ProductId1], [Extent1].[FeatureId] AS [FeatureId], [Extent1].[Value] AS [Value], [Extent2].[SAPArtikelNummer] AS [SAPArtikelNummer], [Extent2].[Merk] AS [Merk], [Extent2].[TypeNummer] AS [TypeNummer], [Extent2].[FiliaalStatusCode] AS [FiliaalStatusCode], [Extent2].[SpecificatieCode] AS [SpecificatieCode], [Extent2].[EAN] AS [EAN], [Extent3].[Code] AS [Code1], [Extent4].[Code] AS [Code2], [Extent5].[Code] AS [Code3], [Extent6].[Code] AS [Code4], [Extent7].[Code] AS [Code5]
                                            FROM       [features].[ProductFeatures] AS [Extent1]
                                            INNER JOIN [dbo].[Product] AS [Extent2] ON [Extent1].[ProductId] = [Extent2].[ProductID]
                                            LEFT OUTER JOIN [dbo].[ProductGroups] AS [Extent3] ON [Extent2].[ProductGroupId] = [Extent3].[Id]
                                            LEFT OUTER JOIN [dbo].[ProductGroups] AS [Extent4] ON [Extent3].[ParentProductGroupId] = [Extent4].[Id]
                                            LEFT OUTER JOIN [dbo].[ProductGroups] AS [Extent5] ON [Extent4].[ParentProductGroupId] = [Extent5].[Id]
                                            LEFT OUTER JOIN [dbo].[ProductGroups] AS [Extent6] ON [Extent5].[ParentProductGroupId] = [Extent6].[Id]
                                            LEFT OUTER JOIN [dbo].[ProductGroups] AS [Extent7] ON [Extent6].[ParentProductGroupId] = [Extent7].[Id]
                                            WHERE ([Extent1].[ProductId] IN (14812226, 14811695, 14811694, 14809668, 14808812, 14807613, 14805942, 14805352, 14805078, 14799840, 14799839, 14799812, 14799811, 14799810, 14799809, 14796078, 14794756, 14793857, 14793748, 14792395, 14790912, 14790911, 14790910, 14789978, 14789490, 14788314, 14787962, 14787554, 14787553, 14786835, 14786671, 14786544, 14786435, 14786434, 14786341, 14785933, 14785932, 14785426, 14785340, 14785339, 14785338, 14785337, 14784033, 14784032, 14784031, 14783309, 14782056, 14782052, 14782050, 14782009, 14782008, 14781461, 14781211, 14780874, 14778515, 14778459, 14778458, 14777772, 14777771, 14777529, 14777280, 14777019, 14776865, 14776864, 14776863, 14776862, 14776120, 14775704, 14774343, 14773046, 14772603, 14771987, 14771074, 14770380, 14770191, 14769339, 14769212, 14769116, 14767266, 14767265, 14765792, 14785326, 14764537, 14764271, 14764015, 14763929, 14762418, 14762350, 14783207, 14761832, 14761798, 14761773, 14761765, 14761750, 14786738, 14779134)) AND ( EXISTS (SELECT
                                                1 AS [C1]
                                                FROM  (SELECT
                                                    [Extent8].[ProductId] AS [ProductId]
                                                    FROM    [features].[ProductFeatures] AS [Extent8]
                                                    INNER JOIN [features].[Features] AS [Extent9] ON [Extent8].[FeatureId] = [Extent9].[Id]
                                                    LEFT OUTER JOIN [features].[Units] AS [Extent10] ON [Extent9].[UnitId] = [Extent10].[Id]
                                                    INNER JOIN [features].[DataTypes] AS [Extent11] ON [Extent9].[DataTypeId] = [Extent11].[Id]
                                                    WHERE ([Extent8].[ProductId] IN (14812226, 14811695, 14811694, 14809668, 14808812, 14807613, 14805942, 14805352, 14805078, 14799840, 14799839, 14799812, 14799811, 14799810, 14799809, 14796078, 14794756, 14793857, 14793748, 14792395, 14790912, 14790911, 14790910, 14789978, 14789490, 14788314, 14787962, 14787554, 14787553, 14786835, 14786671, 14786544, 14786435, 14786434, 14786341, 14785933, 14785932, 14785426, 14785340, 14785339, 14785338, 14785337, 14784033, 14784032, 14784031, 14783309, 14782056, 14782052, 14782050, 14782009, 14782008, 14781461, 14781211, 14780874, 14778515, 14778459, 14778458, 14777772, 14777771, 14777529, 14777280, 14777019, 14776865, 14776864, 14776863, 14776862, 14776120, 14775704, 14774343, 14773046, 14772603, 14771987, 14771074, 14770380, 14770191, 14769339, 14769212, 14769116, 14767266, 14767265, 14765792, 14785326, 14764537, 14764271, 14764015, 14763929, 14762418, 14762350, 14783207, 14761832, 14761798, 14761773, 14761765, 14761750, 14786738, 14779134)) AND ((@p__linq__0 = ([Extent9].[Name] + N'' ('' + CASE WHEN ([Extent10].[Name] IS NULL) THEN N'''' ELSE [Extent10].[Name] END + N'' , '' + [Extent11].[Name] + N'')'')) OR ((@p__linq__0 IS NULL) AND ([Extent9].[Name] + N'' ('' + CASE WHEN ([Extent10].[Name] IS NULL) THEN N'''' ELSE [Extent10].[Name] END + N'' , '' + [Extent11].[Name] + N'')'' IS NULL))) AND (@p__linq__1 = [Extent8].[Value])
                                                INTERSECT
                                                    SELECT
                                                    [Extent12].[ProductId] AS [ProductId]
                                                    FROM [features].[ProductFeatures] AS [Extent12]
                                                    WHERE [Extent12].[ProductId] IN (14812226, 14811695, 14811694, 14809668, 14808812, 14807613, 14805942, 14805352, 14805078, 14799840, 14799839, 14799812, 14799811, 14799810, 14799809, 14796078, 14794756, 14793857, 14793748, 14792395, 14790912, 14790911, 14790910, 14789978, 14789490, 14788314, 14787962, 14787554, 14787553, 14786835, 14786671, 14786544, 14786435, 14786434, 14786341, 14785933, 14785932, 14785426, 14785340, 14785339, 14785338, 14785337, 14784033, 14784032, 14784031, 14783309, 14782056, 14782052, 14782050, 14782009, 14782008, 14781461, 14781211, 14780874, 14778515, 14778459, 14778458, 14777772, 14777771, 14777529, 14777280, 14777019, 14776865, 14776864, 14776863, 14776862, 14776120, 14775704, 14774343, 14773046, 14772603, 14771987, 14771074, 14770380, 14770191, 14769339, 14769212, 14769116, 14767266, 14767265, 14765792, 14785326, 14764537, 14764271, 14764015, 14763929, 14762418, 14762350, 14783207, 14761832, 14761798, 14761773, 14761765, 14761750, 14786738, 14779134)
                                                INTERSECT
                                                    SELECT
                                                    [Extent13].[ProductId] AS [ProductId]
                                                    FROM [features].[ProductFeatures] AS [Extent13]
                                                    WHERE [Extent13].[ProductId] IN (14812226, 14811695, 14811694, 14809668, 14808812, 14807613, 14805942, 14805352, 14805078, 14799840, 14799839, 14799812, 14799811, 14799810, 14799809, 14796078, 14794756, 14793857, 14793748, 14792395, 14790912, 14790911, 14790910, 14789978, 14789490, 14788314, 14787962, 14787554, 14787553, 14786835, 14786671, 14786544, 14786435, 14786434, 14786341, 14785933, 14785932, 14785426, 14785340, 14785339, 14785338, 14785337, 14784033, 14784032, 14784031, 14783309, 14782056, 14782052, 14782050, 14782009, 14782008, 14781461, 14781211, 14780874, 14778515, 14778459, 14778458, 14777772, 14777771, 14777529, 14777280, 14777019, 14776865, 14776864, 14776863, 14776862, 14776120, 14775704, 14774343, 14773046, 14772603, 14771987, 14771074, 14770380, 14770191, 14769339, 14769212, 14769116, 14767266, 14767265, 14765792, 14785326, 14764537, 14764271, 14764015, 14763929, 14762418, 14762350, 14783207, 14761832, 14761798, 14761773, 14761765, 14761750, 14786738, 14779134)) AS [Intersect2]
                                                WHERE [Intersect2].[ProductId] = [Extent1].[ProductId]
                                            )) ) AS [Filter5]
                                        OUTER APPLY  (SELECT TOP (1) [Extent14].[WebFamilyID] AS [WebFamilyID]
                                            FROM  [dbo].[WebFamilyDarty] AS [Extent14]
                                            INNER JOIN [dbo].[Product] AS [Extent15] ON [Extent14].[ExtMatlGroup] = [Extent15].[ExtGG]
                                            WHERE [Filter5].[ProductId1] = [Extent15].[ProductID] ) AS [Limit1]
                                        LEFT OUTER JOIN [dbo].[WebFamilies] AS [Extent16] ON [Limit1].[WebFamilyID] = [Extent16].[ID] ) AS [Project5]
                                    OUTER APPLY  (SELECT TOP (1) [Extent17].[WebFamilyID] AS [WebFamilyID]
                                        FROM  [dbo].[WebFamilyDarty] AS [Extent17]
                                        INNER JOIN [dbo].[Product] AS [Extent18] ON [Extent17].[ExtMatlGroup] = [Extent18].[ExtGG]
                                        WHERE [Project5].[ProductId] = [Extent18].[ProductID] ) AS [Limit2]
                                    LEFT OUTER JOIN [dbo].[WebFamilies] AS [Extent19] ON [Limit2].[WebFamilyID] = [Extent19].[ID]
                                    LEFT OUTER JOIN [dbo].[WebCategories] AS [Extent20] ON [Extent19].[WebCategoryID] = [Extent20].[ID] ) AS [Project6]
                                OUTER APPLY  (SELECT TOP (1) [Extent21].[WebFamilyID] AS [WebFamilyID]
                                    FROM  [dbo].[WebFamilyDarty] AS [Extent21]
                                    INNER JOIN [dbo].[Product] AS [Extent22] ON [Extent21].[ExtMatlGroup] = [Extent22].[ExtGG]
                                    WHERE [Project6].[ProductId] = [Extent22].[ProductID] ) AS [Limit3]
                                LEFT OUTER JOIN [dbo].[WebFamilies] AS [Extent23] ON [Limit3].[WebFamilyID] = [Extent23].[ID]
                                LEFT OUTER JOIN [dbo].[WebCategories] AS [Extent24] ON [Extent23].[WebCategoryID] = [Extent24].[ID]
                                LEFT OUTER JOIN [dbo].[WebUniverses] AS [Extent25] ON [Extent24].[WebUniverseID] = [Extent25].[ID]
                            )  AS [Project7] ) AS [Project9]
                        LEFT OUTER JOIN [features].[Features] AS [Extent28] ON [Project9].[FeatureId] = [Extent28].[Id]
                        LEFT OUTER JOIN [features].[Units] AS [Extent29] ON [Extent28].[UnitId] = [Extent29].[Id]
                        LEFT OUTER JOIN [features].[DataTypes] AS [Extent30] ON [Extent28].[DataTypeId] = [Extent30].[Id]
                    )  AS [Project10]
                )  AS [Project12]
            )  AS [Project13]
        )  AS [Project15]
    )  AS [Project16]
    ORDER BY [Project16].[SAPArtikelNummer] DESC',N'@p__linq__0 nvarchar(4000),@p__linq__1 nvarchar(4000)',@p__linq__0=N'Intensieve stand ( , Dropdown)',@p__linq__1=N'nee'