USE kowiki_p;

SELECT "Korean Wikipedia";

SELECT SUM(eu_page_id IS NULL) AS changes_wo_entity_usage, COUNT(DISTINCT rc_id) AS changes FROM recentchanges LEFT JOIN wbc_entity_usage ON rc_cur_id = eu_page_id;

SELECT eu_aspect, COUNT(*), COUNT(DISTINCT eu_page_id) FROM wbc_entity_usage GROUP BY 1;

​

SELECT "----More Active than Korean Wikipedia----";

USE eswiki_p;

SELECT "Spanish Wikipedia";

SELECT SUM(eu_page_id IS NULL) AS changes_wo_entity_usage, COUNT(DISTINCT rc_id) AS changes FROM recentchanges LEFT JOIN wbc_entity_usage ON rc_cur_id = eu_page_id;

SELECT eu_aspect, COUNT(*), COUNT(DISTINCT eu_page_id) FROM wbc_entity_usage GROUP BY 1;

​

USE dewiki_p;

SELECT "German Wikipedia";

SELECT SUM(eu_page_id IS NULL) AS changes_wo_entity_usage, COUNT(DISTINCT rc_id) AS changes FROM recentchanges LEFT JOIN wbc_entity_usage ON rc_cur_id = eu_page_id;

SELECT eu_aspect, COUNT(*), COUNT(DISTINCT eu_page_id) FROM wbc_entity_usage GROUP BY 1;

​

USE plwiki_p;

SELECT "Portuguese Wikipedia";

SELECT SUM(eu_page_id IS NULL) AS changes_wo_entity_usage, COUNT(DISTINCT rc_id) AS changes FROM recentchanges LEFT JOIN wbc_entity_usage ON rc_cur_id = eu_page_id;

SELECT eu_aspect, COUNT(*), COUNT(DISTINCT eu_page_id) FROM wbc_entity_usage GROUP BY 1;

​

​

SELECT "----Less Active than Korean Wikipedia----";

USE elwiki_p;

SELECT "Greek Wikipedia";

SELECT SUM(eu_page_id IS NULL) AS changes_wo_entity_usage, COUNT(DISTINCT rc_id) AS changes FROM recentchanges LEFT JOIN wbc_entity_usage ON rc_cur_id = eu_page_id;

SELECT eu_aspect, COUNT(*), COUNT(DISTINCT eu_page_id) FROM wbc_entity_usage GROUP BY 1;

​

USE trwiki_p;

SELECT "Turkish Wikipedia";

SELECT SUM(eu_page_id IS NULL) AS changes_wo_entity_usage, COUNT(DISTINCT rc_id) AS changes FROM recentchanges LEFT JOIN wbc_entity_usage ON rc_cur_id = eu_page_id;

SELECT eu_aspect, COUNT(*), COUNT(DISTINCT eu_page_id) FROM wbc_entity_usage GROUP BY 1;

​

​