اردو ویکی صارفین بلحاظ بائٹس (مرکزی نام فضا، اکتوبر 2018ء)

SQL

USE urwiki_p; 

SELECT actor_name, 
SUM(CAST(rev.rev_len as signed)-CAST(parent.rev_len as signed)) AS byte_count
FROM actor
JOIN revision rev ON actor_id = rev.rev_actor
JOIN revision parent ON rev.rev_parent_id = parent.rev_id
JOIN page ON page_id = parent.rev_page
JOIN user ON user_id = actor_id
WHERE page_namespace = 0 
AND rev.rev_timestamp >= 20040101000000
AND rev.rev_timestamp <= CURRENT_TIMESTAMP
AND parent.rev_timestamp <= CURRENT_TIMESTAMP
AND actor_name NOT IN(  
  SELECT ug_user FROM user_groups 
  WHERE ug_group = 'bot')
GROUP BY actor_name
ORDER BY byte_count DESC
LIMIT 100

SQL

Checking query status...