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
Matěj Suchánek
.
Toggle Highlighting
SQL
USE cswiki_p; SELECT * FROM recentchanges LIMIT 10; /* SELECT page_title, wbc2.eu_touched, GROUP_CONCAT(DISTINCT wbc2.eu_entity_id SEPARATOR ', ') FROM (SELECT * FROM wikidatawiki_p.recentchanges WHERE rc_namespace = 0) AS rc JOIN wbc_entity_usage AS wbc1 ON wbc1.eu_entity_id = rc_title AND eu_touched = rc_timestamp JOIN wbc_entity_usage AS wbc2 ON wbc2.eu_page_id = wbc1.eu_page_id JOIN page ON page_id = wbc2.eu_page_id GROUP BY wbc2.eu_page_id ORDER BY wbc2.eu_touched DESC LIMIT 25; */ /* SELECT COUNT(*), COUNT(DISTINCT eu_page_id), COUNT(DISTINCT eu_entity_id) FROM wbc_entity_usage; SELECT page_title, page_id, eu_touched, eu_entity_id, GROUP_CONCAT(DISTINCT eu_aspect SEPARATOR ', ') AS aspects, eu_row_id, rev_timestamp FROM wbc_entity_usage JOIN page ON page_id = eu_page_id LEFT JOIN revision ON rev_id = page_latest AND rev_timestamp <> eu_touched GROUP BY eu_touched, eu_page_id, eu_entity_id ORDER BY eu_row_id DESC LIMIT 25; */ SELECT rc_title, eu_touched, GROUP_CONCAT(DISTINCT eu_entity_id SEPARATOR ', ') AS entities, rc_this_oldid, MAX(eu_row_id) FROM (SELECT * FROM recentchanges WHERE rc_source = "mw.edit") AS changes JOIN wbc_entity_usage ON eu_page_id = rc_cur_id WHERE eu_touched = rc_timestamp GROUP BY eu_touched, eu_page_id HAVING COUNT(DISTINCT eu_entity_id) > 2 ORDER BY MAX(eu_row_id) DESC LIMIT 25; /* SELECT eu_row_id, pages.page_title, eu_touched, eu_entity_id, GROUP_CONCAT(eu_aspect) AS aspects, rev_timestamp FROM wbc_entity_usage JOIN page AS pages ON pages.page_id = eu_page_id JOIN (SELECT * FROM wikidatawiki_p.page WHERE page_namespace = 0) AS items ON items.page_title = eu_entity_id JOIN wikidatawiki_p.revision ON rev_id = items.page_latest WHERE rev_timestamp = eu_touched GROUP BY rev_id ORDER BY rev_id DESC LIMIT 25; */ /* SELECT page_title, COUNT(DISTINCT eu_entity_id), COUNT(eu_aspect), eu_touched FROM wbc_entity_usage JOIN page ON page_id = eu_page_id GROUP BY eu_page_id HAVING COUNT(DISTINCT eu_entity_id) > 25 ORDER BY COUNT(DISTINCT eu_entity_id) DESC, COUNT(eu_aspect) DESC, page_title; SELECT eu_entity_id, COUNT(DISTINCT eu_page_id) FROM wbc_entity_usage GROUP BY eu_entity_id HAVING COUNT(DISTINCT eu_page_id) > 250 ORDER BY COUNT(DISTINCT eu_page_id) 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...