Stimmberechtigungstest

SQL

USE dewiki_p;
SELECT user_name, stb_first_edit, stb_all_edits, stb_recent_edits FROM
(SELECT rev_user as stb_user, 
 MIN(rev_timestamp) AS stb_first_edit, 
 COUNT(rev_id) AS stb_all_edits, 
 SUM(IF(rev_timestamp>'20180529000000',1,0)) as stb_recent_edits
FROM revision_userindex INNER JOIN page on rev_page=page_id
 WHERE rev_timestamp>'20180529000000'  AND rev_user IN (SELECT user_id FROM user WHERE user_name in ('A.Savin', 'Aalfons', 'Achim', 'AchimP', 'AFBorchert', 'Agathenon', 'Albinfo', 'Alinea', 'All', 'Alpöhi', 'Alraunenstern', 'Altkatholik62', 'Amberg', 'Ambross07', 'Amga', 'An-d', 'Andreas', 'Andropov', 'Anidaat', 'Anti.', 'Appelboim', 'Arabsalam', 'Armin', 'Artmax', 'Artregor', 'Aschmidt', 'Atomiccocktail'))
AND page_namespace=0
GROUP BY rev_user) AS tab
INNER JOIN user ON stb_user=user_id
SQL

Checking query status...
