Strony w Kategoria:Prawo rzymskie wg pierwszych autorów

SQL

SET @category := 'Prawo_rzymskie';
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 DISTINCT page_title, actor_name FROM page
	JOIN categorylinks ON page_id = cl_from
    JOIN subcategories ON sbc_title = cl_to
    JOIN revision ON rev_page = page_id
    JOIN actor ON rev_actor = actor_id
    WHERE rev_parent_id = 0
    	AND page_namespace = 0
    ORDER BY 1
	LIMIT 1000;

SQL

Checking query status...