(Fair) VisualEditor statistics

SQL

USE cswiki_p;
SELECT total, total_ve, 100 * total_ve / total, total_mob, 100 * total_mob / total 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')
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, 4, 12, 14)
AND rc_bot = 0);
/*
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 revision
LEFT JOIN change_tag AS VE ON VE.ct_rev_id = rev_id AND VE.ct_tag_id IN (SELECT ctd_id FROM change_tag_def WHERE ctd_name = 'visualeditor')
LEFT JOIN change_tag AS mob ON mob.ct_rev_id = rev_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, 4, 12, 14);
*/
SQL

Checking query status...
