select
`r`.`id` AS `id`,
`r`.`name` AS `rolename`,
`r`.`shortname` AS `shortname`,
`cc`.`name` AS `CAPABILITY_NAME`,
`c`.`capability` AS `capability`,
`c`.`permission` AS `permission`
from
(
   `moodle`.`mdl_capabilities` `cc`
   join
   (
      `moodle`.`mdl_role` `r`
      join `moodle`.`mdl_role_capabilities` `c` on((`r`.`id` = `c`.`roleid`))
   )
   on((`c`.`capability` = `cc`.`name`))
)
where (`r`.`id` = 2)
;