Untitled query #23531

SQL

use fawiki_p;
select 'fa', r1.rev_id, r1.rev_page, r1.rev_user
	, convert(r1.rev_user_text using utf8)
	, convert(page_title using utf8)
	, convert(r1.rev_timestamp using latin1)
	, r1.rev_parent_id
	, ifnull(r2.rev_len, 0) old_len
	, r1.rev_len new_len
	, abs(ifnull(r2.rev_len, 0) - ifnull(r1.rev_len, 0)) diff
	, (case when r2.rev_len is null then 'Y' end) is_new
	, page_namespace
from fawiki_p.revision r1 
left join fawiki_p.revision r2
	on r1.rev_parent_id = r2.rev_id
	and r1.rev_page = r2.rev_page
, fawiki_p.page
where r1.rev_timestamp between '20171015000000' and '20171116000000'
and r1.rev_page = page_id
and page_namespace = 0
and r1.rev_user in( 
	select user_id from fawiki_p.user where user_name in (
		'AMIRMOHAMMADNASIRIPOUR','Aammiinn11','Abtinb','Ahura21','Argf2000'
		, 'Khanzadeh', 'Khorooshan', 'MasoodHA', 'S.bakhshaei', 'Wikikazemi'
		, 'Elajan', 'محک')
	)
SQL

Checking query status...
