- 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 <= '98') AND (area.unit_id = 1) AND (event.state IN ('finished_with_winner', 'finished_without_winner')) 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 (16, 15, 14, 13, 12, 11, 10, 9, 8, 7, 5, 4, 6, 3, 1));
- 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 (1, 1, 4, 4, 1, 4, 4, 4, 1, 1, 6, 1, 1, 4, 1));
- SELECT "initiative".* FROM "initiative" WHERE ("initiative"."issue_id" IN (3, 1, 9, 10, 8, 4, 5, 7, 6, 11, 12, 14, 13, 16, 15)) ORDER BY initiative.admitted DESC NULLS LAST, initiative.rank NULLS LAST, initiative.harmonic_weight DESC NULLS LAST, id;
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
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