USE dewiki_p;

SELECT rev_user as stb_user, 

 COUNT(rev_id) AS stb_all_edits

FROM revision_userindex INNER JOIN page on rev_page=page_id

 WHERE rev_user IN (SELECT user_id FROM user WHERE user_name in ('Wadis', '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