- 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 (event.id <= '16') AND (area.unit_id = 1) 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 (4, 3, 3, 3, 3, 3, 2, 2, 2, 1, 1, 1, 1, 1, 1, 1));
- SELECT "area".* FROM "area" WHERE ("area"."id" IN (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 (1, 1, 1, 4));
- SELECT "initiative".* FROM "initiative" WHERE ("initiative"."issue_id" IN (3, 1, 2, 4)) 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 (5, 4, 3, 2, 1, 1, 1));
- SELECT "suggestion".* FROM "suggestion" WHERE ("suggestion"."id" IN (1));
- SELECT "member".* FROM "member" WHERE ("member"."id" IN (1, 1, 11, 11, 7, 7, 1));
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 "argument".* FROM "argument" WHERE ("argument"."id" IN (1));
EXECUTE VIEW: delegation/_info
EXECUTE VIEW: initiative/_list
EXECUTE VIEW: delegation/_info
EXECUTE VIEW: initiative/_list
EXECUTE VIEW: delegation/_info
EXECUTE VIEW: initiative/_list