Untitled query #41293

SQL

use cewiki_p;
SELECT convert(page_title, char) page, 
	rev_len size_rev, rev_id id, 
	convert(a.actor_name, char) user, 
	convert(a.actor_user, char) user_id, 
	convert(rev_timestamp, char) as timestamp, 
	ips_item_id as wikidata_item
	, (rev_len - ifnull((select rev_len FROM revision r2 where r2.rev_id = r1.rev_parent_id), 0)) as diff
FROM revision r1
inner join actor a on r1.rev_actor = a.actor_id
inner join page p on r1.rev_page = p.page_id
left join wikidatawiki_p.wb_items_per_site on ips_site_id = 'cewiki' and ips_site_page = replace(page_title, "_", " ")
where rev_timestamp between '20191201000000' and '20200101000000'
and page_namespace = 0
and a.actor_name in ('Takhirgeran Umar',
'Саид Мисарбиев')
SQL

Checking query status...
