SELECT `GlobalRole`.`id`, `GlobalRole`.`name`, `GlobalRole`.`global`, `GlobalRole`.`level`, `GlobalRole`.`group_id`, `GlobalRole`.`description`, `PermRequestsRole`.`id`, `PermRequestsRole`.`perm_request_id`, `PermRequestsRole`.`perm_role_id` FROM `dev_pg`.`perm_roles` AS `GlobalRole` JOIN `dev_pg`.`perm_requests_roles` AS `PermRequestsRole` ON (`PermRequestsRole`.`perm_request_id` = 658 AND `PermRequestsRole`.`perm_role_id` = `GlobalRole`.`id`) WHERE `GlobalRole`.`global` = '1' ORDER BY `GlobalRole`.`level` ASC
SELECT `PermRequest`.`id`, `PermRequest`.`controller`, `PermRequest`.`action`, `PermRequest`.`comment`, (CONCAT(`PermRequest`.`controller`, "/", `PermRequest`.`action`)) AS `PermRequest_full_name` FROM `dev_pg`.`perm_requests` AS `PermRequest` WHERE `controller` = 'edu_randomtasks' AND `action` = 'overview' LIMIT 1 SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `dev_pg`.`cake_sessions` AS `Session` WHERE `Session`.`id` = 'vo2dc42emt3p34g5cunb521htk' LIMIT 1 SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`comment`, `Setting`.`category` FROM `dev_pg`.`settings` AS `Setting` WHERE `Setting`.`key` = 'schoolyear' LIMIT 1