Untitled query #87965

SQL

select 
convert(replace(p.page_title,'_',' ') using utf8mb4) page_title, 
p.page_namespace, 
p.page_is_redirect,
p2.rev_count 'Huldra+Icewhiz rev_count'
from page p
join (
select ru.rev_page, count(ru.rev_id) as rev_count
from revision_userindex ru
join actor_revision ar on ar.actor_id = ru.rev_actor
where ar.actor_name in ('Huldra', 'Icewhiz')
group by ru.rev_page
having count(distinct ar.actor_id)=2
) p2
on p2.rev_page = p.page_id
order by 1,2,3

AخA
 
select convert(replace(p.page_title,'_',' ') using utf8mb4) page_title, p.page_namespace, p.page_is_redirect,p2.rev_count 'Huldra+Icewhiz rev_count'from page pjoin (select ru.rev_page, count(ru.rev_id) as rev_countfrom revision_userindex rujoin actor_revision ar on ar.actor_id = ru.rev_actorwhere ar.actor_name in ('Huldra', 'Icewhiz')group by ru.rev_pagehaving count(distinct ar.actor_id)=2) p2on p2.rev_page = p.page_idorder by 1,2,3

SQL

Checking query status...