-- ## 19: Closed since 2.0.1 up to 3.1 ## --

-- - all tickets closed since 2.0.1 was released up to release 3.1

-- date -d '2011-05-02' +%s == 1304287200
SELECT p.value AS __color__,
   id AS ticket, summary, component, version, milestone, t.type AS type, 
   reporter AS reporter, owner, status,
   time AS created,
   changetime AS modified
   
  FROM ticket t
  LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
  where status='closed' and changetime > 1304287200 and changetime <= 1329346800
  ORDER BY changetime desc