Demo - Initiative i21 - Pirate Feedback - Pirate Feedback Bastelinstanz/noch nicht die erste Kammer der SME der Piraten NDS

Abgeschlossen (ohne Gewinner) · vor 5 Jahren 6 Monaten 13 Tagen

Initiative i21: Demo

Ja: 0 (0+0) · Enthaltung: 0 (0+0) · Nein: 0 (0+0) · Nicht angenommen (Rang 1)

Letzter Entwurf vom 07.07.2019 um 12:51 Uhr · Quelltext

Wir #PIRATEN stehen auf der Siegburger Straße Fahrtrichtung Deutz in Höhe der Haltestelle Linie 7 (!) Deutzer Freiheit #CSD #ColognePride #CSD2019 #HappyPride

erstens
zweitens

Überschrift

Keine Argumente

Keine Argumente

TRACE

Configuration "myconfig"
- Configuration "init"
REQUESTED VIEW: initiative/show
/main/_filter/20_session.lua
- INSERT INTO "session" ("additional_secret", "ident") VALUES ('9GTJWwNVVKeCQAi1BspbsxU4QOHtM9iR', 'Y6HDmz5L6nnWgAt1BMp53lTHexNFv5AY') RETURNING ("ident");
- /main/_filter/21_auth.lua
  - No authentication needed.
  - /main/_filter_view/30_navigation.lua
    - EXECUTE VIEW: index/_menu
    - /main/_filter_view/32_searchbox.lua
      - /main/_filter_view/33_help_hidden.lua
        /main/_filter_view/34_stylesheet.lua
        /main/_filter_view/36_html_title.lua
        /main/_filter_view/38_motd.lua
        EXECUTE VIEW: initiative/show
        SELECT "initiative".* FROM "initiative" WHERE (id = 21) LIMIT 1;
        EXECUTE VIEW: initiative/_show
        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 (17));
        EXECUTE VIEW: issue/_head
        SELECT "area".* FROM "area" WHERE ("area"."id" IN (1));
        EXECUTE VIEW: area/_head
        SELECT "unit".* FROM "unit" WHERE ("unit"."id" IN (1));
        EXECUTE VIEW: unit/_head
        EXECUTE VIEW: delegation/_info
        EXECUTE VIEW: delegation/_info
        SELECT "member".*, "initiator"."initiative_id" AS "mm_ref_", initiator.accepted AS "accepted" FROM "member" INNER JOIN "initiator" ON "initiator"."member_id" = "member"."id" WHERE ("initiator"."initiative_id" IN (21)) AND (initiator.accepted) ORDER BY member.name;
        EXECUTE VIEW: issue/_show
        EXECUTE VIEW: delegation/_info
        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 (6));
        EXECUTE VIEW: initiative/_list
        SELECT "initiative".* FROM "initiative" WHERE ("initiative"."issue_id" IN (17)) 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/_battles
        SELECT "initiative".*, winning_battle.count AS "winning_count", losing_battle.count AS "losing_count", winning_battle.direct_count AS "winning_direct_count", losing_battle.direct_count AS "losing_direct_count" FROM "initiative" INNER JOIN battle AS "winning_battle" ON winning_battle.winning_initiative_id = 21 AND winning_battle.losing_initiative_id = initiative.id INNER JOIN battle AS "losing_battle" ON losing_battle.losing_initiative_id = 21 AND losing_battle.winning_initiative_id = initiative.id ORDER BY rank;
        SELECT count(1) FROM (SELECT "initiative".* FROM "initiative" WHERE (issue_id = 17) AND (admitted)) AS "subquery" LIMIT 1;
        SELECT count(1) FROM (SELECT "draft".* FROM "draft" WHERE ("draft"."initiative_id" IN (21)) ORDER BY "id" DESC) AS "subquery" LIMIT 1;
        SELECT "draft".* FROM "draft" WHERE ("initiative_id" = 21) ORDER BY "id" DESC LIMIT 1;
        SELECT "draft".* FROM "draft" WHERE ("initiative_id" = 21) ORDER BY "id" DESC LIMIT 1;
        SELECT "draft".* FROM "draft" WHERE ("initiative_id" = 21) ORDER BY "id" DESC LIMIT 1;
        SELECT "draft".* FROM "draft" WHERE ("initiative_id" = 21) ORDER BY "id" DESC LIMIT 1;
        SELECT "rendered_draft".* FROM "rendered_draft" WHERE (draft_id = 23) AND (format = 'html') LIMIT 1;
        EXECUTE VIEW: suggestion/_list
        SELECT count(1) FROM (SELECT "suggestion".* FROM "suggestion" WHERE ("suggestion"."initiative_id" IN (21)) ORDER BY proportional_order NULLS LAST, plus2_unfulfilled_count + plus1_unfulfilled_count DESC, plus2_unfulfilled_count DESC, id) AS "subquery" LIMIT 1;
        SELECT "suggestion".* FROM "suggestion" WHERE ("suggestion"."initiative_id" IN (21)) ORDER BY proportional_order NULLS LAST, plus2_unfulfilled_count + plus1_unfulfilled_count DESC, plus2_unfulfilled_count DESC, id LIMIT 20 OFFSET 0;
        EXECUTE VIEW: argument/_list
        SELECT count(1) FROM (SELECT "argument".* FROM "argument" WHERE ("argument"."initiative_id" IN (21)) AND (side = 'pro') ORDER BY plus_count - minus_count DESC, id) AS "subquery" LIMIT 1;
        SELECT "argument".* FROM "argument" WHERE ("argument"."initiative_id" IN (21)) AND (side = 'pro') ORDER BY plus_count - minus_count DESC, id LIMIT 10 OFFSET 0;
        EXECUTE VIEW: argument/_list
        SELECT count(1) FROM (SELECT "argument".* FROM "argument" WHERE ("argument"."initiative_id" IN (21)) AND (side = 'contra') ORDER BY plus_count - minus_count DESC, id) AS "subquery" LIMIT 1;
        SELECT "argument".* FROM "argument" WHERE ("argument"."initiative_id" IN (21)) AND (side = 'contra') ORDER BY plus_count - minus_count DESC, id LIMIT 10 OFFSET 0;
  - End of authentication filter.
Finished after 141.1 ms (104.8 ms CPU)