USE elwiki_p;

SELECT total, total_ve, 100 * total_ve / total AS ve_pct, total_mob, 100 * total_mob / total AS mob_pct FROM (

SELECT COUNT(*) AS total, SUM(IF(VE.ct_rc_id IS NULL, 0, 1)) AS total_ve, SUM(IF(mob.ct_rc_id IS NULL, 0, 1)) AS total_mob

FROM recentchanges

LEFT JOIN change_tag AS VE ON VE.ct_rc_id = rc_id AND VE.ct_tag_id IN (SELECT ctd_id FROM change_tag_def WHERE ctd_name = 'visualeditor' AND NOT ctd_name = 'mw-undo' AND NOT ctd_name = 'mw-rollback' AND NOT ctd_name = 'contenttranslation')

LEFT JOIN change_tag AS mob ON mob.ct_rc_id = rc_id AND mob.ct_tag_id IN (SELECT ctd_id FROM change_tag_def WHERE ctd_name = 'mobile edit')

WHERE rc_source IN ('mw.edit', 'mw.new')

AND rc_namespace IN (0, 2, 12, 14)

AND rc_bot = 0) AS sub;