WITH ORDEREDPRODUCTS AS(
SELECT DISTINCT
Product.Id AS ID,
Product.Name AS Name,
Product.ShortDescription AS ShortDescription,
Product.Price As Price,
Product.Sku AS Barcode,
Manufacturer.Name AS Brand,
Category.Name AS Category,
CASE
WHEN Picture.MimeType = 'image/jpeg' THEN '/images/thumbs/' +...