Wikidata usage in cswiki

SQL

SELECT COUNT(*) FROM cswiki_p.wbc_entity_usage;

SELECT eu_row_id, GROUP_CONCAT(eu_entity_id,eu_aspect), COUNT(eu_entity_id)
	FROM cswiki_p.wbc_entity_usage 
	JOIN wikidatawiki_p.wb_changes_subscription 
		ON cs_entity_id = eu_entity_id
WHERE cs_subscriber_id = "cswiki"
ORDER BY eu_row_id DESC
GROUP BY eu_page_id, eu_entity_id
LIMIT 50;

SELECT change_id, change_type, change_time, change_object_id, change_revision_id, change_user_id
	FROM wikidatawiki_p.wb_changes
	JOIN (SELECT * FROM wikidatawiki_p.user WHERE user_name = "Matěj Suchánek") AS user
		ON user.user_id = change_user_id
ORDER BY change_time DESC
LIMIT 25;

# DESCRIBE wikidatawiki_p.wb_changes_dispatch;
# SELECT * FROM wikidatawiki_p.wb_changes_dispatch ORDER BY chd_touched DESC;

# SELECT * FROM wikidatawiki_p.wb_changes_subscription ORDER BY cs_row_id DESC LIMIT 25;
SQL

Checking query status...
