-- ## 23: Активные в группе 4 ## --

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 (
'berbat.georgiy',
'vorobeva.aleksandra',
'gabitov.daniil',
'gordeeva.tatyana',
'korolev.dmitriy',
'kreslavskiy.kirill',
'kurnosova.polina',
'podoprigora.ivan',
'sabirova.milyausha',
'stotskiy.nikita',
'usoltsev.nikita',
'fomenko.ivan',
'shelukhina.ekaterina',
'egipti.pavel',
'yakovlev.aleksandr'
)
  ORDER BY __group__, t.changetime DESC