0 resultsSELECT mo.sku, substring_index(mo.name,' (',1) as mname, SUM(mo.qty_ordered) AS Menge, prod.volumen_value as vol FROM m_sales_flat_order_item mo JOIN m_catalog_product_flat_1 prod ON prod.sku=mo.sku WHERE mo.created_at between '2025-10-01' and '2025-10-25 23:59:59' AND mo.price > 0 AND mo.qty_canceled = 0 AND mo.name LIKE '%Aroma%' AND mo.name NOT LIKE '%Flasche%' AND prod.volumen_value LIKE '%10 ml%' GROUP by mname Order by Menge DESC