Gewässer mit "alb" oder "albe" am Wortende

SQL

WITH RECURSIVE Cat AS (SELECT page_title
                        FROM page
                       WHERE page_title = 'Gewässer' /* Subcats dieser Kategorie */
                         AND page_namespace = 14
                       UNION
                      SELECT SubCat.page_title
                        FROM page AS SubCat, categorylinks, Cat
                       WHERE SubCat.page_namespace = 14
                         AND cl_from = SubCat.page_id
                         AND cl_to = Cat.page_title
                         AND cl_type = "subcat"
                     )
SELECT DISTINCT page.page_title
  FROM page, Cat
 WHERE page.page_namespace = 0
   AND page.page_id = cl_from
   AND (page.page_title LIKE "%alb"
        OR page.page_title LIKE "%alb_(%"
        OR page.page_title LIKE "%albe"
        OR page.page_title LIKE "%albe_(%"
       )
SQL

Checking query status...
