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 *
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 ("Military history");
 

 #where pap_project_title in ("Military history", "Africa", "Books", "Feminism", "Women\'s Health", "Video games", "Medicine", "Oregon")
 
 #select *
#from page_assessments_projects 
#LIMIT 10;

 #SELECT *
 #FROM page
 #LIMIT 10;
SQL

Checking query status...
