Ponorné odstředivé čerpadlo 3,5SEm2/8

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 'GROUP BY p.parameter_types_id) as px INNER JOIN parameter...' at line 7
in:
[SELECT if(p.value = 0, plg.name, pt.name) as `type`, CAST(if(p.value = 0, pl.name, p.value) as CHAR(50)) as `value`, p.value_to as `value_to`, u.name as unit FROM (SELECT p.parameter_types_id, MAX(shops_id) as shops_id FROM parameters p WHERE shops_id IN (0, 2) AND products_id = GROUP BY p.parameter_types_id) as px INNER JOIN parameters p ON p.parameter_types_id = px.parameter_types_id AND p.shops_id = px.shops_id INNER JOIN parameter_types pt ON p.parameter_types_id = pt.id LEFT OUTER JOIN parameters_lov pl ON pl.id = p.parameters_lov_id LEFT OUTER JOIN parameters_lov_groups plg ON pl.parameters_lov_groups_id = plg.id LEFT OUTER JOIN units u ON u.id = pt.units_id WHERE products_id = ORDER BY pt.sort DESC]