USE elwiki_p;

SELECT page_namespace, page_title

FROM page d

WHERE

    page_namespace IN (10, 828) AND ((

    page_title REGEXP '/doc$' AND

    NOT EXISTS (

      SELECT * 

      FROM page m 

      WHERE m.page_namespace=d.page_namespace AND m.page_title=REGEXP_REPLACE(d.page_title, '/doc$', ''))

    ) OR (

    page_title REGEXP '/[^/]+\\.css$' AND

    NOT EXISTS (

      SELECT * 

      FROM page m 

      WHERE m.page_namespace=d.page_namespace AND m.page_title=REGEXP_REPLACE(d.page_title, '/[^/]+\\.css$', ''))

    ))