SELECT 

    p.page_title AS article_title,

    GROUP_CONCAT(DISTINCT ll.ll_lang) AS translated_languages,

    COUNT(DISTINCT ll.ll_lang) AS language_count

FROM page p

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

JOIN langlinks ll ON p.page_id = ll.ll_from

WHERE 

    p.page_namespace = 0  -- Main namespace (articles)

    AND ctd.ctd_name = 'contenttranslation'

    AND (

        cl.cl_to LIKE '%health%' 

        OR cl.cl_to LIKE '%medicine%'

        OR cl.cl_to LIKE '%disease%'

        OR cl.cl_to LIKE '%medical%'

    )

GROUP BY p.page_title

HAVING language_count >= 5  -- Lowered threshold to catch more results

ORDER BY language_count DESC

LIMIT 50;

​