-- ## 19: Активные в группе 1 ## --

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 (
'abramov.nikita',
'bagryanova.ekaterina',
'brilliantov.kirill',
'karnaukhov.kirill',
'marin.gleb',
'morozov.aleksandr',
'onofriychuk.ilya',
'salkaev.ruslan',
'samoylov.viktor',
'solovyov.gleb',
'surkov.petr',
'sukhodolskiy.maksim',
'tarasov.denis',
'filippov.denis',
'khudyakov.yuriy',
'engel.igor'
)
  ORDER BY __group__, t.changetime DESC