Article, WikiProject pairs for English Wikipedia

Fork of Article importance classes for English Wikipedia by Halfak (WMF)

This query is marked as a draft This query has been published by EpochFail.

SQL

SELECT
  article.page_id,
  article.page_namespace,
  article.page_title,
  SUBSTRING_INDEX(cl.cl_to, "_", 2) AS wikiproject,
  cl.cl_to AS category,
  cl.cl_type AS category_type,
  DATE_FORMAT(cl.cl_timestamp, "%Y%m%d%H%i%S") AS last_update
FROM categorylinks cl
JOIN page tp ON
  cl.cl_from = tp.page_id AND
  tp.page_namespace = 1
JOIN page article ON
  article.page_title = tp.page_title AND
  article.page_namespace = 0
WHERE
  cl.cl_to LIKE "Top-importance%articles" OR
  cl.cl_to LIKE "High-importance%articles" OR
  cl.cl_to LIKE "Mid-importance%articles" OR
  cl.cl_to LIKE "Low-importance%articles" OR
  cl.cl_to LIKE "Unknown-importance%articles";

SQL

Checking query status...