Untitled query #17833

SQL

USE kowiki_p;
SELECT "Korean Wikipedia";
SELECT SUM(eu_page_id IS NULL), COUNT(DISTINCT rc_id) 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), COUNT(DISTINCT rc_id) 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;
SQL

Checking query status...
