WLF India uploads

SQL

SELECT CONCAT("# {{#target:User_talk:", actor_name, "|commons.wikimedia.org}}") as line
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 WLF India uploads
and cl_to IN (
   "Images_from_Wiki_Loves_Food_2021_in_India",
   "Images_from_Wiki_Loves_Food_2015"
)

 GROUP BY actor_name

​x
 
SELECT CONCAT("# {{#target:User_talk:", actor_name, "|commons.wikimedia.org}}") as lineFROM logging_logindexJOIN actor_logging ON log_actor=actor_idJOIN templatelinks ON tl_from=log_pageJOIN categorylinks ON cl_from=log_pageWHERE    -- only uploads        log_type='upload'    AND log_action='upload'        -- only WLF India uploadsand cl_to IN (   "Images_from_Wiki_Loves_Food_2021_in_India",   "Images_from_Wiki_Loves_Food_2015")​ GROUP BY actor_name

SQL

Checking query status...