-- ## 21: Активные в группе 3 ## --

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 (
'anisimova.karina',
'vorobeva.polina',
'itsenko.ekaterina',
'kirillova.evgeniya',
'kozubaev.nurmukhammad',
'krasov.vladislav',
'lopatin.mikhail',
'potryasaeva.anna',
'smirnov.ilya',
'subbotina.olesya',
'turov.kirill',
'chaykova.anastasiya',
'chizhova.mariya',
'chistyakova.polina',
'shein.andrey',
'shirokov.kirill'
)
  ORDER BY __group__, t.changetime DESC