Untitled query #88420

SQL

SELECT DISTINCT p.page_title, 
       COUNT(DISTINCT ll.ll_lang) AS translation_count
FROM page p
JOIN langlinks ll ON p.page_id = ll.ll_from
JOIN categorylinks cl ON p.page_id = cl.cl_from
JOIN change_tag ct ON p.page_id = ct.ct_rev_id
JOIN change_tag_def ctd ON ct.ct_tag_id = ctd.ctd_id
WHERE p.page_namespace = 0  -- Main namespace (articles)
AND ctd.ctd_name = 'contenttranslation'
AND cl.cl_to LIKE '%health%'  -- Categories related to health
GROUP BY p.page_title
HAVING translation_count >= 10
ORDER BY translation_count DESC
LIMIT 100;  -- Limit to first 100 results
SQL

Checking query status...
