Untitled query #74934

SQL

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;
SQL

Checking query status...
