USE commonswiki_p;

SELECT rc.rc_title,

       rc.rc_cur_id,

       rc.rc_namespace,

       cl.cl_timestamp

       FROM recentchanges as rc

       INNER JOIN recentchanges AS rc_talk

             ON rc.rc_title = rc_talk.rc_title

             AND rc_talk.rc_type = 0

             AND rc.rc_namespace = (rc_talk.rc_namespace - (rc_talk.rc_namespace % 2))

       INNER JOIN categorylinks AS cl

             ON rc_talk.rc_cur_id = cl.cl_from

       WHERE cl.cl_to = "Images_from_Wiki_Loves_Monuments_2016_in_California"

       AND rc.rc_type = 0

       AND cl.cl_timestamp >= DATE_SUB(NOW(), INTERVAL 365 DAY)

       GROUP BY rc.rc_cur_id

       ORDER BY rc.rc_id DESC

       LIMIT 10