SELECT 

    log.log_timestamp AS upload_timestamp,

    log.log_title AS upload_title,

    actor.actor_name AS uploader_username

FROM logging log

JOIN actor_logging actor ON log.log_actor = actor.actor_id

JOIN categorylinks cl ON cl.cl_from = log.log_page

JOIN templatelinks tl ON tl.tl_from = log.log_page

WHERE 

    log.log_type = 'upload' 

    AND log.log_action = 'upload'

    -- Filter uploads categorized under 'Uploaded_with_Mobile/Android'

    AND cl.cl_to = 'Uploaded_with_Mobile/Android'

    -- Filter uploads from the year 2025

    AND SUBSTRING(log.log_timestamp, 1, 4) = '2025'

    -- Ensure files are tagged with 'Wiki Loves Folklore 2025'

    AND tl.tl_namespace = 20

    AND tl.tl_title = 'Wiki_Loves_Folklore_2025';

​