Page intersections between a reference actor and one or more other actors with page edit counts

SQL

set @x = 'Huldra';
set @y1 = '007Леони́д', @y2 = '11Fox11';
set @q = '
with xrev as (
	select ''x'' actor, ru.rev_page, count(*) editcount
	from actor_user au
	join revision_userindex ru on au.actor_id = ru.rev_actor and au.actor_name = ?
	group by 2
),
yrev as (
	select ''y'', ru.rev_page, count(*) editcount 
	from (
		select actor_id 
		from actor_user 
        where actor_name in (?,?)
    ) ysocks
	join revision_userindex ru on ysocks.actor_id = ru.rev_actor
	group by 2
)
select 
	xrev.rev_page, 
	convert(replace(p.page_title,''_'','' '') using utf8mb4) page_title, 
	p.page_namespace, 
	case
	when p.page_namespace = 0 then ''(Main/Article)''
	when p.page_namespace = 1 then ''Talk''
	when p.page_namespace = 2 then ''User''
	when p.page_namespace = 3 then ''User talk''
	when p.page_namespace = 4 then ''Wikipedia''
	when p.page_namespace = 5 then ''Wikipedia talk''
	when p.page_namespace = 6 then ''File''
	when p.page_namespace = 7 then ''File talk''
	when p.page_namespace = 8 then ''MediaWiki''
	when p.page_namespace = 9 then ''MediaWiki talk''
	when p.page_namespace = 10 then ''Template''
	when p.page_namespace = 11 then ''Template talk''
	when p.page_namespace = 12 then ''Help''
	when p.page_namespace = 13 then ''Help talk''
	when p.page_namespace = 14 then ''Category''
	when p.page_namespace = 15 then ''Category talk''
	when p.page_namespace = 100 then ''Portal''
	when p.page_namespace = 101 then ''Portal talk''
	when p.page_namespace = 118 then ''Draft''
	when p.page_namespace = 119 then ''Draft talk''
	when p.page_namespace = 710 then ''TimedText''
	when p.page_namespace = 711 then ''TimedText talk''
	when p.page_namespace = 828 then ''Module''
	when p.page_namespace = 829 then ''Module talk''
	else null
	end as namespace_desc, 
	case when p.page_is_redirect = 0 then ''No'' else ''Yes'' end page_is_redirect,
	xrev.editcount ''ref actor'', 
	yrev.editcount ''other actor(s)'' 
from xrev
join yrev on xrev.rev_page = yrev.rev_page
join page p on xrev.rev_page = p.page_id
order by 2,3';

prepare s from @q;
execute s using @x, @y1, @y2;
deallocate prepare s;
SQL

Checking query status...
