Untitled query #87336

SQL

SELECT 
    subcat_page.page_title AS subcategory_name,
    COUNT(*) AS article_count
FROM categorylinks AS subcat
JOIN page AS p ON subcat.cl_from = p.page_id
JOIN page AS subcat_page ON subcat.cl_to = subcat_page.page_title AND subcat_page.page_namespace = 14
WHERE subcat.cl_type = 'page'
AND subcat.cl_to IN (
    SELECT cl_to
    FROM categorylinks
    WHERE cl_from = (
        SELECT page_id
        FROM page
        WHERE page_title = 'Bon_article_dans_une_autre_langue'
        AND page_namespace = 14
    )
)
GROUP BY subcat.cl_to
HAVING COUNT(*) < 10
ORDER BY article_count ASC;
SQL

Checking query status...
