Replicas browser and optimizer
This query is marked as a draft
This query has been published
This query uses three JOINs to get you the title of all pages in the "Oral hygiene" category that have at least one "Citation needed" template.
SELECT page_title FROM page JOIN templatelinks ON tl_from = page_id JOIN categorylinks ON cl_from = page_id WHERE cl_to = "Oral_hygiene" AND tl_namespace = 10 AND tl_title = "Citation_needed" AND page_namespace = 0;
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in