Replicas browser and optimizer
Did translated articles grow?
This query is marked as a draft
This query has been published
use urwiki_p; select ori.*, concat(left(r1.rev_timestamp, 4), '-', mid(r1.rev_timestamp, 5, 2), '-', mid(r1.rev_timestamp, 7, 2)) as latest_revision, r1.rev_len latest_size, DATEDIFF(str_to_date(r1.rev_timestamp, '%Y%m%d'), str_to_date(created_when, '%Y%m%d')) growth_period, ROUND(100 * (r1.rev_len / original_size - 1)) growth_percentage, 30 * ROUND(100 * (r1.rev_len / original_size - 1)) / DATEDIFF(str_to_date(r1.rev_timestamp, '%Y%m%d'), str_to_date(created_when, '%Y%m%d')) growth_rate from ( select page_title, page_namespace, rev_page, rev_timestamp as created_when, rev_len original_size from revision join page on rev_page = page_id where rev_parent_id = 0 limit 50 ) ori join revision r1 on ori.rev_page = r1.rev_page left join revision r2 on r1.rev_page = r2.rev_page and r2.rev_timestamp > r1.rev_timestamp where r2.rev_timestamp is null
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