Untitled query #3638

SQL

USE cswiki_p;
SELECT COUNT(*), COUNT(DISTINCT rc_actor), SUM(IF(user_name IS NULL OR user_editcount < 10, 1, 0)) AS newbies
FROM recentchanges
JOIN actor ON actor_id = rc_actor
LEFT JOIN `user` ON user_id = actor_user
WHERE rc_source IN ('mw.edit', 'mw.new');

SELECT ctd_name, COUNT(*), SUM(IF(user_name IS NULL OR user_editcount < 10, 1, 0)) AS newbies
FROM recentchanges
JOIN actor ON actor_id = rc_actor
LEFT JOIN `user` ON user_id = actor_user
JOIN change_tag ON ct_rc_id = rc_id
JOIN change_tag_def ON ct_tag_id = ctd_id
WHERE ctd_name IN ('visualeditor', 'mobile edit')
AND rc_source IN ('mw.edit', 'mw.new')
GROUP BY ctd_name;
SQL

Checking query status...
