Replicas browser and optimizer
This query is marked as a draft
This query has been published
Per https://en.wikipedia.org/wiki/Wikipedia:WikiProject_Medicine/Assessment#Importance_scale, individuals should be rated Low-importance. So, what's the intersection between WPMED's Top/High/Mid-importance categories and several categories related to people? NOTE: This query might list articles that are not strictly about people (e.g. "Cretinism" is in the category "Pejorative terms for people"), so proceed with caution.
USE enwiki_p; SELECT DISTINCT art.page_id, art.page_title, talk.cl_to FROM (SELECT page_id, page_title, cl_to FROM categorylinks JOIN page ON cl_from=page_id WHERE cl_to IN ('Top-importance_medicine_articles', 'High-importance_medicine_articles', 'Mid-importance_medicine_articles') AND page_namespace=1) AS talk JOIN page art ON (talk.page_title=art.page_title AND art.page_namespace=0) JOIN categorylinks cl ON cl.cl_from=art.page_id WHERE cl.cl_to REGEXP '^People.*' OR cl.cl_to REGEXP '.*people$' OR cl.cl_to REGEXP '^\\d+_deaths$' OR cl.cl_to REGEXP '^\\d+_births$';
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