Replicas browser and optimizer
This query is marked as a draft
This query has been published
use cawiki_p; set @month = '201602'; set @wiki = 'cawiki'; set @ct_tag_id = ( select ctd_id from change_tag_def where ctd_name = 'contenttranslation' ); set @created_total = ( select count(rev_id) from page, revision where page_id = rev_page and page_namespace = 0 and rev_timestamp like concat(@month, '%') and rev_parent_id = 0 ); set @created_cx = ( select count(rev_id) from change_tag, page, revision where page_id = rev_page and page_namespace = 0 and rev_id = ct_rev_id and rev_timestamp like concat(@month, '%') and rev_parent_id = 0 and ct_tag_id = @ct_tag_id ); set @created_non_cx = ( select (@created_total - @created_cx) ); select @month as "month", @wiki as "wiki", @created_cx as "created with CX", @created_non_cx as "created not with CX", concat('%', (@created_cx / ( @created_cx + @created_non_cx ) * 100)) as "% created with CX";
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in