Untitled query #23531

SQL

use ptwiki_p;
select 'pt', 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 ptwiki_p.revision r1 
left join ptwiki_p.revision r2
	on r1.rev_parent_id = r2.rev_id
, ptwiki_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 ptwiki_p.user where user_name in (
		'Conde Edmond Dantès', 'Domusaurea', 'Edsonialopes', 'Enaldoss18072004', 'Gabriel Mungongo'
		, 'Hgh1993', 'Kelvin Samuel', 'Marcelo RosaMelo', 'Tuga1143')
	)
SQL

Checking query status...
