-- ## 10: All Tickets for libusb-compat-0.1 ## --

-- 
--  * Lists all libusb-compat-0.1 tickets by status
--  * Color each row based on ticket type
-- 
-- Last modification time, description and reporter are included as hidden fields for useful RSS export.


SELECT p.value AS __color__,
   id AS ticket, summary, t.type, 
   owner, status,
   time AS created,
   changetime AS _changetime, description AS _description,
   reporter AS _reporter
  FROM ticket t LEFT JOIN enum p ON p.name = t.type AND p.type = 'ticket_type'
  WHERE component='libusb-compat-0.1'
  ORDER BY status, CAST(p.value AS int), t.type, time