Strony oczekujące na przejrzenie według (pod)kategorii

SQL

SET @category := 'Informatyka';
SET @depth_limit := 10;

WITH RECURSIVE subcategories(sbc_title, sbc_depth) AS (
	SELECT @category, 0 FROM DUAL
  	UNION ALL
  	SELECT page_title, sbc_depth+1 FROM subcategories
  		JOIN categorylinks ON cl_to = sbc_title
  		JOIN page ON cl_from = page_id
  		WHERE cl_type = 'subcat'
  			AND sbc_depth <= @depth_limit
)
SELECT page_title, fpp_pending_since, cl_to FROM flaggedpage_pending
	JOIN categorylinks ON fpp_page_id = cl_from
    JOIN subcategories ON sbc_title = cl_to
    JOIN page ON fpp_page_id = page_id
	LIMIT 10;

SQL

Checking query status...