-- ## 20: Активные в группе 2 ## --

SELECT 
   id AS ticket, summary, owner, status, t.type AS type, component AS __group__, version, resolution, strftime("%Y-%m-%d %H:%M:%S", ROUND(changetime / 1e6), 'unixepoch', '3 hours') AS Modified, reporter
  FROM ticket t
  WHERE status <> 'closed' AND reporter IN (
'bubnov.danil',
'vavilov.mark',
'venediktov.roman',
'golovin.valeriy',
'zhemchuzhina.elizaveta',
'lebedev.egor',
'lochmelis.denis',
'luchinin.aleksey',
'mikhaylova.anna',
'nosivskoy.vladislav',
'obryadina.aleksandra',
'savrasov.mikhail',
'sunko.elena',
'tarabonda.german',
'ushakova.alina',
'fedorov.vladimir'
)
  ORDER BY __group__, t.changetime DESC