Error, please try again.Unknown column 'c.tier' in 'ORDER BY'SELECT 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.newest > 0
ORDER BY CASE WHEN c.tier = 0 THEN 999 ELSE c.tier END ASC, c.`update` DESC
LIMIT 15