| 1 | SELECT "Setting"."id" AS "Setting__id", "Setting"."name" AS "Setting__name", "Setting"."value" AS "Setting__value" FROM "public"."ss20_settings" AS "Setting" WHERE 1 = 1 | | 19 | 19 | 0 |
| 2 | SELECT "GlobalSetting"."id" AS "GlobalSetting__id", "GlobalSetting"."name" AS "GlobalSetting__name", "GlobalSetting"."value" AS "GlobalSetting__value" FROM "public"."global_settings" AS "GlobalSetting" WHERE "name" = 'password_hash' LIMIT 1 | | 1 | 1 | 1 |
| 3 | SELECT "Aro"."id" AS "Aro__id", "Aro"."parent_id" AS "Aro__parent_id", "Aro"."model" AS "Aro__model", "Aro"."foreign_key" AS "Aro__foreign_key", "Aro"."alias" AS "Aro__alias", "Aro"."lft" AS "Aro__lft", "Aro"."rght" AS "Aro__rght" FROM "public"."ss20_aros" AS "Aro" WHERE "Aro"."model" = 'Group' AND "Aro"."foreign_key" = 4 LIMIT 1 | | 1 | 1 | 1 |
| 4 | SELECT "Aco"."id" AS "Aco__id", "Aco"."parent_id" AS "Aco__parent_id", "Aco"."model" AS "Aco__model", "Aco"."foreign_key" AS "Aco__foreign_key", "Aco"."alias" AS "Aco__alias", "Aco"."lft" AS "Aco__lft", "Aco"."rght" AS "Aco__rght", "Permission"."id" AS "Permission__id", "Permission"."aro_id" AS "Permission__aro_id", "Permission"."aco_id" AS "Permission__aco_id", "Permission"."_create" AS "Permission___create", "Permission"."_read" AS "Permission___read", "Permission"."_update" AS "Permission___update", "Permission"."_delete" AS "Permission___delete" FROM "public"."ss20_acos" AS "Aco" JOIN "public"."ss20_aros_acos" AS "Permission" ON ("Permission"."aro_id" = 1 AND "Permission"."aco_id" = "Aco"."id") | | 360 | 360 | 2 |
| 5 | SELECT "Aco"."id" AS "Aco__id", "Aco"."parent_id" AS "Aco__parent_id", "Aco"."model" AS "Aco__model", "Aco"."foreign_key" AS "Aco__foreign_key", "Aco"."alias" AS "Aco__alias", "Aco"."lft" AS "Aco__lft", "Aco"."rght" AS "Aco__rght" FROM "public"."ss20_acos" AS "Aco" WHERE 1 = 1 | | 474 | 474 | 1 |
| 6 | SELECT "Aro"."id" AS "Aro__id", "Aro"."parent_id" AS "Aro__parent_id", "Aro"."model" AS "Aro__model", "Aro"."foreign_key" AS "Aro__foreign_key", "Aro"."alias" AS "Aro__alias", "Aro"."lft" AS "Aro__lft", "Aro"."rght" AS "Aro__rght", "Permission"."id" AS "Permission__id", "Permission"."aro_id" AS "Permission__aro_id", "Permission"."aco_id" AS "Permission__aco_id", "Permission"."_create" AS "Permission___create", "Permission"."_read" AS "Permission___read", "Permission"."_update" AS "Permission___update", "Permission"."_delete" AS "Permission___delete" FROM "public"."ss20_aros" AS "Aro" JOIN "public"."ss20_aros_acos" AS "Permission" ON ("Permission"."aco_id" IN (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 65, 66, 67, 68, 69, 64, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 89, 90, 91, 92, 93, 94, 325, 240, 235, 241, 242, 243, 244, 245, 246, 247, 95, 96, 97, 481, 482, 484, 473, 270, 271, 272, 273, 274, 98, 99, 100, 101, 102, 103, 355, 356, 358, 359, 361, 362, 165, 88, 1, 483, 166, 167, 363, 365, 250, 366, 367, 282, 283, 284, 285, 286, 287, 288, 289, 346, 257, 368, 369, 370, 371, 372, 373, 374, 375, 376, 377, 378, 379, 380, 291, 290, 332, 333, 334, 335, 337, 336, 338, 341, 342, 343, 345, 249, 471, 403, 405, 188, 381, 382, 383, 384, 386, 387, 388, 390, 391, 393, 394, 395, 396, 397, 261, 262, 263, 168, 169, 170, 264, 265, 266, 267, 268, 269, 275, 276, 277, 278, 279, 280, 281, 398, 399, 400, 401, 402, 186, 187, 406, 407, 408, 409, 410, 422, 411, 412, 189, 190, 191, 413, 416, 420, 421, 423, 424, 427, 428, 429, 430, 431, 432, 433, 434, 435, 436, 437, 438, 439, 440, 441, 442, 443, 445, 446, 447, 448, 449, 450, 451, 251, 252, 253, 339, 348, 474, 485, 360, 453, 454, 455, 456, 457, 458, 479, 322, 323, 324, 470, 196, 294, 295, 296, 297, 298, 299, 300, 301, 302, 467, 468, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 237, 238, 239, 465, 312, 313, 314, 315, 316, 317, 319, 320, 321, 318, 480, 476, 478, 143, 469, 404, 347, 351, 352, 353, 354, 417, 459, 460, 461, 254, 255, 256, 258, 259, 260, 340, 349, 292, 418, 419, 425, 155, 160, 161, 162, 163, 164, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 192, 193, 194, 195, 197, 198, 199, 200, 201, 202, 203, 204, 466, 462, 463, 464, 248, 385, 137, 138, 139, 140, 141, 142, 472, 475, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 156, 157, 158, 159, 293, 303, 304, 305, 306, 307, 308, 309, 310, 311, 326, 327, 328, 329, 330, 331, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 236, 477) AND "Permission"."aro_id" = "Aro"."id") | | 1453 | 1453 | 4 |
| 7 | SELECT "GlobalSetting"."id" AS "GlobalSetting__id", "GlobalSetting"."name" AS "GlobalSetting__name", "GlobalSetting"."value" AS "GlobalSetting__value" FROM "public"."global_settings" AS "GlobalSetting" WHERE "name" = 'theme' LIMIT 1 | | 1 | 1 | 1 |
| 8 | SELECT "Content"."id" AS "Content__id", "Content"."title" AS "Content__title" FROM "public"."ss20_content" AS "Content" WHERE "menu_visible" = 'TRUE' ORDER BY "orderid" asc | | 5 | 5 | 1 |
| 9 | SELECT "ExternalAuth"."id" AS "ExternalAuth__id", "ExternalAuth"."menu_name" AS "ExternalAuth__menu_name", "ExternalAuth"."menu_url" AS "ExternalAuth__menu_url" FROM "public"."ss20_external_auth" AS "ExternalAuth" WHERE NOT ("ExternalAuth"."menu_name" IS NULL) AND NOT ("ExternalAuth"."menu_url" IS NULL) ORDER BY "id" asc | | 0 | 0 | 1 |
| 10 | SELECT "Aro"."id" AS "Aro__id", "Aro"."parent_id" AS "Aro__parent_id", "Aro"."model" AS "Aro__model", "Aro"."foreign_key" AS "Aro__foreign_key", "Aro"."alias" AS "Aro__alias" FROM "public"."ss20_aros" AS "Aro" INNER JOIN "public"."ss20_aros" AS "Aro0" ON ("Aro"."lft" <= "Aro0"."lft" AND "Aro"."rght" >= "Aro0"."rght") WHERE "Aro0"."model" = 'Group' AND "Aro0"."foreign_key" = 4 ORDER BY "Aro"."lft" DESC | | 1 | 1 | 1 |
| 11 | SELECT "Aco"."id" AS "Aco__id", "Aco"."parent_id" AS "Aco__parent_id", "Aco"."model" AS "Aco__model", "Aco"."foreign_key" AS "Aco__foreign_key", "Aco"."alias" AS "Aco__alias" FROM "public"."ss20_acos" AS "Aco" INNER JOIN "public"."ss20_acos" AS "Aco0" ON ("Aco"."lft" <= "Aco0"."lft" AND "Aco"."rght" >= "Aco0"."rght") WHERE "Aco0"."model" = 'Content' AND "Aco0"."foreign_key" = 2 ORDER BY "Aco"."lft" DESC | | 2 | 2 | 1 |
| 12 | SELECT "Permission"."id" AS "Permission__id", "Permission"."aro_id" AS "Permission__aro_id", "Permission"."aco_id" AS "Permission__aco_id", "Permission"."_create" AS "Permission___create", "Permission"."_read" AS "Permission___read", "Permission"."_update" AS "Permission___update", "Permission"."_delete" AS "Permission___delete", "Aco"."id" AS "Aco__id", "Aco"."parent_id" AS "Aco__parent_id", "Aco"."model" AS "Aco__model", "Aco"."foreign_key" AS "Aco__foreign_key", "Aco"."alias" AS "Aco__alias", "Aco"."lft" AS "Aco__lft", "Aco"."rght" AS "Aco__rght" FROM "public"."ss20_aros_acos" AS "Permission" LEFT JOIN "public"."ss20_acos" AS "Aco" ON ("Permission"."aco_id" = "Aco"."id") WHERE "Permission"."aro_id" = 1 AND "Permission"."aco_id" IN (291, 285) ORDER BY "Aco"."lft" desc | | 2 | 2 | 1 |
| 13 | SELECT "Aco"."id" AS "Aco__id", "Aco"."parent_id" AS "Aco__parent_id", "Aco"."model" AS "Aco__model", "Aco"."foreign_key" AS "Aco__foreign_key", "Aco"."alias" AS "Aco__alias" FROM "public"."ss20_acos" AS "Aco" INNER JOIN "public"."ss20_acos" AS "Aco0" ON ("Aco"."lft" <= "Aco0"."lft" AND "Aco"."rght" >= "Aco0"."rght") WHERE "Aco0"."model" = 'Content' AND "Aco0"."foreign_key" = 3 ORDER BY "Aco"."lft" DESC | | 2 | 2 | 1 |
| 14 | SELECT "Permission"."id" AS "Permission__id", "Permission"."aro_id" AS "Permission__aro_id", "Permission"."aco_id" AS "Permission__aco_id", "Permission"."_create" AS "Permission___create", "Permission"."_read" AS "Permission___read", "Permission"."_update" AS "Permission___update", "Permission"."_delete" AS "Permission___delete", "Aco"."id" AS "Aco__id", "Aco"."parent_id" AS "Aco__parent_id", "Aco"."model" AS "Aco__model", "Aco"."foreign_key" AS "Aco__foreign_key", "Aco"."alias" AS "Aco__alias", "Aco"."lft" AS "Aco__lft", "Aco"."rght" AS "Aco__rght" FROM "public"."ss20_aros_acos" AS "Permission" LEFT JOIN "public"."ss20_acos" AS "Aco" ON ("Permission"."aco_id" = "Aco"."id") WHERE "Permission"."aro_id" = 1 AND "Permission"."aco_id" IN (292, 285) ORDER BY "Aco"."lft" desc | | 2 | 2 | 1 |
| 15 | SELECT "Aco"."id" AS "Aco__id", "Aco"."parent_id" AS "Aco__parent_id", "Aco"."model" AS "Aco__model", "Aco"."foreign_key" AS "Aco__foreign_key", "Aco"."alias" AS "Aco__alias" FROM "public"."ss20_acos" AS "Aco" INNER JOIN "public"."ss20_acos" AS "Aco0" ON ("Aco"."lft" <= "Aco0"."lft" AND "Aco"."rght" >= "Aco0"."rght") WHERE "Aco0"."model" = 'Content' AND "Aco0"."foreign_key" = 4 ORDER BY "Aco"."lft" DESC | | 2 | 2 | 1 |
| 16 | SELECT "Permission"."id" AS "Permission__id", "Permission"."aro_id" AS "Permission__aro_id", "Permission"."aco_id" AS "Permission__aco_id", "Permission"."_create" AS "Permission___create", "Permission"."_read" AS "Permission___read", "Permission"."_update" AS "Permission___update", "Permission"."_delete" AS "Permission___delete", "Aco"."id" AS "Aco__id", "Aco"."parent_id" AS "Aco__parent_id", "Aco"."model" AS "Aco__model", "Aco"."foreign_key" AS "Aco__foreign_key", "Aco"."alias" AS "Aco__alias", "Aco"."lft" AS "Aco__lft", "Aco"."rght" AS "Aco__rght" FROM "public"."ss20_aros_acos" AS "Permission" LEFT JOIN "public"."ss20_acos" AS "Aco" ON ("Permission"."aco_id" = "Aco"."id") WHERE "Permission"."aro_id" = 1 AND "Permission"."aco_id" IN (332, 285) ORDER BY "Aco"."lft" desc | | 2 | 2 | 1 |
| 17 | SELECT "Aco"."id" AS "Aco__id", "Aco"."parent_id" AS "Aco__parent_id", "Aco"."model" AS "Aco__model", "Aco"."foreign_key" AS "Aco__foreign_key", "Aco"."alias" AS "Aco__alias" FROM "public"."ss20_acos" AS "Aco" INNER JOIN "public"."ss20_acos" AS "Aco0" ON ("Aco"."lft" <= "Aco0"."lft" AND "Aco"."rght" >= "Aco0"."rght") WHERE "Aco0"."model" = 'Content' AND "Aco0"."foreign_key" = 5 ORDER BY "Aco"."lft" DESC | | 2 | 2 | 1 |
| 18 | SELECT "Permission"."id" AS "Permission__id", "Permission"."aro_id" AS "Permission__aro_id", "Permission"."aco_id" AS "Permission__aco_id", "Permission"."_create" AS "Permission___create", "Permission"."_read" AS "Permission___read", "Permission"."_update" AS "Permission___update", "Permission"."_delete" AS "Permission___delete", "Aco"."id" AS "Aco__id", "Aco"."parent_id" AS "Aco__parent_id", "Aco"."model" AS "Aco__model", "Aco"."foreign_key" AS "Aco__foreign_key", "Aco"."alias" AS "Aco__alias", "Aco"."lft" AS "Aco__lft", "Aco"."rght" AS "Aco__rght" FROM "public"."ss20_aros_acos" AS "Permission" LEFT JOIN "public"."ss20_acos" AS "Aco" ON ("Permission"."aco_id" = "Aco"."id") WHERE "Permission"."aro_id" = 1 AND "Permission"."aco_id" IN (333, 285) ORDER BY "Aco"."lft" desc | | 2 | 2 | 1 |
| 19 | SELECT "Tutor"."id" AS "Tutor__id", "Tutor"."user_id" AS "Tutor__user_id", "Tutor"."homepage" AS "Tutor__homepage", "Tutor"."issupervision" AS "Tutor__issupervision", "Tutor"."isassistant" AS "Tutor__isassistant", "Tutor"."iscontact" AS "Tutor__iscontact", "Tutor"."show_in_team" AS "Tutor__show_in_team", "Tutor"."show_email" AS "Tutor__show_email", "Tutor"."email_news" AS "Tutor__email_news", "Tutor"."email_feedback" AS "Tutor__email_feedback", "Tutor"."email_submission" AS "Tutor__email_submission", (select CONCAT('#', "Tutor"."id", ' - ', first, ' ', last) from global_users where "global_users"."id" = "Tutor"."user_id") AS "Tutor__display", "User"."id" AS "User__id", "User"."email" AS "User__email", "User"."username" AS "User__username", "User"."password" AS "User__password", "User"."first" AS "User__first", "User"."last" AS "User__last", "User"."created" AS "User__created", "User"."modified" AS "User__modified", "User"."password_rehashed" AS "User__password_rehashed", "User"."banned" AS "User__banned", "User"."twofa" AS "User__twofa", "User"."twofamethod" AS "User__twofamethod", "User"."nighttheme" AS "User__nighttheme", "User"."email_last_reset" AS "User__email_last_reset", "User"."webauthn_identity" AS "User__webauthn_identity", (SELECT group_id FROM ss20_usergroups WHERE id="User"."id") AS "User__group_id", (CONCAT(first,' ', last)) AS "User__display" FROM "public"."ss20_tutors" AS "Tutor" LEFT JOIN "public"."global_users" AS "User" ON ("Tutor"."user_id" = "User"."id") WHERE "isassistant" = 2 ORDER BY "User"."last" ASC, "User"."first" ASC | | 1 | 1 | 2 |
| 20 | SELECT "Course"."id" AS "Course__id", "Course"."shortname" AS "Course__shortname", "Course"."name" AS "Course__name", "Course"."systemversion" AS "Course__systemversion", "Course"."term" AS "Course__term", "Course"."term_year" AS "Course__term_year", "Course"."course_type" AS "Course__course_type", "Course"."credit_points" AS "Course__credit_points", "Course"."is_visible" AS "Course__is_visible", "Course"."instructors" AS "Course__instructors", (CONCAT("Course"."name", ' (', "Course"."term", ' ', "Course"."term_year", ')')) AS "Course__display" FROM "public"."global_courses" AS "Course" WHERE "Course"."id" = 8 LIMIT 1 | | 1 | 1 | 1 |
| 21 | SELECT "Setting"."id" AS "Setting__id", "Setting"."name" AS "Setting__name", "Setting"."value" AS "Setting__value" FROM "public"."ss20_settings" AS "Setting" WHERE 1 = 1 | | 19 | 19 | 0 |
| 22 | SELECT "Content"."id" AS "Content__id", "Content"."title" AS "Content__title", "Content"."content" AS "Content__content", "Content"."link" AS "Content__link", "Content"."author" AS "Content__author", "Content"."orderid" AS "Content__orderid", "Content"."menu_visible" AS "Content__menu_visible", "Content"."created" AS "Content__created", "Content"."modified" AS "Content__modified", "Content"."csp_sources" AS "Content__csp_sources", "User"."id" AS "User__id", "User"."email" AS "User__email", "User"."username" AS "User__username", "User"."password" AS "User__password", "User"."first" AS "User__first", "User"."last" AS "User__last", "User"."created" AS "User__created", "User"."modified" AS "User__modified", "User"."password_rehashed" AS "User__password_rehashed", "User"."banned" AS "User__banned", "User"."twofa" AS "User__twofa", "User"."twofamethod" AS "User__twofamethod", "User"."nighttheme" AS "User__nighttheme", "User"."email_last_reset" AS "User__email_last_reset", "User"."webauthn_identity" AS "User__webauthn_identity", (SELECT group_id FROM ss20_usergroups WHERE id="User"."id") AS "User__group_id", (CONCAT(first,' ', last)) AS "User__display" FROM "public"."ss20_content" AS "Content" LEFT JOIN "public"."global_users" AS "User" ON ("Content"."author" = "User"."id") WHERE "Content"."id" = 1 LIMIT 1 | | 1 | 1 | 1 |
| 23 | SELECT "Course"."id" AS "Course__id", "Course"."shortname" AS "Course__shortname", "Course"."name" AS "Course__name", "Course"."systemversion" AS "Course__systemversion", "Course"."term" AS "Course__term", "Course"."term_year" AS "Course__term_year", "Course"."course_type" AS "Course__course_type", "Course"."credit_points" AS "Course__credit_points", "Course"."is_visible" AS "Course__is_visible", "Course"."instructors" AS "Course__instructors", (CONCAT("Course"."name", ' (', "Course"."term", ' ', "Course"."term_year", ')')) AS "Course__display" FROM "public"."global_courses" AS "Course" WHERE "Course"."id" = 8 LIMIT 1 | | 1 | 1 | 0 |
| 24 | SELECT "Date"."id" AS "Date__id", "Date"."start" AS "Date__start", "Date"."end" AS "Date__end", "Date"."timematters" AS "Date__timematters", "Date"."hint" AS "Date__hint", "Date"."name" AS "Date__name", "Date"."is_unknown" AS "Date__is_unknown" FROM "public"."ss20_dates" AS "Date" WHERE 1 = 1 | | 3 | 3 | 1 |
| 25 | SELECT "Setting"."id" AS "Setting__id", "Setting"."name" AS "Setting__name", "Setting"."value" AS "Setting__value" FROM "public"."ss20_settings" AS "Setting" WHERE 1 = 1 | | 19 | 19 | 0 |
| 26 | SELECT "GlobalSetting"."id" AS "GlobalSetting__id", "GlobalSetting"."name" AS "GlobalSetting__name", "GlobalSetting"."value" AS "GlobalSetting__value" FROM "public"."global_settings" AS "GlobalSetting" WHERE "name" = 'password_hash' LIMIT 1 | | 1 | 1 | 0 |
| 27 | SELECT "Aro"."id" AS "Aro__id", "Aro"."parent_id" AS "Aro__parent_id", "Aro"."model" AS "Aro__model", "Aro"."foreign_key" AS "Aro__foreign_key", "Aro"."alias" AS "Aro__alias", "Aro"."lft" AS "Aro__lft", "Aro"."rght" AS "Aro__rght" FROM "public"."ss20_aros" AS "Aro" WHERE "Aro"."model" = 'Group' AND "Aro"."foreign_key" = 4 LIMIT 1 | | 1 | 1 | 0 |
| 28 | SELECT "Aco"."id" AS "Aco__id", "Aco"."parent_id" AS "Aco__parent_id", "Aco"."model" AS "Aco__model", "Aco"."foreign_key" AS "Aco__foreign_key", "Aco"."alias" AS "Aco__alias", "Aco"."lft" AS "Aco__lft", "Aco"."rght" AS "Aco__rght", "Permission"."id" AS "Permission__id", "Permission"."aro_id" AS "Permission__aro_id", "Permission"."aco_id" AS "Permission__aco_id", "Permission"."_create" AS "Permission___create", "Permission"."_read" AS "Permission___read", "Permission"."_update" AS "Permission___update", "Permission"."_delete" AS "Permission___delete" FROM "public"."ss20_acos" AS "Aco" JOIN "public"."ss20_aros_acos" AS "Permission" ON ("Permission"."aro_id" = 1 AND "Permission"."aco_id" = "Aco"."id") | | 360 | 360 | 1 |
| 29 | SELECT "Aco"."id" AS "Aco__id", "Aco"."parent_id" AS "Aco__parent_id", "Aco"."model" AS "Aco__model", "Aco"."foreign_key" AS "Aco__foreign_key", "Aco"."alias" AS "Aco__alias", "Aco"."lft" AS "Aco__lft", "Aco"."rght" AS "Aco__rght" FROM "public"."ss20_acos" AS "Aco" WHERE 1 = 1 | | 474 | 474 | 1 |
| 30 | SELECT "Aro"."id" AS "Aro__id", "Aro"."parent_id" AS "Aro__parent_id", "Aro"."model" AS "Aro__model", "Aro"."foreign_key" AS "Aro__foreign_key", "Aro"."alias" AS "Aro__alias", "Aro"."lft" AS "Aro__lft", "Aro"."rght" AS "Aro__rght", "Permission"."id" AS "Permission__id", "Permission"."aro_id" AS "Permission__aro_id", "Permission"."aco_id" AS "Permission__aco_id", "Permission"."_create" AS "Permission___create", "Permission"."_read" AS "Permission___read", "Permission"."_update" AS "Permission___update", "Permission"."_delete" AS "Permission___delete" FROM "public"."ss20_aros" AS "Aro" JOIN "public"."ss20_aros_acos" AS "Permission" ON ("Permission"."aco_id" IN (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 65, 66, 67, 68, 69, 64, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 89, 90, 91, 92, 93, 94, 325, 240, 235, 241, 242, 243, 244, 245, 246, 247, 95, 96, 97, 481, 482, 484, 473, 270, 271, 272, 273, 274, 98, 99, 100, 101, 102, 103, 355, 356, 358, 359, 361, 362, 165, 88, 1, 483, 166, 167, 363, 365, 250, 366, 367, 282, 283, 284, 285, 286, 287, 288, 289, 346, 257, 368, 369, 370, 371, 372, 373, 374, 375, 376, 377, 378, 379, 380, 291, 290, 332, 333, 334, 335, 337, 336, 338, 341, 342, 343, 345, 249, 471, 403, 405, 188, 381, 382, 383, 384, 386, 387, 388, 390, 391, 393, 394, 395, 396, 397, 261, 262, 263, 168, 169, 170, 264, 265, 266, 267, 268, 269, 275, 276, 277, 278, 279, 280, 281, 398, 399, 400, 401, 402, 186, 187, 406, 407, 408, 409, 410, 422, 411, 412, 189, 190, 191, 413, 416, 420, 421, 423, 424, 427, 428, 429, 430, 431, 432, 433, 434, 435, 436, 437, 438, 439, 440, 441, 442, 443, 445, 446, 447, 448, 449, 450, 451, 251, 252, 253, 339, 348, 474, 485, 360, 453, 454, 455, 456, 457, 458, 479, 322, 323, 324, 470, 196, 294, 295, 296, 297, 298, 299, 300, 301, 302, 467, 468, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 237, 238, 239, 465, 312, 313, 314, 315, 316, 317, 319, 320, 321, 318, 480, 476, 478, 143, 469, 404, 347, 351, 352, 353, 354, 417, 459, 460, 461, 254, 255, 256, 258, 259, 260, 340, 349, 292, 418, 419, 425, 155, 160, 161, 162, 163, 164, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 192, 193, 194, 195, 197, 198, 199, 200, 201, 202, 203, 204, 466, 462, 463, 464, 248, 385, 137, 138, 139, 140, 141, 142, 472, 475, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 156, 157, 158, 159, 293, 303, 304, 305, 306, 307, 308, 309, 310, 311, 326, 327, 328, 329, 330, 331, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 236, 477) AND "Permission"."aro_id" = "Aro"."id") | | 1453 | 1453 | 3 |
| 31 | SELECT "GlobalSetting"."id" AS "GlobalSetting__id", "GlobalSetting"."name" AS "GlobalSetting__name", "GlobalSetting"."value" AS "GlobalSetting__value" FROM "public"."global_settings" AS "GlobalSetting" WHERE "name" = 'theme' LIMIT 1 | | 1 | 1 | 1 |
| 32 | SELECT "Content"."id" AS "Content__id", "Content"."title" AS "Content__title" FROM "public"."ss20_content" AS "Content" WHERE "menu_visible" = 'TRUE' ORDER BY "orderid" asc | | 5 | 5 | 0 |
| 33 | SELECT "ExternalAuth"."id" AS "ExternalAuth__id", "ExternalAuth"."menu_name" AS "ExternalAuth__menu_name", "ExternalAuth"."menu_url" AS "ExternalAuth__menu_url" FROM "public"."ss20_external_auth" AS "ExternalAuth" WHERE NOT ("ExternalAuth"."menu_name" IS NULL) AND NOT ("ExternalAuth"."menu_url" IS NULL) ORDER BY "id" asc | | 0 | 0 | 0 |
| 34 | SELECT "Permission"."id" AS "Permission__id", "Permission"."aro_id" AS "Permission__aro_id", "Permission"."aco_id" AS "Permission__aco_id", "Permission"."_create" AS "Permission___create", "Permission"."_read" AS "Permission___read", "Permission"."_update" AS "Permission___update", "Permission"."_delete" AS "Permission___delete", "Aco"."id" AS "Aco__id", "Aco"."parent_id" AS "Aco__parent_id", "Aco"."model" AS "Aco__model", "Aco"."foreign_key" AS "Aco__foreign_key", "Aco"."alias" AS "Aco__alias", "Aco"."lft" AS "Aco__lft", "Aco"."rght" AS "Aco__rght" FROM "public"."ss20_aros_acos" AS "Permission" LEFT JOIN "public"."ss20_acos" AS "Aco" ON ("Permission"."aco_id" = "Aco"."id") WHERE "Permission"."aro_id" = 1 AND "Permission"."aco_id" IN (291, 285) ORDER BY "Aco"."lft" desc | | 2 | 2 | 1 |
| 35 | SELECT "Permission"."id" AS "Permission__id", "Permission"."aro_id" AS "Permission__aro_id", "Permission"."aco_id" AS "Permission__aco_id", "Permission"."_create" AS "Permission___create", "Permission"."_read" AS "Permission___read", "Permission"."_update" AS "Permission___update", "Permission"."_delete" AS "Permission___delete", "Aco"."id" AS "Aco__id", "Aco"."parent_id" AS "Aco__parent_id", "Aco"."model" AS "Aco__model", "Aco"."foreign_key" AS "Aco__foreign_key", "Aco"."alias" AS "Aco__alias", "Aco"."lft" AS "Aco__lft", "Aco"."rght" AS "Aco__rght" FROM "public"."ss20_aros_acos" AS "Permission" LEFT JOIN "public"."ss20_acos" AS "Aco" ON ("Permission"."aco_id" = "Aco"."id") WHERE "Permission"."aro_id" = 1 AND "Permission"."aco_id" IN (292, 285) ORDER BY "Aco"."lft" desc | | 2 | 2 | 1 |
| 36 | SELECT "Permission"."id" AS "Permission__id", "Permission"."aro_id" AS "Permission__aro_id", "Permission"."aco_id" AS "Permission__aco_id", "Permission"."_create" AS "Permission___create", "Permission"."_read" AS "Permission___read", "Permission"."_update" AS "Permission___update", "Permission"."_delete" AS "Permission___delete", "Aco"."id" AS "Aco__id", "Aco"."parent_id" AS "Aco__parent_id", "Aco"."model" AS "Aco__model", "Aco"."foreign_key" AS "Aco__foreign_key", "Aco"."alias" AS "Aco__alias", "Aco"."lft" AS "Aco__lft", "Aco"."rght" AS "Aco__rght" FROM "public"."ss20_aros_acos" AS "Permission" LEFT JOIN "public"."ss20_acos" AS "Aco" ON ("Permission"."aco_id" = "Aco"."id") WHERE "Permission"."aro_id" = 1 AND "Permission"."aco_id" IN (332, 285) ORDER BY "Aco"."lft" desc | | 2 | 2 | 1 |
| 37 | SELECT "Permission"."id" AS "Permission__id", "Permission"."aro_id" AS "Permission__aro_id", "Permission"."aco_id" AS "Permission__aco_id", "Permission"."_create" AS "Permission___create", "Permission"."_read" AS "Permission___read", "Permission"."_update" AS "Permission___update", "Permission"."_delete" AS "Permission___delete", "Aco"."id" AS "Aco__id", "Aco"."parent_id" AS "Aco__parent_id", "Aco"."model" AS "Aco__model", "Aco"."foreign_key" AS "Aco__foreign_key", "Aco"."alias" AS "Aco__alias", "Aco"."lft" AS "Aco__lft", "Aco"."rght" AS "Aco__rght" FROM "public"."ss20_aros_acos" AS "Permission" LEFT JOIN "public"."ss20_acos" AS "Aco" ON ("Permission"."aco_id" = "Aco"."id") WHERE "Permission"."aro_id" = 1 AND "Permission"."aco_id" IN (333, 285) ORDER BY "Aco"."lft" desc | | 2 | 2 | 1 |
| 38 | SELECT "Tutor"."id" AS "Tutor__id", "Tutor"."user_id" AS "Tutor__user_id", "Tutor"."homepage" AS "Tutor__homepage", "Tutor"."issupervision" AS "Tutor__issupervision", "Tutor"."isassistant" AS "Tutor__isassistant", "Tutor"."iscontact" AS "Tutor__iscontact", "Tutor"."show_in_team" AS "Tutor__show_in_team", "Tutor"."show_email" AS "Tutor__show_email", "Tutor"."email_news" AS "Tutor__email_news", "Tutor"."email_feedback" AS "Tutor__email_feedback", "Tutor"."email_submission" AS "Tutor__email_submission", (select CONCAT('#', "Tutor"."id", ' - ', first, ' ', last) from global_users where "global_users"."id" = "Tutor"."user_id") AS "Tutor__display", "User"."id" AS "User__id", "User"."email" AS "User__email", "User"."username" AS "User__username", "User"."password" AS "User__password", "User"."first" AS "User__first", "User"."last" AS "User__last", "User"."created" AS "User__created", "User"."modified" AS "User__modified", "User"."password_rehashed" AS "User__password_rehashed", "User"."banned" AS "User__banned", "User"."twofa" AS "User__twofa", "User"."twofamethod" AS "User__twofamethod", "User"."nighttheme" AS "User__nighttheme", "User"."email_last_reset" AS "User__email_last_reset", "User"."webauthn_identity" AS "User__webauthn_identity", (SELECT group_id FROM ss20_usergroups WHERE id="User"."id") AS "User__group_id", (CONCAT(first,' ', last)) AS "User__display" FROM "public"."ss20_tutors" AS "Tutor" LEFT JOIN "public"."global_users" AS "User" ON ("Tutor"."user_id" = "User"."id") WHERE "isassistant" = 2 ORDER BY "User"."last" ASC, "User"."first" ASC | | 1 | 1 | 1 |
| 39 | SELECT "News"."id" AS "News__id", "News"."title" AS "News__title", "News"."content" AS "News__content", "News"."author" AS "News__author", "News"."archived" AS "News__archived", "News"."created" AS "News__created", "News"."modified" AS "News__modified", "User"."id" AS "User__id", "User"."email" AS "User__email", "User"."username" AS "User__username", "User"."password" AS "User__password", "User"."first" AS "User__first", "User"."last" AS "User__last", "User"."created" AS "User__created", "User"."modified" AS "User__modified", "User"."password_rehashed" AS "User__password_rehashed", "User"."banned" AS "User__banned", "User"."twofa" AS "User__twofa", "User"."twofamethod" AS "User__twofamethod", "User"."nighttheme" AS "User__nighttheme", "User"."email_last_reset" AS "User__email_last_reset", "User"."webauthn_identity" AS "User__webauthn_identity", (SELECT group_id FROM ss20_usergroups WHERE id="User"."id") AS "User__group_id", (CONCAT(first,' ', last)) AS "User__display" FROM "public"."ss20_news" AS "News" LEFT JOIN "public"."global_users" AS "User" ON ("News"."author" = "User"."id") WHERE "News"."archived" = 'FALSE' ORDER BY "News"."created" DESC, "News"."modified" DESC | | 5 | 5 | 2 |