Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Pharos
.
Toggle Highlighting
SQL
USE enwiki_p; SELECT STR_TO_DATE(rev_timestamp,'%Y%m%d%H%i%S') rev_timestamp,STR_TO_DATE(rc_timestamp,'%Y%m%d%H%i%S') rc_timestamp,page_id,page_title,GROUP_CONCAT(DISTINCT cl_to,', ') `relevant cats` FROM categorylinks,page LEFT OUTER JOIN recentchanges ON rc_cur_id=page_id AND rc_new=1 LEFT OUTER JOIN revision ON rev_page=page_id AND rev_parent_id=0 WHERE cl_to IN -- python -c $'import sys\nprint ",".join(repr(i.strip().replace(" ","_")) for i in sys.stdin.readlines())' < cats.txt > cats.escaped.txt ('Collection_of_the_Metropolitan_Museum_of_Art','Architecture_in_collection_of_the_Metropolitan_Museum_of_Art','Arms_and_armor_of_the_Metropolitan_Museum_of_Art','Ceramics_of_the_Metropolitan_Museum_of_Art','Jewellery_of_the_Metropolitan_Museum_of_Art','Manuscripts_of_the_Metropolitan_Museum_of_Art','Metalwork_of_the_Metropolitan_Museum_of_Art','Paintings_of_the_Metropolitan_Museum_of_Art','Sculptures_of_the_Metropolitan_Museum_of_Art','Velazquez_portraits_in_Metropolitan_Museum_of_Art') AND cl_from=page_id AND page_namespace=0 GROUP BY page_id ORDER BY rev_timestamp DESC
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...