Untitled query #8085

SQL

SELECT
	cp.page_title AS cat,
    (cat_pages-cat_subcats-cat_files) AS `#p`,
    GROUP_CONCAT(p1.page_title ORDER BY p1.page_title SEPARATOR '|') AS `articles`
FROM page cp, category cat0, categorylinks cl1, page p1
WHERE
	cp.page_is_redirect=0 AND
	cp.page_namespace=14 AND
    cp.page_title NOT REGEXP '^Artikel_in_de_|^Pl(ak|[ao][ao]tse?)_in_|^Wikipedie:|^Ziejen_die_|_(ie?|va)n_|_artikel$' AND
    cp.page_title=cat_title AND
	NOT EXISTS (SELECT * FROM categorylinks cl0 WHERE cl_to=cp.page_title AND cl_sortkey_prefix REGEXP '^[ !\\*]') AND
    cl1.cl_to=cat_title AND
    cl1.cl_from=p1.page_id AND
    p1.page_namespace=0
GROUP BY `cat`, `#p`
HAVING `#p`>1
SQL

Checking query status...
