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 wikidatawiki_p; /*SELECT COUNT(*) FROM cswiki_p.wbc_entity_usage; SELECT page_title, COUNT(DISTINCT eu_entity_id), COUNT(eu_aspect), eu_last_touched FROM cswiki_p.wbc_entity_usage # JOIN (SELECT * FROM wb_changes_subscription WHERE cs_subscriber_id = "cswiki") AS changes # ON changes.cs_entity_id = eu_entity_id JOIN cswiki_p.page ON page_id = eu_page_id GROUP BY eu_page_id ORDER BY COUNT(DISTINCT eu_entity_id) DESC LIMIT 50; SELECT page_title, UPPER(change_object_id), change_revision_id, change_type, change_time FROM wb_changes JOIN (SELECT * FROM user WHERE user_name = "Matěj Suchánek") AS user ON user.user_id = change_user_id JOIN (SELECT * FROM wb_items_per_site WHERE ips_site_id = "cswiki") AS ips ON CONCAT("q",ips.ips_item_id) = change_object_id JOIN cswiki_p.page ON page_title = ips.ips_site_page ORDER BY change_time DESC LIMIT 50;*/ DESCRIBE wb_changes_subscription;
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...