Get article creation date and Wikidata item by category

SQL

USE enwiki_p;
SELECT
 MIN(rev_id), article.page_title, rev_timestamp,
 page_props.pp_value,
 COUNT(*) AS edits
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_Biography_articles" AND
   cl_to = "WikiProject_Visual_arts_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
SQL

Checking query status...
