enwiki: WikiProject Archaeology articles

SQL

USE enwiki_p;

/* WikiProject Archaeology
SELECT pap_project_id FROM page_assessments_projects WHERE pap_project_title = "Archaeology");
-- 406
*/

SELECT 
  page.page_id, page.page_namespace, page.page_is_redirect, page.page_title, 
  ass.pa_class, ass.pa_importance,
  ores.oresc_model, ores.oresc_class, ores.oresc_probability
FROM page_assessments AS ass
INNER JOIN page ON page.page_id = ass.pa_page_id
INNER JOIN ores_classification AS ores ON page.page_latest = ores.oresc_rev
WHERE 
  ass.pa_project_id = 406 AND
  ores.oresc_model = (SELECT oresm_id FROM ores_model WHERE oresm_name = "articlequality" AND oresm_is_current = 1);

/*SELECT DISTINCT page.page_id, page.page_title
FROM page
INNER JOIN categorylinks ON
  cl_from = page.page_id
WHERE
  cl_to IN ("Top-importance_Archaeology_articles", 
            "High-importance_Archaeology_articles", 
            "Mid-importance_Archaeology_articles", 
            "Low-importance_Archaeology_articles",
            "NA-importance_Archaeology_articles",
            "Unknown-importance_Archaeology_articles")
ORDER BY page.page_title ASC;*/
SQL

Checking query status...
