USE tewiki_p;

​

SELECT COUNT(*), COUNT(DISTINCT eu_page_id), COUNT(DISTINCT eu_entity_id) FROM wbc_entity_usage;

​

SELECT page_title, page_namespace, page_id, eu_entity_id, GROUP_CONCAT(DISTINCT eu_aspect SEPARATOR ', ') AS aspects,

    eu_touched, rev_timestamp AS last_edited

    FROM wbc_entity_usage

    JOIN page ON page_id = eu_page_id

    LEFT JOIN revision ON rev_id = page_latest

GROUP BY eu_touched, eu_page_id, eu_entity_id

ORDER BY eu_row_id DESC

LIMIT 25;

​

SELECT page_title, page_namespace, GROUP_CONCAT(DISTINCT wbc2.eu_entity_id SEPARATOR ', ') AS entities, rc_title AS item,

    wbc1.eu_touched, rc_timestamp, rev_timestamp AS last_edited

    FROM (SELECT * FROM wikidatawiki_p.recentchanges WHERE rc_namespace = 0 AND rc_log_type IS NULL) AS rc

    JOIN wbc_entity_usage AS wbc1 ON wbc1.eu_entity_id = rc_title AND wbc1.eu_touched >= rc_timestamp

    JOIN wbc_entity_usage AS wbc2 ON wbc2.eu_page_id = wbc1.eu_page_id

    JOIN page ON page_id = wbc2.eu_page_id

    JOIN revision ON rev_id = page_latest AND rev_timestamp < rc_timestamp

GROUP BY wbc2.eu_page_id HAVING COUNT(DISTINCT wbc2.eu_entity_id) > 2

ORDER BY MAX(wbc2.eu_row_id) DESC

LIMIT 25;

​

SELECT rc_title, GROUP_CONCAT(DISTINCT eu_entity_id SEPARATOR ', ') AS entities, rc_timestamp

    FROM (SELECT * FROM recentchanges WHERE rc_source = "mw.edit") AS changes

    JOIN wbc_entity_usage ON eu_page_id = rc_cur_id

WHERE eu_touched = rc_timestamp 

GROUP BY eu_touched, eu_page_id HAVING COUNT(DISTINCT eu_entity_id) > 2

ORDER BY MAX(eu_row_id) DESC

LIMIT 25;

​

SELECT page_title, COUNT(DISTINCT eu_entity_id), COUNT(eu_aspect), eu_touched

    FROM wbc_entity_usage

    JOIN page ON page_id = eu_page_id

GROUP BY eu_page_id HAVING COUNT(DISTINCT eu_entity_id) > 25

ORDER BY COUNT(DISTINCT eu_entity_id) DESC, COUNT(eu_aspect) DESC, page_title;

​

SELECT eu_entity_id, COUNT(DISTINCT eu_page_id)

    FROM wbc_entity_usage

GROUP BY eu_entity_id HAVING COUNT(DISTINCT eu_page_id) > 250

ORDER BY COUNT(DISTINCT eu_page_id) DESC;