Get article creation date by category (svwp, Män)

SQL

USE svwiki_p;
SELECT page_props.pp_value, article.page_title, DATE_FORMAT(revision.rev_timestamp, '%Y-%m-%d') AS timestamp, COUNT(*) AS edits
FROM revision
INNER JOIN page article ON 
   article.page_id = rev_page AND
   article.page_namespace = 0
INNER JOIN categorylinks ON 
   cl_from = article.page_id
INNER JOIN page_props ON
   article.page_id = page_props.pp_page
WHERE 
	cl_to = "Män" 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...