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