(Fair) VisualEditor statistics

SQL

USE ruwiki_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')
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;
SQL

Checking query status...
