Untitled query #41293

SQL

use ruwiki_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 = 'ruwiki' and ips_site_page = replace(page_title, "_", " ")
where rev_timestamp between '20191201000000' and '20200101000000'
and page_namespace = 0
and a.actor_name in ('SORBON RS01',
'Soul Train',
'Andreykor',
'Villarreal9',
'Mvk608',
'Фред-Продавец звёзд',
'Armineaghayan',
'IvshinPavel',
'AQVA121',
'Topp',
'A.mekenova',
'zaygle',
'Roman Puzin',
'JukoFF',
'Арсенич',
'CesarNS1980',
'Калорит',
'Kiryienka',
'Stolbovsky',
'Yartsew',
'AMG~ruwiki',
'Edmondantes30rus',
'Victor villacis',
'Mu$ton',
'Rev100000000000000000',
'Eskarec',
'Mrabetz',
'Рыцарь меда (не сахарного)',
'perena',
'Mapatxea',
'Mark Ekimov',
'Dariakupila',
'Gilgamew',
'Сергей Лебедев',
'Роман Франц',
'Shpep',
'Lemniskos',
'Саша 333',
'Максим Кузахметов',
'Ketana2000',
'Balabinrm')
SQL

Checking query status...
