Entwurf vom 31.01.2022 um 23:21 Uhr - Initiative i27 - Pirate Feedback - Pirate Feedback Bastelinstanz/noch nicht die erste Kammer der SME der Piraten NDS

SELECT "initiative".* FROM "initiative" WHERE ("initiative"."id" IN (27));

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 (22));

SELECT "area".* FROM "area" WHERE ("area"."id" IN (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));