Internal error is generated when affecting members to projects .

The used database is   MySQL 8.0.11 Community Server.

As the logs below, the main issue is coming for the fact that the SQL query used to count the members is using the alias GROUPS instead of `GROUPS ` which is a reserved keyword in MYSQL 8 .

Looking forward for a solution to overcome this issue .

Completed 500 Internal Server E
rror in 455ms (ActiveRecord: 29.5ms)
F, [2019-02-11T22:08:50.961838 #3403] FATAL -- :
F, [2019-02-11T22:08:50.961914 #3403] FATAL -- : ActionView::Template::Error (My
sql2::Error: You have an error in your SQL syntax; check the manual that corresp
onds to your MySQL server version for the right syntax to use near 'groups
ON groups.id = group_users.group_id WHERE `members`.`id` IN' at li
ne 3: SELECT COUNT(DISTINCT `members`.`id`) FROM `members` LEFT OUTER JOIN `memb
er_roles` ON `member_roles`.`member_id` = `members`.`id` LEFT OUTER JOIN `roles`
ON `roles`.`id` = `member_roles`.`role_id` LEFT OUTER JOIN `users` ON `users`.`
id` = `members`.`user_id` LEFT OUTER JOIN `member_roles` `member_roles_members`
ON `member_roles_members`.`member_id` = `members`.`id` LEFT JOIN group_users AS
group_users
ON group_users.user_id = members.user_id
LEFT JOIN (SELECT id, lastname AS group_name FROM users) AS groups
ON groups.id = group_users.group_id WHERE `members`.`id` IN (SELEC
T `members`.`id` FROM `members` WHERE (members.project_id IN ('6')))):