Get article creation date and Wikidata item by category - Wikiproject Black Lives Matter

SQL

USE enwiki_p;
SELECT page_props.pp_value, article.page_title, revision.rev_timestamp,
	MIN(revision.rev_id),  MAX(revision.rev_id), COUNT(*) AS edits, article.page_len
FROM revision
INNER JOIN page article ON 
   article.page_id = rev_page AND
   article.page_namespace = 0
INNER JOIN page talk ON 
   talk.page_title = article.page_title AND
   talk.page_namespace = 1
INNER JOIN categorylinks ON 
   cl_from = talk.page_id
INNER JOIN page_props ON
   article.page_id = page_props.pp_page
WHERE 
#	cl_to = "WikiProject_Visual_arts_articles" AND
	cl_to LIKE "%Black_Lives_Matter_articles" AND
	page_props.pp_propname = "wikibase_item"
GROUP BY article.page_id
ORDER BY rev_timestamp
#LIMIT 10;

#Based on https://en.wikipedia.org/wiki/Wikipedia:WikiProject_Wiki_Loves_Women/queries
#With some help from ragesoss on the Wikidata query
#FYI, it takes a long time to execute

SQL

Checking query status...