Untitled query #86617

This query is marked as a draft This query has been published by Karl Oblique.

SQL

SELECT rev_user_text AS editor, COUNT(*) AS edit_count
FROM wbc_entity_usage
JOIN revision ON eu_entity_id = rev_page
JOIN page ON page_id = rev_page
JOIN wb_items_per_site ON eu_entity_id = ips_item_id

WHERE
  AND page_namespace = 0 -- Limit to items
GROUP BY rev_user_text
ORDER BY edit_count DESC
LIMIT 50;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...