Query {
                          SELECT   t.*,  lc.category_name               AS category_name,  lvc.version_name               AS closedby_version,  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` lvc  ON t.closedby_version = lvc.version_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 t.project_id = ? AND ( is_closed <> '1' )
                          GROUP BY t.task_id
                          
                          ORDER BY u.real_name asc, t.task_id desc, t.task_id ASC} with params {1} Failed! (Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'flyspray.u.real_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by)