Query {SELECT t.*, lr.resolution_name,  lt.tasktype_name,  lst.status_name,  lc.category_name AS category_name,  lvc.version_name AS closedby_version_name,  MIN(u.user_name) AS assigned_to_name,  (SELECT COUNT(assc.user_id) FROM `flyspray_assigned` assc WHERE assc.task_id = t.task_id) AS num_assigned,  MIN(tg.tag_id) AS tagids, NULL AS desccache, 
p.project_title, p.project_is_active
FROM  `flyspray_tasks` t
-- All tasks have a project!
JOIN `flyspray_projects` p ON t.project_id = p.project_id LEFT JOIN `flyspray_assigned` ass ON t.task_id = ass.task_id LEFT JOIN `flyspray_task_tag` tt ON t.task_id = tt.task_id LEFT JOIN `flyspray_list_tag` flt ON tt.tag_id = flt.tag_id LEFT JOIN `flyspray_list_resolution` lr ON t.resolution_reason = lr.resolution_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_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_users` u ON ass.user_id = u.user_id 
LEFT JOIN `flyspray_list_tag` tg ON tt.tag_id = tg.tag_id 
WHERE t.project_id = ? AND ( is_closed = 0 ) AND t.mark_private = 0 AND p.others_view = 1
GROUP BY t.task_id

ORDER BY u.real_name asc, task_severity 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)