WikiLovesBangla 2024 - Contributor List with Upload Counts

SQL

SELECT actor_name as Username, count(actor_name) as uploadCount
    FROM (

        SELECT DISTINCT log_id, actor_name 
        FROM logging_logindex
        JOIN actor_logging ON log_actor=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'
      -- timeframe of competition (in BD time after adjusting timezone and grace hours)
            AND (DATE(log_timestamp) BETWEEN '2024-01-14 18:00:00' and '2024-02-15 09:00:00')
            
            -- only WLB uploads
        and cl_to IN (
           "Images_from_Wiki_Loves_Bangla_2024"
        )
    ) AS data 

GROUP BY actor_name

SQL

Checking query status...