-- ## 9: Promot Tickets ## --

SELECT id AS ticket, status, severity, priority, owner, 
       time as created, summary FROM ticket 
  WHERE component IN ('Promot', 'PromotKernel', 'PromotGuiBase')
  ORDER BY priority, time