USE commonswiki_p;

 SELECT DISTINCT CONCAT ( "User talk:" , rev_user_text )

FROM revision_compat

INNER JOIN comment

 ON rev_comment_id = comment_id

WHERE comment_text LIKE "+1 POTY vote - eligible on%" # on rev comment, so we don't have to inner join "page" table

AND rev_timestamp > DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -180 DAY), '%Y%m%d%H%i%s')

AND rev_user_text NOT IN ( # voted in R2 yet

                            SELECT DISTINCT rc_user_text AS rev_user_text

                            FROM recentchanges_compat

                            WHERE rc_title LIKE "Picture_of_the_Year/2019/R2/v/%"

                          )

#AND rev_user_text NOT IN ("PaulMison", "Dishita Bhowmik", "Armin3636", "Kanderal07", "Wikiman131313", "Ptitouti", "Student2971", "Prco 2703", "Falling asleep", "Giorgi Babuts", "Saad Ali Khan Pakistan", "Kotleopold140", "4nn1l2test", "Nikey05", "Ilsonmaster", "Joaoescobar", "Ldaniel27721", "VladOz") #not eligible 

ORDER BY rev_user_text ASC; #sort abc