Untitled query #91043

SQL

SELECT 
    subcat.page_title AS subcategory,
    COUNT(page.page_id) AS article_count
FROM categorylinks AS cl
JOIN page AS subcat ON cl.cl_from = subcat.page_id
LEFT JOIN categorylinks AS cl2 ON cl2.cl_to = subcat.page_title
LEFT JOIN page AS page ON cl2.cl_from = page.page_id AND page.page_namespace = 0
WHERE cl.cl_to = 'Lemmas_by_language' -- Main category (replace with the correct category title)
AND subcat.page_namespace = 14 -- Namespace 14 is for categories
GROUP BY subcat.page_title
ORDER BY article_count DESC;
SQL

Checking query status...
