Wikidata usage in cswiki

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;
SQL

Checking query status...
