HTTP/1.1 -1 Read error in cache disk data: SuccessContent-Type: text/plain; charset="utf-8" Last-Modified: Sat, 22 Jan 2022 00:59:16 GMT Content-length: 1151 Connection: Close Proxy-Connection: Close X-Cache: HIT from web1.osuosl.org Server: ProxyTrack 0.5 (HTTrack 3.49.2) -- ## 19: Newbie Tickets ## -- -- This report lists tickets that have been marked as useful tasks for volunteers who are new either to the Parrot project in general, or to a particular Parrot sub-system. -- -- It shows any non-closed tickets that have "newbie" in the Keyword field. -- -- The tickets are color-coded by Type, and ordered by Type and Id. SELECT Id AS ticket, Summary, Component, Priority, Version, Milestone, Type, ( -- This is the ordered type, taken from the lookup table. -- i.e. bug, cage, todo, patch, RFC, feature, spam, roadmap SELECT value FROM enum WHERE enum.type = 'ticket_type' AND enum.name = ticket.type ) AS __color__, Owner, Status, Time AS created, Changetime AS _changetime, Description AS _description, Reporter AS _reporter FROM ticket WHERE status <> 'closed' AND Keywords ILIKE '%newbie%' ORDER BY __color__, Id DESC ari convinces him to agr