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