Untitled query #60545

SQL

USE enwiki_p;
select page.page_title, page.page_restrictions, group_concat(distinct categorylinks.cl_to separator '; ') as user_cats, count(categorylinks.cl_to)
from page
join categorylinks on categorylinks.cl_from = page.page_id
where page.page_namespace = 2
and locate('Noindexed_pages', categorylinks.cl_to) = 0
and locate('sockpuppets', categorylinks.cl_to) = 0
and locate('Wikipedia_alternative_accounts', categorylinks.cl_to) = 0
and locate('Redirects_from_moves', categorylinks.cl_to) = 0
and locate('bots', categorylinks.cl_to) = 0
group by 1,2
limit 100
SQL

Checking query status...
