اردو ویکیپیڈیا صارفین بلحاظ بائٹس (مرکزی نام فضا)

SQL

SELECT actor_name, SUM(rev_len) as bytes
FROM revision
JOIN actor_revision ON rev_actor = actor_id
JOIN page ON rev_page = page_id
WHERE
	rev_parent_id = 0
    AND page_namespace = 0
    AND page_is_redirect=0
    AND rev_deleted=0
GROUP BY actor_id
ORDER BY bytes DESC
LIMIT 100;
SELECT actor_name,
       SUM(b.rev_len - COALESCE(a.rev_len, 0)) AS bytes
FROM revision_userindex b
LEFT JOIN revision a ON a.rev_id = b.rev_parent_id
JOIN actor_revision on actor_id = b.rev_actor
JOIN page ON page_id = a.rev_page
WHERE page_namespace = 0
AND page_is_redirect=0
AND b.rev_deleted=0 AND a.rev_deleted=0
AND rev_timestamp > DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 1 DAY)
GROUP BY actor_id
ORDER BY bytes DESC
LIMIT 100;

SQL

Checking query status...