-- ## 12: Complete Report ## -- -- This report shows all tickets ever created of the new Orxonox version. SELECT p.value AS __color__, id AS ticket, summary, component, version, priority, t.type AS type, status, owner, status, time AS created, changetime AS _changetime, description AS _description, reporter AS _reporter FROM ticket t, enum p WHERE p.name = t.priority AND p.type = 'priority' AND id > 219 ORDER BY ticket, priority, time