+       products    {SELECT [t2].[ProductID] AS [ID], (
    SELECT [t6].[Name]
    FROM (
        SELECT TOP (1) [t3].[ProductID]
        FROM [dbo].[Products] AS [t3]
        INNER JOIN [dbo].[ProductLanguage] AS [t4] ON [t4].[ProductID] = [t3].[ProductID]
        WHERE ([t2].[ProductID] = [t3].[ProductID]) AND ([t4].[LANGUAGE] = @p0)
        ) AS [t5]
    INNER JOIN [dbo].[ProductLanguage] AS [t6] ON [t6].[ProductID] = [t5].[ProductID]
    ) AS [Name], (
    SELECT [t10].[Description]
    FROM (
        SELECT TOP (1) [t7].[ProductID]
        FROM [dbo].[Products] AS [t7]
        INNER JOIN [dbo].[ProductLanguage] AS [t8] ON [t8].[ProductID] = [t7].[ProductID]
        WHERE ([t2].[ProductID] = [t7].[ProductID]) AND ([t8].[LANGUAGE] = @p0)
        ) AS [t9]
    INNER JOIN [dbo].[ProductLanguage] AS [t10] ON [t10].[ProductID] = [t9].[ProductID]
    ) AS [DESC], (
    SELECT [t13].[LENGTH]
    FROM (
        SELECT TOP (1) [t11].[LENGTH]
        FROM [dbo].[Products] AS [t11]
        INNER JOIN [dbo].[ProductLanguage] AS [t12] ON [t12].[ProductID] = [t11].[ProductID]
        WHERE ([t2].[ProductID] = [t11].[ProductID]) AND ([t12].[LANGUAGE] = @p0)
        ) AS [t13]
    ) AS [LENGTH], (
    SELECT [t16].[Width]
    FROM (
        SELECT TOP (1) [t14].[Width]
        FROM [dbo].[Products] AS [t14]
        INNER JOIN [dbo].[ProductLanguage] AS [t15] ON [t15].[ProductID] = [t14].[ProductID]
        WHERE ([t2].[ProductID] = [t14].[ProductID]) AND ([t15].[LANGUAGE] = @p0)
        ) AS [t16]
    ) AS [Width], (
    SELECT [t19].[Price]
    FROM (
        SELECT TOP (1) [t17].[Price]
        FROM [dbo].[Products] AS [t17]
        INNER JOIN [dbo].[ProductLanguage] AS [t18] ON [t18].[ProductID] = [t17].[ProductID]
        WHERE ([t2].[ProductID] = [t17].[ProductID]) AND ([t18].[LANGUAGE] = @p0)
        ) AS [t19]
    ) AS [Price], (
    SELECT [t22].[Image]
    FROM (
        SELECT TOP (1) [t20].[Image]
        FROM [dbo].[Products] AS [t20]
        INNER JOIN [dbo].[ProductLanguage] AS [t21] ON [t21].[ProductID] = [t20].[ProductID]
        WHERE ([t2].[ProductID] = [t20].[ProductID]) AND ([t21].[LANGUAGE] = @p0)
        ) AS [t22]
    ) AS [Image]
FROM (
    SELECT [t0].[ProductID]
    FROM [dbo].[Products] AS [t0]
    INNER JOIN [dbo].[ProductLanguage] AS [t1] ON [t1].[ProductID] = [t0].[ProductID]
    WHERE [t1].[LANGUAGE] = @p0
    GROUP BY [t0].[ProductID]
    ) AS [t2]
}