-- ## 5: Unassigned and unaccepted tickets ## --

-- List tickets not yet assigned/accepted
-- 
-- First, all the tickets which don't have an owner yet ("somebody")
-- 
-- Then, all tickets assigned but not accepted yet by owner 
-- 
-- '''(Please don't forget to accept your tickets. Assignment is only the first step.)'''


SELECT p.value AS __color__,
   owner AS __group__,
   id AS ticket, summary, component, milestone, t.type AS type, time AS created,
   description AS _description, owner AS owner,
   changetime AS _changetime, reporter AS reporter
  FROM ticket t
  LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
  WHERE status <> 'accepted' AND status <> 'closed' 
  ORDER BY  (owner<>'somebody'),owner, (owner='somebody'),CAST(p.value AS int), t.type, time