Untitled query #23531

SQL

use arwiki_p;
select 'ar', 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 arwiki_p.revision r1 
left join arwiki_p.revision r2
	on r1.rev_parent_id = r2.rev_id
	and r1.rev_page = r2.rev_page
, arwiki_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 arwiki_p.user where user_name in (
	'A3bdula3ziz', 'Abdou7878', 'Abdullah Arfa', 'Afek91', 'Azniv Stepanian'
	, 'Dedaban', 'Ertosns', 'Farhadmirza', 'Fawaz124', 'Freedom\'s Falcon'
	, 'Islam90', 'Mohanad838', 'Mr. Ibrahem', 'Omar Alyahya', 'Ravan'
	, 'Sarmad Yaseen', 'WISAMS041', 'Bachounda', 'Mohammed alzaidy'
	, 'Salsabil rajhi', 'بلقيس محمود المناصير', 'علاء','علاء فحصي','محمد عبد الغني')
)
SQL

Checking query status...
