SELECT *

       FROM recentchanges as rc

       INNER JOIN recentchanges AS rc_talk

             ON rc.rc_title = rc_talk.rc_title

             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 = 'Wikipedians_with_PhD_degrees'

       AND cl.cl_timestamp >= DATE_SUB(NOW(), INTERVAL 24 HOUR)

       GROUP BY rc.rc_cur_id

       ORDER BY rc.rc_id DESC

       LIMIT 10