-- ## 7: Closed tickets, changed/created in the last 10 days ## -- -- Closed tickets, changed/created in the last 10 days SELECT p.value AS __color__, id AS ticket, summary, component, version, t.type AS type, owner, time AS created, changetime AS _changetime, t.description AS _description, reporter AS _reporter, resolution FROM ticket t, enum p WHERE status = 'closed' AND extract(epoch from now())-changetime/1000000 < 10*86400 AND p.name = t.priority AND p.type = 'priority' ORDER BY changetime desc