-- ## 20: Closed since 3.1 up to 3.2 ## --

-- - all tickets with state closed which has being modified since 3.1 was released up to release 3.2 (not yet released)

-- 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 > 1329346800
  ORDER BY changetime desc