-- ## 46: Tickets needing review with no reviewer ## --

SELECT id AS ticket, status, p.value as __color__, t.owner, 
       t.time as created, t.summary, t.milestone as __group__ 
  FROM ticket t, enum p
  WHERE t.status = 'needs_review'  
        AND p.name=t.priority AND p.type='priority'
  ORDER BY __group__, __color__, t.time