SELECT
    RPAD(p.number, 12, '0') AS Artikelnummer,
    p.ean AS ean,
    p.name AS name,
	p.variant AS variant,
	CASE
		WHEN p.variant LIKE '%g kl. Glas%' THEN 'Gewürz'
		WHEN p.variant LIKE '%g Glas%' THEN 'Gewürz'
		WHEN p.variant LIKE '%ml Glas%' THEN 'Essig & Öl'
		ELSE 'ERROR Kategorie' END
	AS Kategorie,
	CASE
		WHEN p.variant LIKE '%g kl. Glas%' THEN '6'
		WHEN p.variant LIKE '%g Glas%' THEN '5'
		WHEN p.variant LIKE '%ml Glas%' THEN '1'
		ELSE 'ERROR Stueck' END
	AS Stueck,
	ROUND(p.price * 100) AS uvp,
	ROUND(p.price * 100) AS preis,
	CASE
		WHEN p.variant LIKE '%g kl. Glas%' THEN 'kg'
		WHEN p.variant LIKE '%g Glas%' THEN 'kg'
		WHEN p.variant LIKE '%ml Glas%' THEN 'l'
		ELSE 'ERROR einheit' END
	AS Einheit,
	'aktiv' as Verfügbar
FROM produkte AS p
ORDER BY p.number ASC
