unreviewed pages

SQL

WITH RECURSIVE Cat AS (SELECT page_title, page_id
                        FROM page
                       WHERE page_title = 'Biologie'
                         AND page_namespace = 14
                       UNION
                      SELECT SubCat.page_title, SubCat.page_id
                        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 Art.page_title AS "Artikel", Fp.fp_pending_since AS "Seit"
  FROM Cat
 INNER JOIN categorylinks AS CatLinks ON Cat.page_title = CatLinks.cl_to
 INNER JOIN page AS Art ON CatLinks.cl_from = Art.page_id
 RIGHT JOIN flaggedpages AS Fp ON Fp.fp_page_id = Art.page_id
 WHERE Art.page_namespace = 0
ORDER BY Seit
SQL

Checking query status...
