list of pages in category

SQL

USE knwiki_p;
WITH RECURSIVE subcategories AS (  
SELECT    cl_from AS subcat_id  
  FROM    categorylinks  
  WHERE    cl_to = 'ವರ್ಷಗಳ_ಪ್ರಕಾರ_ಕನ್ನಡ_ಚಲನಚಿತ್ರಗಳು'    
  AND cl_type = 'subcat'  
  UNION ALL  
  SELECT    cl_from  
  FROM    categorylinks  
  JOIN    subcategories ON cl_to = page_title  
  WHERE    cl_type = 'subcat'),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)
                                                          SELECT  CONCAT('https://kn.wikipedia.org/wiki/', REPLACE(page_title, ' ', '_')) AS page_link
                                                          FROM  pages_in_subcategories;
SQL

Checking query status...
