Query { SELECT t.*, lc.category_name AS category_name, GREATEST((SELECT max(c.date_added) FROM `flyspray_comments` c WHERE c.task_id = t.task_id), t.date_opened, t.date_closed, t.last_edited_time) AS max_date, lv.version_name AS product_version, uo.real_name AS opened_by_name, lvc.version_name AS closedby_version, los.os_name AS os_name, MIN(u.real_name) AS assigned_to_name, COUNT(DISTINCT ass.user_id) AS num_assigned, p.project_title, p.project_is_active, lst.status_name AS status_name, lt.tasktype_name AS task_type, lr.resolution_name FROM `flyspray_tasks` t LEFT JOIN `flyspray_projects` p ON t.project_id = p.project_id LEFT JOIN `flyspray_list_tasktype` lt ON t.task_type = lt.tasktype_id LEFT JOIN `flyspray_list_status` lst ON t.item_status = lst.status_id LEFT JOIN `flyspray_list_resolution` lr ON t.resolution_reason = lr.resolution_id LEFT JOIN `flyspray_list_category` lc ON t.product_category = lc.category_id LEFT JOIN `flyspray_list_version` lv ON t.product_version = lv.version_id LEFT JOIN `flyspray_users` uo ON t.opened_by = uo.user_id LEFT JOIN `flyspray_list_version` lvc ON t.closedby_version = lvc.version_id LEFT JOIN `flyspray_list_os` los ON t.operating_system = los.os_id LEFT JOIN `flyspray_assigned` ass ON t.task_id = ass.task_id LEFT JOIN `flyspray_users` u ON ass.user_id = u.user_id WHERE ( is_closed <> '1' ) GROUP BY t.task_id ORDER BY u.real_name asc, lvc.list_position desc, t.task_id ASC} with params {} Failed! (Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'support.u.real_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by)