- SELECT "event".*, now()::date - event.occurrence::date AS "time_ago" FROM "event" INNER JOIN issue ON issue.id = event.issue_id WHERE (event.id <= '66') AND (event.state in ('admission', 'discussion', 'verification', 'voting')) ORDER BY event.id DESC LIMIT 26;
- SELECT "issue".*, justify_interval(admission_time)::text AS "admission_time_text", justify_interval(discussion_time)::text AS "discussion_time_text", justify_interval(verification_time)::text AS "verification_time_text", justify_interval(voting_time)::text AS "voting_time_text", justify_interval(coalesce(issue.fully_frozen + issue.voting_time, issue.half_frozen + issue.verification_time, issue.accepted + issue.discussion_time, issue.created + issue.admission_time) - now()) AS "state_time_left", justify_interval(now() - issue.closed) AS "closed_ago" FROM "issue" WHERE ("issue"."id" IN (11, 11, 11, 11, 11, 10, 9, 10, 9, 10, 10, 9, 9, 8, 8, 8, 8, 8, 4, 7, 5, 7, 5, 4, 6, 6));
- SELECT "area".* FROM "area" WHERE ("area"."id" IN (1, 1, 1, 1, 1, 1, 1, 1));
- SELECT "unit".* FROM "unit" WHERE ("unit"."id" IN (1));
- SELECT "policy".*, justify_interval(admission_time)::text AS "admission_time_text", justify_interval(discussion_time)::text AS "discussion_time_text", justify_interval(verification_time)::text AS "verification_time_text", justify_interval(voting_time)::text AS "voting_time_text" FROM "policy" WHERE ("policy"."id" IN (4, 4, 1, 4, 4, 4, 1, 1));
- SELECT "initiative".* FROM "initiative" WHERE ("initiative"."issue_id" IN (9, 10, 8, 4, 5, 7, 6, 11)) ORDER BY initiative.admitted DESC NULLS LAST, initiative.rank NULLS LAST, initiative.harmonic_weight DESC NULLS LAST, id;
- SELECT "initiative".* FROM "initiative" WHERE ("initiative"."id" IN (12, 12, 11, 10, 9, 9));
- SELECT "suggestion".* FROM "suggestion" WHERE ("suggestion"."id" IN (2));
- SELECT "member".* FROM "member" WHERE ("member"."id" IN (28, 28, 18, 18, 18, 20));
EXECUTE VIEW: delegation/_info
EXECUTE VIEW: initiative/_list
EXECUTE VIEW: delegation/_info
EXECUTE VIEW: initiative/_list
EXECUTE VIEW: delegation/_info
EXECUTE VIEW: initiative/_list
EXECUTE VIEW: delegation/_info
EXECUTE VIEW: initiative/_list
EXECUTE VIEW: delegation/_info
EXECUTE VIEW: initiative/_list
EXECUTE VIEW: delegation/_info
EXECUTE VIEW: initiative/_list
EXECUTE VIEW: delegation/_info
EXECUTE VIEW: initiative/_list
EXECUTE VIEW: delegation/_info
EXECUTE VIEW: initiative/_list
EXECUTE VIEW: delegation/_info
EXECUTE VIEW: initiative/_list
EXECUTE VIEW: delegation/_info
EXECUTE VIEW: initiative/_list
EXECUTE VIEW: delegation/_info
EXECUTE VIEW: initiative/_list
EXECUTE VIEW: delegation/_info
EXECUTE VIEW: initiative/_list
EXECUTE VIEW: delegation/_info
EXECUTE VIEW: initiative/_list
EXECUTE VIEW: delegation/_info
EXECUTE VIEW: initiative/_list
EXECUTE VIEW: delegation/_info
EXECUTE VIEW: initiative/_list
EXECUTE VIEW: delegation/_info
EXECUTE VIEW: initiative/_list
EXECUTE VIEW: delegation/_info
EXECUTE VIEW: initiative/_list
EXECUTE VIEW: delegation/_info
EXECUTE VIEW: initiative/_list
EXECUTE VIEW: delegation/_info
EXECUTE VIEW: initiative/_list
EXECUTE VIEW: delegation/_info
EXECUTE VIEW: initiative/_list
EXECUTE VIEW: delegation/_info
EXECUTE VIEW: initiative/_list
EXECUTE VIEW: delegation/_info
EXECUTE VIEW: initiative/_list
EXECUTE VIEW: delegation/_info
EXECUTE VIEW: initiative/_list
EXECUTE VIEW: delegation/_info
EXECUTE VIEW: initiative/_list
EXECUTE VIEW: delegation/_info
EXECUTE VIEW: initiative/_list
Abstimmung begonnen
Phase Eingefroren gestartet
Diskussion gestartet