Error, please try again.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 'p.is_main = 1
ORDER BY CASE WHEN c.tier = 0 THEN 999 ELSE...' at line 5SELECT c.id, ROUND(c.price * ss.kurs) as current_price
FROM gl_catalog c
LEFT JOIN currency ss ON (ss.curr = c.curr AND ss.group_idd = c.group_id)
WHERE c.hidden = '0' AND c.gcount > 0 AND c.price > 0
AND ( c.parent_id = '137') p.is_main = 1
ORDER BY CASE WHEN c.tier = 0 THEN 999 ELSE c.tier END ASC, c.`update` DESC
LIMIT 15
