MySQL ERROR:

Error Number: 3065

Description: Expression #1 of ORDER BY clause is not in SELECT list, references column 'usr_ud06_165_3.exp_categories.group_id' which is not in SELECT list; this is incompatible with DISTINCT

Query: SELECT DISTINCT(exp_categories.cat_id), exp_categories.parent_id, exp_categories.cat_name, exp_categories.cat_image, exp_categories.cat_description FROM exp_categories WHERE group_id IN ('1') ORDER BY group_id, parent_id, cat_order