list of pages in category

SQL

WITH RECURSIVE subcategories AS (  -- Step 1: Start with the root category  
  SELECT    cl_from AS subcat_id  
  FROM    categorylinks  WHERE    cl_to = 'ವರ್ಷಗಳ_ಪ್ರಕಾರ_ಕನ್ನಡ_ಚಲನಚಿತ್ರಗಳು' -- Root category name (replace spaces with underscores)    
  AND cl_type = 'subcat'  UNION ALL  -- Step 2: Recursively find subcategories  
  SELECT    cl_from  FROM    categorylinks  JOIN    subcategories ON cl_to = page_title  WHERE    cl_type = 'subcat'),-- Step 3: Find pages in subcategories
  pages_in_subcategories AS (  SELECT    page_id,    page_title  FROM    page  JOIN    categorylinks ON cl_from = page_id  WHERE    cl_from IN (SELECT subcat_id FROM subcategories)    AND page_namespace = 0 -- Main namespace (articles))-- Step 4: Output results
                             SELECT  CONCAT('https://kn.wikipedia.org/wiki/', REPLACE(page_title, ' ', '_')) AS page_linkFROM  pages_in_subcategories;
SQL

Checking query status...
