Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Matěj Suchánek
.
Toggle Highlighting
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); */
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...