WITH freqs(f_page, f_title, f_count) AS

(

  SELECT page_id, rc_title, COUNT(*)

  FROM recentchanges

  JOIN page ON page_namespace = rc_namespace AND page_title = rc_title

  WHERE rc_namespace = 1

  GROUP BY rc_title

  HAVING COUNT(*) >= 10

)

SELECT f_title, f_count

FROM freqs

LEFT JOIN templatelinks ON tl_from = f_page

LEFT JOIN linktarget ON lt_id = tl_target_id AND lt_namespace = 2 AND lt_title IN ('ClueBot III/ArchiveThis', 'MiszaBot/config')

WHERE tl_from IS NULL

ORDER BY f_count DESC;