accessoires

Test:SELECT p.[Id], p.[Price], p.[SetupCosts], p.[MinimumAmount], p.[Overpack], p.[Delivery], p.[SoldOut], (SELECT TOP 1 psp.[Price] FROM tWebshopProductsStaggeredPrice AS psp WHERE psp.[ProductId] = p.[Id] AND psp.Deleted = 0 ORDER BY psp.[Price] ASC, psp.Id ASC ) As [StaffelPrice], pd.[Name], pd.[Description] FROM (((tWebshopCategories AS c INNER JOIN tWebshopCategoryProducts AS cp ON cp.[CategoryId] = c.[Id]) INNER JOIN tWebshopProducts AS p ON p.[Id] = cp.[ProductId]) INNER JOIN tWebshopProductDescriptions AS pd ON pd.[ProductId] = p.[Id]) WHERE c.Id = 72 AND pd.[LanguageId] = 1 AND p.Id = 589 AND p.[Show] = True AND p.[Deleted] = false ;