Untitled query #23531

SQL

use eswiki_p;
select 'es', 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 eswiki_p.revision r1 
left join eswiki_p.revision r2
	on r1.rev_parent_id = r2.rev_id
	and r1.rev_page = r2.rev_page
, eswiki_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 eswiki_p.user where user_name in (
		'Adolfobrigido', 'Akhram', 'AnselmiJuan', 'Aragonito8', 'El Pantera',
		'Humberto del Torrejón', 'KES47', 'Leetotherear', 'Ling', 'Macesito',
		'Mar del Sur', 'Marcelo RosaMelo', 'MarisaLR', 'Metrónomo', 'Rosarinagazo',
		'Sabbut', 'Sarahi78', 'Super Dromaeosaurus', 'Uviein', 'Vanbasten 23', 
		'Vec02', 'Wikisheldon', 'Darthvader2', 'Justeen collado', 'Samucastillo')
	)
SQL

Checking query status...
