use tewiki_p;

SELECT

  page_title, GROUP_CONCAT(cl_to)

FROM page

inner join

categorylinks

on cl_from = page_id

where page_is_redirect = 0

and page_namespace = 0

and cl_to not in (select page_title from page where page_namespace = 14 and page_is_redirect = 0 and cl_to = page_title)

group by page_title

limit 50000;