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