enwiki: WikiProject Archaeology articles

Lists all articles that are tagged as of interest to WikiProject Archaeology, excluding redirects, along with associated WikiData item and information on project quality/importance assessment.

SQL

USE enwiki_p;

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

-- oresm_id for article quality (latest version):
SELECT oresm_id FROM ores_model WHERE oresm_name = "articlequality" AND oresm_is_current = 1;
-- 57
*/

SELECT
  page.page_id,
  page.page_title,
  page.page_len,
  ass.pa_class,
  ass.pa_importance,
  prop.pp_value AS wikidata
FROM
  page_assessments AS ass
  INNER JOIN page ON page.page_id = ass.pa_page_id
  LEFT JOIN page_props AS prop ON page.page_id = prop.pp_page
WHERE
  ass.pa_project_id = 406
  AND page.page_namespace = 0
  AND page.page_is_redirect = 0
  AND prop.pp_propname = "wikibase_item";

SQL

Checking query status...