WLM uploads via Commons Android App

Fork of WLM uploads via Commons Android App by Martin Urbanec

This query is marked as a draft This query has been published by Misaochan.

SQL

SELECT
    log_timestamp AS upload_timestamp,
    log_title AS upload_title,
    actor_name AS uploader_username
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'
    
    -- only commonsapp uploads
    AND cl_to='Uploaded_with_Mobile/Android'
    
    -- only 2021 uploads
    AND log_timestamp LIKE '2021%'
    
    -- only WLM uploads
    AND tl_namespace=10
    AND tl_title='Wiki_Loves_Monuments_2021'

SQL

Checking query status...