-- ## 13: Active Tickets by ID (Full Description) ## --

-- List all active tickets by ID (Full description).

SELECT id AS ticket, summary, owner, priority, t.type AS type, severity, 
   time AS created, changetime AS modified, component,
   description AS _description_   
  FROM ticket t  
  WHERE not status = 'closed'
  ORDER BY id