Database error: Invalid SQL: SELECT cat.id,cat.parent,cat.name_en AS name, count(obj.id) AS anz
FROM obj_cats cat
LEFT OUTER JOIN obj_cat oc ON (cat.id=oc.id_cat)
LEFT OUTER JOIN obj ON (obj.id=oc.id_obj)
WHERE cat.parent IS NULL AND obj.city_id=12
GROUP BY cat.id
HAVING anz>0
ORDER BY cat.name
MySQL Error: 1054 (Unknown column 'cat.name' in 'order clause')
Session halted.