Prozentuale Beteiligung an Seiten (ohne WL, BKS)

SQL

use dewiki_p;
select page_title, 
SUM(CASE WHEN rev_user=(select user_id from user where user_name='Ghilt') THEN 1 END)*100/count(rev_id) as Beitragsanteil
from revision_userindex 
inner join page on rev_page = page_id
left outer join redirect on rev_page = rd_from
where rd_from is NULL and rev_page in 
(select distinct rev_page from 
revision_userindex 
inner join page on rev_page = page_id
 where rev_user=(select user_id from user where user_name='Ghilt') and page_namespace = 0 and not page_id = any 
 (select page_id from categorylinks where cl_from=page_id and cl_to='Begriffsklärung'))
group by rev_page
having Beitragsanteil >= 10
order by Beitragsanteil desc;

SQL

Checking query status...