Untitled query #82793

SQL

use commonswiki_p;

SELECT CONCAT("# {{#target:User_talk:", actor_name, "|commons.wikimedia.org}}") as line
FROM revision r_prev
join categorylinks on rev_page = cl_from
join actor on rev_actor = actor_id and actor_user is not null
WHERE rev_parent_id = 0
and cl_to IN (
   "Images_from_Wiki_Loves_Earth_2017_in_Bangladesh",
   "Images_from_Wiki_Loves_Earth_2018_in_Bangladesh",
   "Images_from_Wiki_Loves_Earth_2019_in_Bangladesh",
   "Images_from_Wiki_Loves_Earth_2020_in_Bangladesh",
   "Images_from_Wiki_Loves_Folklore_2020_in_Bangladesh",
   "Images_from_Wiki_Loves_Folklore_2021_in_Bangladesh",
   "Images_from_Wiki_Loves_Folklore_2022_in_Bangladesh",
   "Images_from_Wiki_Loves_Folklore_2023_in_Bangladesh",
   "Images_from_Wiki_Loves_Folklore_2024_in_Bangladesh",
   "Images_from_Wiki_Loves_Monuments_2016_in_Bangladesh",
   "Images_from_Wiki_Loves_Monuments_2017_in_Bangladesh",
   "Images_from_Wiki_Loves_Monuments_2018_in_Bangladesh",
   "Images_from_Wiki_Loves_Monuments_2019_in_Bangladesh",
   "Images_from_Wiki_Loves_Monuments_2020_in_Bangladesh",
   "Images_from_Wiki_Loves_Monuments_2022_in_Bangladesh",
   "Images_from_Wiki_Loves_Monuments_2023_in_Bangladesh"
)
GROUP BY actor_name
SQL

Checking query status...
