» Δήμος Αθηναίων » Τροφή » Αμεση Απόφαση #8

i15: Να προμηθεύει λάδι το foodback

by Diego Melendez

Να δίνουμε ελαιόλαδο κάθε χρόνο

draft history (1)

Suggestions for improvement (0)

written and rated by the supporters of this initiative to improve the proposal and its reasons

Αμεση Απόφαση #8

1. Admission (failed 3)

Failed 1st quorum

Competing initiatives

This is the only initiative in this issue, because nobody started a competing initiative.

What can I do here?

This issue is closed

Interested members

Diego Melendez

TRACE

System trace (for computer programmers purposes)

this: u=1.7, d=0.0, t=1.7 | children: u=0.0, d=0.0, t=0.0 | total: u=1.7, d=0.0, t=1.7 ms
Configuration "devel"
REQUESTED VIEW: initiative/show
this: u=4.0, d=4.1, t=7.8 | children: u=17.4, d=14.0, t=29.6 | total: u=21.5, d=18.1, t=37.5 ms
/main/_filter/20_session.lua
- INSERT INTO "session" ("additional_secret", "ident") VALUES ('rfP5JwtCjxkLezbHpGdSYFKpk8vM6VhvoZeISOZPp1xMk8EC', 'KEZxdbjl42YEFUDpKyL1pJAk') RETURNING "ident"; 4.1 ms
- this: u=0.7, d=0.0, t=0.7 | children: u=16.8, d=14.0, t=28.9 | total: u=17.4, d=14.0, t=29.6 ms
  /main/_filter/21_auth.lua
  - No authentication needed.
  - this: u=1.0, d=0.0, t=1.0 | children: u=15.7, d=14.0, t=27.9 | total: u=16.8, d=14.0, t=28.9 ms
    /main/_filter_view/30_navigation.lua
    - this: u=0.2, d=0.0, t=0.2 | children: u=15.6, d=14.0, t=27.7 | total: u=15.7, d=14.0, t=27.9 ms
      /main/_filter_view/34_stylesheet.lua
      - this: u=0.3, d=0.0, t=0.3 | children: u=15.2, d=14.0, t=27.4 | total: u=15.6, d=14.0, t=27.7 ms
        /main/_filter_view/36_html_title.lua
        this: u=4.2, d=4.9, t=8.5 | children: u=11.1, d=9.1, t=18.9 | total: u=15.2, d=14.0, t=27.4 ms
        EXECUTE VIEW: initiative/show
        SELECT "initiative".* FROM "initiative" WHERE (id = 15) LIMIT 1; 2.0 ms
        SELECT "issue".*, justify_interval(min_admission_time)::text AS "min_admission_time_text", justify_interval(max_admission_time)::text AS "max_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.max_admission_time) - now()) AS "state_time_left", justify_interval(now() - issue.closed) AS "closed_ago" FROM "issue" WHERE ("issue"."id" IN (8)); 1.4 ms
        this: u=4.0, d=2.0, t=5.8 | children: u=0.0, d=0.0, t=0.0 | total: u=4.0, d=2.0, t=5.8 ms
        EXECUTE VIEW: issue/_head
        SELECT "policy".*, justify_interval(min_admission_time)::text AS "min_admission_time_text", justify_interval(max_admission_time)::text AS "max_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 (16)); 0.8 ms
        SELECT "area".* FROM "area" WHERE ("area"."id" IN (4)); 0.6 ms
        SELECT "unit".* FROM "unit" WHERE ("unit"."id" IN (11)); 0.6 ms
        this: u=0.9, d=1.8, t=2.5 | children: u=0.5, d=0.0, t=0.5 | total: u=1.4, d=1.8, t=3.0 ms
        EXECUTE VIEW: initiative/_head
        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 (15)) AND (initiator.accepted) ORDER BY member.name; 1.8 ms
        this: u=0.3, d=0.0, t=0.3 | children: u=0.0, d=0.0, t=0.0 | total: u=0.3, d=0.0, t=0.3 ms
        EXECUTE VIEW: initiative/_bargraph
        this: u=0.2, d=0.0, t=0.2 | children: u=0.0, d=0.0, t=0.0 | total: u=0.2, d=0.0, t=0.2 ms
        EXECUTE VIEW: initiative/_sidebar_state
        SELECT "draft".* FROM "draft" WHERE ("initiative_id" = 15) ORDER BY "id" DESC LIMIT 1; 0.7 ms
        SELECT "draft".* FROM "draft" WHERE ("initiative_id" = 15) ORDER BY "id" DESC LIMIT 1; 0.2 ms
        SELECT "draft".* FROM "draft" WHERE ("initiative_id" = 15) ORDER BY "id" DESC LIMIT 1; 0.2 ms
        SELECT count(1) FROM (SELECT "draft".* FROM "draft" WHERE ("draft"."initiative_id" IN (15)) ORDER BY "id" DESC) AS "subquery" LIMIT 1; 0.3 ms
        this: u=0.8, d=0.7, t=1.4 | children: u=0.0, d=0.0, t=0.0 | total: u=0.8, d=0.7, t=1.4 ms
        EXECUTE VIEW: initiative/_suggestions
        SELECT "suggestion".* FROM "suggestion" WHERE ("suggestion"."initiative_id" IN (15)) ORDER BY "proportional_order" NULLS LAST, id; 0.7 ms
        this: u=0.3, d=0.0, t=0.3 | children: u=0.8, d=0.6, t=1.3 | total: u=1.1, d=0.6, t=1.6 ms
        EXECUTE VIEW: issue/_sidebar
        this: u=0.4, d=0.0, t=0.4 | children: u=0.0, d=0.0, t=0.0 | total: u=0.4, d=0.0, t=0.4 ms
        EXECUTE VIEW: issue/_sidebar_state
        this: u=0.4, d=0.6, t=0.9 | children: u=0.0, d=0.0, t=0.0 | total: u=0.4, d=0.6, t=0.9 ms
        EXECUTE VIEW: issue/_sidebar_issue
        SELECT "initiative".* FROM "initiative" WHERE ("initiative"."issue_id" IN (8)) ORDER BY initiative.admitted DESC NULLS LAST, initiative.rank NULLS LAST, initiative.harmonic_weight DESC NULLS LAST, id; 0.6 ms
        this: u=1.8, d=0.8, t=2.3 | children: u=0.0, d=0.0, t=0.0 | total: u=1.8, d=0.8, t=2.3 ms
        EXECUTE VIEW: issue/_sidebar_whatcanido
        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 (15)) AND (initiator.accepted) ORDER BY member.name; 0.8 ms
        this: u=0.2, d=0.0, t=0.2 | children: u=1.5, d=3.2, t=4.6 | total: u=1.8, d=3.2, t=4.8 ms
        EXECUTE VIEW: issue/_sidebar_members
        this: u=1.0, d=3.2, t=4.1 | children: u=0.5, d=0.0, t=0.5 | total: u=1.5, d=3.2, t=4.6 ms
        EXECUTE VIEW: member/_list
        SELECT count(1) FROM (SELECT "member".*, direct_interest_snapshot."issue_id" AS "mm_ref_", direct_interest_snapshot.ownweight, direct_interest_snapshot.weight, direct_supporter_snapshot.member_id NOTNULL AS "supporter", satisfied AS "supporter_satisfied", member.id = ANY(_member_list__delegating_interest.delegate_member_ids) AS "in_delegation_chain" FROM "member" INNER JOIN direct_interest_snapshot ON direct_interest_snapshot."member_id" = "member"."id" INNER JOIN issue ON issue.id = direct_interest_snapshot.issue_id LEFT OUTER JOIN direct_supporter_snapshot ON direct_supporter_snapshot.initiative_id = 15 AND direct_interest_snapshot.issue_id = direct_supporter_snapshot.issue_id AND direct_supporter_snapshot.member_id = direct_interest_snapshot.member_id AND direct_supporter_snapshot.snapshot_id = issue.latest_snapshot_id LEFT OUTER JOIN delegating_interest_snapshot AS "_member_list__delegating_interest" ON _member_list__delegating_interest.snapshot_id = issue.latest_snapshot_id AND _member_list__delegating_interest.issue_id = issue.id AND _member_list__delegating_interest.member_id = NULL WHERE (direct_interest_snapshot."issue_id" IN (8)) AND (direct_interest_snapshot.snapshot_id = issue.latest_snapshot_id) AND (member.activated NOTNULL)) AS "subquery" LIMIT 1; 1.8 ms
        SELECT "member".*, direct_interest_snapshot."issue_id" AS "mm_ref_", direct_interest_snapshot.ownweight, direct_interest_snapshot.weight, direct_supporter_snapshot.member_id NOTNULL AS "supporter", satisfied AS "supporter_satisfied", member.id = ANY(_member_list__delegating_interest.delegate_member_ids) AS "in_delegation_chain" FROM "member" INNER JOIN direct_interest_snapshot ON direct_interest_snapshot."member_id" = "member"."id" INNER JOIN issue ON issue.id = direct_interest_snapshot.issue_id LEFT OUTER JOIN direct_supporter_snapshot ON direct_supporter_snapshot.initiative_id = 15 AND direct_interest_snapshot.issue_id = direct_supporter_snapshot.issue_id AND direct_supporter_snapshot.member_id = direct_interest_snapshot.member_id AND direct_supporter_snapshot.snapshot_id = issue.latest_snapshot_id LEFT OUTER JOIN delegating_interest_snapshot AS "_member_list__delegating_interest" ON _member_list__delegating_interest.snapshot_id = issue.latest_snapshot_id AND _member_list__delegating_interest.issue_id = issue.id AND _member_list__delegating_interest.member_id = NULL WHERE (direct_interest_snapshot."issue_id" IN (8)) AND (direct_interest_snapshot.snapshot_id = issue.latest_snapshot_id) AND (member.activated NOTNULL) LIMIT 100 OFFSET 0; 1.5 ms
        this: u=0.3, d=0.0, t=0.3 | children: u=0.2, d=0.0, t=0.2 | total: u=0.5, d=0.0, t=0.5 ms
        EXECUTE VIEW: member/_show_thumb
        this: u=0.2, d=0.0, t=0.2 | children: u=0.0, d=0.0, t=0.0 | total: u=0.2, d=0.0, t=0.2 ms
        EXECUTE VIEW: member_image/_show
  - End of authentication filter.