SQL
x
use fiwiki_p;
select
count(distinct(user_name)) as users ,
count(distinct(log_title)) as pages,
sum(page_title IS NULL) as deleted,
count(distinct(ctd_id)) as content_translated_apges,
sum(ctd_id IS NULL) as deleted
from (
select
substring(user_name,1,30) as user_name,
user_editcount,
substring(log_title,1,30) as log_title,
p1.page_id,
ctd_id
from
user,
logging_compat as l1
LEFT JOIN page as p1 ON l1.log_page=p1.page_id AND p1.page_namespace=0
LEFT JOIN change_tag ON ct_log_id=log_id
LEFT JOIN change_tag_def ON ct_tag_id=ctd_id AND ctd_name = "contenttranslation"
where
user_registration > 20200014210707
and user_id=l1.log_user
and l1.log_type="create"
and l1.log_namespace=0 and log_id>11602240
)
as t
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.