Untitled query #24677

SQL

Use enwiki_p;

#show tables;
#select *
#from page_assessments
#limit 10;

#select *
#from page_assessments_projects 
#JOIN page
# ON pap_project_id = page_id
# where pap_project_title in ("Military history");


SELECT pap_project_title, pa_page_id, page_title
FROM page_assessments 
JOIN page_assessments_projects
ON pa_project_id = pap_project_id
JOIN page
ON pa_page_id = page_id
where pap_project_title in ("Video games");
 
 #"Video games"
#where pap_project_title in ("Military history", "Africa", "Books", "Visual arts", "Kurdistan", "Feminism", "Women\'s Health", "Video games", "Medicine", "Oregon", "Skepticism", "Women\'s sport", "JavaScript (and user scripts)", "JavaScript", "Health and fitness", "Cornwall", "AIDS", "Hampshire", "Bangladesh", "Archaeology", "Aquarium Fishes", "Chicago", "Cannabis", "G.I. Joe", "Board and table games/Carrom task force", "Board and table games", "Squash", "Cricket", "Dinosaurs", "Paleontology", "Democratic Republic of the Congo", "India")
 #where pap_project_title in ("Military history", "Africa", "Books", "Feminism", "Women\'s Health", "Video games", "Medicine", "Oregon", "Skepticism", "Women\'s sport", "JavaScript (and user scripts)", "JavaScript", "Health and fitness", "Cornwall", "AIDS", "Hampshire", "Bangladesh", "Archaeology", "Aquarium Fishes", "Chicago", "Cannabis", "G.I. Joe", "Board and table games/Carrom task force", "Board and table games", "Squash", "Cricket", "Dinosaurs", "Paleontology", "Democratic Republic of the Congo", "India")
 
 #select *
#from page_assessments_projects 
#LIMIT 10;

 #SELECT *
 #FROM page
 #LIMIT 10;
SQL

Checking query status...
