SQL
x
USE dewiki_p;
SELECT page_title, count
FROM page
JOIN (
SELECT eu_page_id, COUNT(DISTINCT eu_entity_id) AS count
FROM wbc_entity_usage
GROUP BY eu_page_id
HAVING count >= 100
) AS pages ON eu_page_id = page_id
WHERE page_namespace = 0
ORDER BY count DESC
LIMIT 10;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.