Guest User

Untitled

a guest
Dec 9th, 2014
169
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select
  2. `r`.`id` AS `id`,
  3. `r`.`name` AS `rolename`,
  4. `r`.`shortname` AS `shortname`,
  5. `cc`.`name` AS `CAPABILITY_NAME`,
  6. `c`.`capability` AS `capability`,
  7. `c`.`permission` AS `permission`
  8. from
  9. (
  10. `moodle`.`mdl_capabilities` `cc`
  11. join
  12. (
  13. `moodle`.`mdl_role` `r`
  14. join `moodle`.`mdl_role_capabilities` `c` on((`r`.`id` = `c`.`roleid`))
  15. )
  16. on((`c`.`capability` = `cc`.`name`))
  17. )
  18. where (`r`.`id` = 2)
  19. ;
RAW Paste Data