1064 - 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 '(select customers_group_price from products_groups where products_id = p.product' at line 3

SELECT p.products_id, p.products_model, p.products_price, pd.products_name, cd.categories_name as cat_name, cd.categories_htc_desc_tag as descr, (SELECT trads_description from trads WHERE trads_id = pc.details_bij AND language_id = 1 ) as details_bij (select customers_group_price from products_groups where products_id = p.products_id AND customers_group_id = '0' LIMIT 1) as customers_group_price FROM products p LEFT JOIN products_certificat pc ON (p.products_id = pc.products_id) LEFT JOIN products_description pd ON (p.products_id = pd.products_id) LEFT JOIN products_to_categories p2c ON (p.products_id = p2c.products_id) LEFT JOIN categories c ON (p2c.categories_id = c.categories_id) LEFT JOIN categories_description cd ON (cd.categories_id = c.categories_id) WHERE p.products_id = '7954' and cd.language_id =1 and pd.language_id =1

[TEP STOP]