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_link
    FROM pages_in_subcategories;
    limit 200
SQL

Checking query status...
