Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
Get article creation date and Wikidata item by category
by
Theredproject
This query is marked as a draft
This query has been published
by
Theredproject
.
Toggle Highlighting
SQL
USE enwiki_p; SELECT page_props.pp_value, article.page_title, revision.rev_timestamp, MIN(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
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...