-- ## 6: All Tickets by Milestone ## --

  SELECT p.value AS __color__, t.milestone AS __group__,
    (CASE status WHEN 'closed' 
      THEN 'color: #777; background: #ddd; border-color: #ccc;'
      ELSE (CASE owner WHEN $USER THEN 'font-weight: bold' END)
      END) AS __style__,
    id AS ticket, summary, component, t.type AS type, 
    reporter, owner AS _owner,
    time AS _created, changetime AS _modified, 
    description AS _description 
  FROM ticket t LEFT JOIN enum p 
  ON p.name = t.priority AND p.type = 'priority', (
   SELECT milestone, Max(time) AS max_time
   FROM ticket
   GROUP BY milestone
  ) u
  WHERE t.milestone = u.milestone
    AND (t.resolution <> 'invalid' OR t.resolution IS NULL)
  ORDER BY u.max_time DESC, id DESC