SELECT r1.rev_timestamp, actor_name, page_title, comment_text, page_id, cl.cl_to

FROM page AS article

JOIN categorylinks AS articlecat

ON articlecat.cl_from = article.page_id

WHERE article.page_namespace = 0

AND article.page_is_redirect = 0

AND article.page_len < 3000

AND NOT EXISTS (SELECT 1

  FROM categorylinks

  WHERE cl_from = article.page_id

  AND cl_to = 'All_disambiguation_pages'

)

AND EXISTS (SELECT 1

  FROM categorylinks

  WHERE cl_from = article.page_id

  AND cl_to in (

    'Dental equipment',

    'Dentistyla',

    'Dentistry procedures',

    'Health_law',

    'Health_economics',

    'Health_education',

    'People_in_health_professions',

    'Health_deities',

    'Health_research',

    'Health_activists',

    'Health_sciences',

    'Health_by_country',

    'Hygiene',

    'Health_by_continent',

    'Health_movements',

    'Diseases_and_disorders',

    'Health_by_individual',

    'Health_policy',

    'Health_officials',

    'Health_informatics',

    'Mountaineering_and_health',

    'Health_stubs',

    'Health-related_lists',

    'Works_about_health',

    'Medical_and_health_organizations',

    'Determinants_of_health',

    'Alcohol_and_health',

    'Race_and_health',

    'Health_care',

    'Public_health',

    'Mental_health',

    'Quality_of_life',

    'Nutrition',

    'Global_health',

    'Medicine',

    'Children''s_health',

    'Environmental_health',

    'Men''s_health',

    'Occupational_safety_and_health',

    'Sexual_health',

    'Women''s_health',

    'Youth_health',

    'Health_and_medical_activism',

    'Health_effects_by_subject',

    'Oral_hygiene',

    'Maternal oral health',

  )

)

ORDER BY article.page_title;