مساهمات مستخدم بالبايت *2

SQL

SELECT
  DISTINCT a.actor_name,
  #p.page_title,
  sum(
    r.rev_len - IFNULL(
      (
        SELECT DISTINCT parent.rev_len FROM revision parent WHERE r.rev_parent_id = parent.rev_id AND p.page_id = parent.rev_page
      ),
      0
    )
  ) AS byte_count,
  SUM(
    CASE
      WHEN r.rev_timestamp >= NOW() - INTERVAL 1 DAY THEN r.rev_len - IFNULL(
        (
          SELECT DISTINCT parent.rev_len FROM revision parent WHERE r.rev_parent_id = parent.rev_id AND p.page_id = parent.rev_id
        ),
        0
      )
      ELSE 0
    END
  ) AS byte_count_24h
FROM
  revision r
  INNER JOIN actor a ON r.rev_actor = a.actor_id
  INNER JOIN page p ON r.rev_page = p.page_id
WHERE
  p.page_namespace = 0
  AND r.rev_timestamp BETWEEN 20230901000000
  AND 20231201000000
  and a.actor_name not like _utf8 "%bot" collate utf8_general_ci #AND a.actor_name IN ('Mr. Ibrahem')
  #AND p.page_title IN ('انعدام_الجنسية_في_لبنان')
GROUP BY
  a.actor_name #, p.page_title
order by
  byte_count desc
limit
  20;
SQL

Checking query status...
