SELECT svai.*, sum(quantity) as quantity,shop_item_has_category.category_line_no, shop_category.code
FROM `shop_sales_line`
INNER JOIN shop_view_active_item svai
ON svai.company = shop_sales_line.company
AND svai.shop_code = shop_sales_line.shop_code
AND svai.language_code = shop_sales_line.language_code
AND svai.item_no = shop_sales_line.item_no
INNER JOIN shop_sales_header ON shop_sales_header.id = shop_sales_line.shop_sales_header_id
AND shop_sales_header.order_date > DATE_SUB(curdate(),INTERVAL 3 MONTH) AND shop_sales_header.order_error = 0
INNER JOIN shop_item_has_category ON shop_item_has_category.item_no = shop_sales_line.item_no
INNER JOIN shop_category ON shop_category.line_no = shop_item_has_category.category_line_no
WHERE shop_sales_line.company = 'IMAGE Ident Marketing'
AND shop_sales_line.shop_code = 'EINE-WELT'
AND shop_sales_line.language_code = 'DEU'
AND shop_sales_line.item_no <> 'A100566'
AND svai.release_necessary = 0
GROUP BY shop_sales_line.item_no
ORDER BY quantity DESC
LIMIT 12
