list of pages in category

SQL

USE knwiki_p;
WITH RECURSIVE subcategories AS (  
  SELECT cl_from  
  FROM categorylinks  
  JOIN page ON cl_from = page_id  
  WHERE cl_to = 'ವರ್ಷಗಳ_ಪ್ರಕಾರ_ಕನ್ನಡ_ಚಲನಚಿತ್ರಗಳು'    
  AND cl_type = 'subcat'    
  AND page_namespace = 14  
  UNION ALL  
  SELECT cl.cl_from  
  FROM categorylinks cl  
  JOIN page p ON cl.cl_from = p.page_id  
  JOIN subcategories sc ON cl.cl_to = p.page_title  
  WHERE cl.cl_type = 'subcat' 
  AND p.page_namespace = 14),pages_in_subcategories AS (  
    SELECT pg.page_title  FROM page pg  JOIN categorylinks cl ON cl.cl_from = pg.page_id  WHERE cl.cl_to IN (SELECT page_title FROM page WHERE page_id IN (SELECT cl_from FROM subcategories))    AND pg.page_namespace = 0)SELECT CONCAT('https://kn.wikipedia.org/wiki/', REPLACE(page_title, ' ', '_')) AS page_linkFROM pages_in_subcategories;
SQL

Checking query status...
