Did translated articles grow?

SQL

use fawiki_p;
select ori.*, r1.rev_timestamp 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
from
(
select 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
and rev_comment like '%ابزار/به_ویکی‌فا%'
order by page_random
limit 1000
) 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
SQL

Checking query status...
