WikiLovesBangla 2024 - Contributor List with Upload Counts

SQL

SELECT actor_name as User, count(actor_name) as uploadCount 
FROM 
    (SELECT DISTINCT log_id, log_actor, log_page, log_type, log_action, actor_id, actor_user, actor_name 
        FROM logging_logindex 
        WHERE (DATE(log_timestamp) BETWEEN '2024-01-15' and '2024-02-14')
        ) AS ulog 
JOIN actor_logging as alog ON ulog.log_actor=alog.actor_id
JOIN templatelinks ON tl_from=log_page
JOIN categorylinks ON cl_from=log_page 
WHERE 
    -- only uploads
        log_type='upload'
    AND log_action='upload' 
    
    -- only WLF India uploads
and cl_to IN (
   "Images_from_Wiki_Loves_Bangla_2024"
)

 GROUP BY actor_name

SQL

Checking query status...