SELECT
 actor_image.actor_name AS username,
 COUNT(logging.log_id) AS count
FROM logging
INNER JOIN actor_image
 ON log_actor = actor_id
WHERE logging.log_type = "upload"
GROUP BY actor_image.actor_name
ORDER BY COUNT(actor_image.actor_name) DESC
LIMIT 300;

SELECT
 actor_image.actor_name AS username,
 COUNT(logging.log_id) AS count
FROM logging
INNER JOIN actor_image
 ON log_actor = actor_id
WHERE logging.log_type = "upload"
AND logging.log_action = "overwrite"
GROUP BY actor_image.actor_name
ORDER BY COUNT(actor_image.actor_name) DESC
LIMIT 200;

SELECT
 actor_image.actor_name AS username,
 COUNT(logging.log_id) AS count
FROM logging
INNER JOIN actor_image
 ON log_actor = actor_id
WHERE logging.log_type = "upload"
AND logging.log_action = "upload"
GROUP BY actor_image.actor_name
ORDER BY COUNT(actor_image.actor_name) DESC
LIMIT 200;