Size of uploads (in MiB)

Fork of Size of uploads by Gone Postal (in MiB) by Gone Postal

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

This count based purely on filename and uploader, a handy guide to size of the total size uploads presuming bot accounts are not the actual uploaders for some projects.

SQL

USE ruwikisource_p;
SELECT user_id, user_name, COUNT(*) AS num_edits
FROM revision
JOIN user ON revision_user = user.user_id -- полное имя поля revision_user
JOIN page ON revision.rev_page = page.page_id
WHERE page.page_namespace = 0  -- только основное пространство имён
AND page.page_is_redirect = 0  -- только статьи, не перенаправления
AND page.page_title IN (
    SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE '%/ru'
)  -- только статьи на русском языке
GROUP BY user_id
ORDER BY num_edits DESC
LIMIT 100

SQL

Checking query status...