select
	`Order`.ID as OrderID,
	concat("product ", Product.ID, ", ", OrderProduct.Aantal, " stuks") as OrderInhoud,
	round(Product.Prijs * OrderProduct.Aantal) as Subtotaal
from OrderProduct
	left join `Order` on `Order`.ID = OrderProduct.OrderID
	left join Klant on Klant.ID = `Order`.KlantID
	left join Product on Product.ID = OrderProduct.ProductID
where Klant.ID = 1
group by OrderProduct.ProductID, `Order`.ID;
