Untitled query #86598

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_Monuments_2017_in_Canada"
                "Images_from_Wiki_Loves_Monuments_2018_in_Canada"
                "Images_from_Wiki_Loves_Monuments_2019_in_Canada"
                "Images_from_Wiki_Loves_Monuments_2020_in_Canada"
                
              ) and not exists (
                SELECT 1
                FROM revision
                join categorylinks on rev_page = cl_form
                WHERE
                	rev_parent_id= 0 AND
                	rev_actor = r_previous.rev_actor AND
                	cl_to IN ("Images_from_Wiki_Loves_Monuments_2024_in_Canada")
                
              )
              GROUP BY actor_name
SQL

Checking query status...
