Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Kasyap
.
Toggle Highlighting
SQL
SELECT DISTINCT article.page_title 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;
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...