Wikidata usage in cswiki

SQL

USE wikidatawiki_p;
SELECT COUNT(*) FROM cswiki_p.wbc_entity_usage;

DESCRIBE cswiki_p.wbc_entity_usage;
/*
SELECT eu_entity_id, change_time, GROUP_CONCAT(DISTINCT page2.page_title SEPARATOR ', ')
	FROM wb_changes
	JOIN (SELECT * FROM user WHERE user_name = "Matěj Suchánek") AS user
		ON user.user_id = change_user_id
	JOIN revision
		ON rev_id = change_revision_id
	JOIN page AS page1
		ON page1.page_id = rev_page
	JOIN cswiki_p.wbc_entity_usage
		ON eu_entity_id = page1.page_title
	JOIN (SELECT * FROM cswiki_p.page WHERE page_namespace = 0) AS page2
		ON page2.page_id = eu_page_id
GROUP BY eu_entity_id
ORDER BY change_time DESC
LIMIT 50;

SELECT page_title, COUNT(DISTINCT eu_entity_id), COUNT(eu_aspect), eu_touched
	FROM cswiki_p.wbc_entity_usage
	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;*/
SQL

Checking query status...
