[HaBo]

select
	permissions.id
from users

left join users_permissions
       on users_permissions.user = users.id

left join users_roles
       on users_roles.user = users.id

left join roles_permissions
       on roles_permissions.role = users_roles.role

left join permissions
       on permissions.id = users_permissions.permission
       or permissions.id = roles_permissions.permission

where users.id = 0815

group by (permissions.id)
order by (permissions.id) ASC;

 - users
 - roles
 - permissions
 - users_roles
 - users_permissions
 - roles_permissions