Commons:Database reports/Upload log stats/All
Jump to navigation
Jump to search
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;
|