most recent edit for given cohort (SePW začátečníci jaro 2019)

SQL

SELECT
	actor_name,
    DATE(MAX(rev_timestamp)) AS last_edit_date
FROM revision_userindex
JOIN actor_revision ON actor_id=rev_actor
WHERE
	actor_name IN (
'Hana Jarošová',
'Jarečka123',
'Veny98',
'Bílá Orchidej',
'Tatanar',
'Gramatina',
'Mirka Tichá',
'Krejciz',
'Titik 71',
'Daniella Opa',
'Nick Name Babi',
'AMIGO 2017',
'Líba-Telč',
'Bublina42',
'Akšudýlek',
'BohacekJiri',
'ZdenkaMattusova',
'Qwidovitek',
'Premek1946',
'12senior',
'Flajbr',
'Zanetaplzen',
'Sumavanka1',
'Pan Kasalda',
'Inkkarel',
'Boba59',
'Rousseau25',
'František Řezáč',
'Bubajda10',
'Jirka161',
'Jiwa44',
'Pangafon'
    )
GROUP BY actor_name

SQL

Checking query status...