Commons:Database reports/Upload log stats/All
All upload logs edit
Top 300 users with the most upload log entries. Data as of {{{1}}}. See also mw:Manual:Log actions
sql used |
---|
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;
|