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.