INSERT INTO "session" ("additional_secret", "ident") VALUES ('gNTJffinWakW9YTa930DmTpxecnDJrFI', 'PRNQGx3h4YDkfnTuxVOYRUWOEFDnEZ86') RETURNING ("ident");
/main/_filter/21_auth.lua
No authentication needed.
/main/_filter_view/30_navigation.lua
EXECUTE VIEW: index/_menu
/main/_filter_view/32_searchbox.lua
/main/_filter_view/33_help_hidden.lua
/main/_filter_view/34_stylesheet.lua
/main/_filter_view/36_html_title.lua
/main/_filter_view/38_motd.lua
EXECUTE VIEW: unit/show
SELECT "unit".* FROM "unit" WHERE (id = 1) LIMIT 1;
EXECUTE VIEW: unit/_head
EXECUTE VIEW: delegation/_info
EXECUTE VIEW: index/_notifications
EXECUTE VIEW: area/_list
SELECT area.id, area.unit_id, area.name, area.delegation, direct_member_count, (SELECT COUNT(*) FROM issue WHERE issue.area_id = area.id AND issue.accepted ISNULL AND issue.closed ISNULL) AS "issues_new_count", (SELECT COUNT(*) FROM issue WHERE issue.area_id = area.id AND issue.accepted NOTNULL AND issue.half_frozen ISNULL AND issue.closed ISNULL) AS "issues_discussion_count", (SELECT COUNT(*) FROM issue WHERE issue.area_id = area.id AND issue.half_frozen NOTNULL AND issue.fully_frozen ISNULL AND issue.closed ISNULL) AS "issues_frozen_count", (SELECT COUNT(*) FROM issue WHERE issue.area_id = area.id AND issue.fully_frozen NOTNULL AND issue.closed ISNULL) AS "issues_voting_count", (SELECT COUNT(*) FROM issue WHERE issue.area_id = area.id AND issue.fully_frozen NOTNULL AND issue.closed NOTNULL) AS "issues_finished_count", (SELECT COUNT(*) FROM issue WHERE issue.area_id = area.id AND issue.fully_frozen ISNULL AND issue.closed NOTNULL) AS "issues_canceled_count" FROM "area" WHERE (area.active = TRUE) AND (area.unit_id = 1) GROUP BY area.id, area.unit_id, area.name, area.delegation, direct_member_count ORDER BY area.direct_member_count DESC, area.name;