Did translated articles grow?

This query is marked as a draft This query has been published by Huji.

SQL

use fawiki_p;
select ori.*, r2.rev_timestamp latest_revision, r2.rev_len latest_size
from
(
select rev_page, rev_timestamp as created_when, rev_len original_size
from revision
where rev_parent_id = 0
and rev_comment like '%ابزار/به_ویکی‌فا%'
limit 10
) 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
limit 10;

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.

SQL

Checking query status...