SELECT
webshop_products.*,
webshop_products.id AS id,
i.name AS pri_image,
pi.id AS pri_image_id,
i2.name AS hover_image,
pi2.id AS hover_image_id,
wu.name AS unit_name,
sl.external_location,
wo.name AS category1_name,
IF(wpc.composed_product_identifier_id > 0, 1, 0) AS is_composed_master_product,
GROUP_CONCAT(DISTINCT pt.tag_id SEPARATOR ',') AS tags_id
FROM `webshop_products`
LEFT JOIN `webshop_options` AS wo ON `webshop_products`.`category1` = `wo`.`id`
LEFT JOIN `webshop_units` AS wu ON webshop_products.unit_id=wu.id
LEFT JOIN `webshop_product_tags` AS pt ON pt.product_id=webshop_products.identifier_id
LEFT JOIN `webshop_product_images` AS pi ON webshop_products.identifier_id=pi.product_id AND pi.primary_img='1'
LEFT JOIN `webshop_product_images` AS pi2 ON webshop_products.identifier_id=pi2.product_id AND pi2.is_hover_image='1'
LEFT JOIN `webshop_stock_locations` AS sl ON sl.id=webshop_products.stock_location_id
LEFT JOIN `images` AS i ON pi.image_id=i.id
LEFT JOIN `images` AS i2 ON pi2.image_id=i2.id
LEFT JOIN `webshop_product_composed` AS wpc ON wpc.produkt_identifier_id=webshop_products.identifier_id
WHERE `webshop_products`.`hide`!='1' AND (`webshop_products`.`hide_language` != '1' AND `webshop_products`.language_id = 1) AND `language_id`='1' `language_id`='1' AND `category1` IN('47') GROUP BY webshop_products.identifier_id ORDER BY order_by ASC, identifier_id ASC LIMIT 0 , 30
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '`language_id`='1' AND `category1` IN('47') GROUP BY webshop_products.identif...' at line 25