- SELECT "event".*, now()::date - event.occurrence::date AS "time_ago" FROM "event" INNER JOIN issue ON issue.id = event.issue_id INNER JOIN area ON area.id = issue.area_id WHERE (area.unit_id = 1) AND (event.state = 'discussion') 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 (21, 21, 21, 19, 18, 18, 17, 17, 16, 16, 15, 15, 15, 14, 14, 13, 13, 13, 12, 11, 10, 9, 8, 8, 7, 6));
- SELECT "area".* FROM "area" WHERE ("area"."id" IN (1, 1, 1, 1, 1, 1, 1, 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, 1, 1, 6, 6, 1, 1, 4, 1, 6, 6, 1));
- SELECT "initiative".* FROM "initiative" WHERE ("initiative"."issue_id" IN (9, 10, 8, 7, 6, 11, 12, 18, 14, 13, 16, 15, 17, 19, 21)) 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 (26, 25, 22, 21, 20, 18, 18, 17, 16, 15, 9));
- SELECT "suggestion".* FROM "suggestion" WHERE ("suggestion"."id" IN (5, 4, 3, 2));
- SELECT "member".* FROM "member" WHERE ("member"."id" IN (55, 54, 18, 18, 18, 42, 42, 18, 18, 18, 18));
EXECUTE VIEW: delegation/_info
EXECUTE VIEW: initiative/_list
EXECUTE VIEW: delegation/_info
EXECUTE VIEW: initiative/_list
- SELECT "argument".* FROM "argument" WHERE ("argument"."id" IN (3));
EXECUTE VIEW: delegation/_info
EXECUTE VIEW: initiative/_list
EXECUTE VIEW: delegation/_info
EXECUTE VIEW: initiative/_list
EXECUTE VIEW: delegation/_info
EXECUTE VIEW: initiative/_list
- SELECT "argument".* FROM "argument" WHERE ("argument"."id" IN (2));
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
- SELECT "initiative".* FROM "initiative" WHERE (initiative.issue_id = 13) ORDER BY initiative.admitted DESC NULLS LAST, initiative.rank NULLS LAST, initiative.harmonic_weight DESC NULLS LAST, id;
EXECUTE VIEW: initiative/_list_element
EXECUTE VIEW: initiative/_list_element
EXECUTE VIEW: initiative/_list_element
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