-- ## 11: LHC(Atlas/LHCb) feature requests => done ## --

--  * CMT feature requests for Atlas/LHCb experiments already implemented and to validate (as a v1r20 beta release ?)

SELECT p.value AS __color__,
   id AS ticket, summary, component, version, milestone, t.type AS type, severity, 
   owner, status,
   time AS created,
   changetime AS _changetime, description AS _description,
   reporter AS _reporter
  FROM ticket t, enum p
  LEFT OUTER JOIN ticket_custom c ON (t.id = c.ticket AND c.name = 'test_two')
  WHERE status IN ('fixed', 'closed') 
  AND p.name = t.priority AND p.type = 'priority'
  AND t.type = 'Feature request'AND (c.value = 'Atlas' OR c.value = 'LHCb')
  ORDER BY p.value, milestone, severity, time