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('sockpuppet', 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
and locate('User_pages_with_short_description', categorylinks.cl_to) = 0
and locate('reference_errors', categorylinks.cl_to) = 0
and locate('doppelganger', categorylinks.cl_to) = 0
and locate('Pages_with_missing_files', categorylinks.cl_to) = 0
and locate('Userpage_header_templates', categorylinks.cl_to) = 0
and locate('Paid_contributors', categorylinks.cl_to) = 0
and locate('Pages_with_disallowed_DISPLAYTITLE_modifications', categorylinks.cl_to) = 0
group by 1,2
limit 100
SQL

Checking query status...
