Untitled query #48294

SQL

USE bnwiki_p;

-- Re-format wikitable: `(\d+)\.0\|\|(\S[^|]+)`
-- Replace: `$1 || [[User:$2|$2]] `

SELECT actor_name, upload_count
, upload_count_i as upload_count_intial
, (upload_count + upload_count_i) as upload_count_total
FROM
-- next files uploads
(
  SELECT actor_name, upload_count, IFNULL(upload_count_i, 0) as upload_count_i
  FROM
  (
    SELECT count(*) as upload_count, log_actor
    FROM logging_logindex 
    WHERE log_type = 'files uploaded' AND log_action = 'files uploaded'
    GROUP BY log_actor
  ) r_next
  -- add initial uploaded
  LEFT JOIN
  (
    SELECT count(*) as upload_count_i, log_actor as log_actor_i
    FROM logging_logindex
    WHERE log_type = 'files uploaded' AND log_action = 'files uploaded-i'
    GROUP BY log_actor
  ) r_initial ON log_actor_i = log_actor
  -- actor_name  
  LEFT JOIN actor_logging a ON actor_id = log_actor
) top_uploader
ORDER BY upload_count DESC, upload_count_i DESC
SQL

Checking query status...
