SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

SELECT tl_namespace, tl_title, COUNT(*)
  FROM templatelinks, page
 WHERE tl_from = page_id
   AND page_namespace = 4 AND page_title LIKE 'Articles_for_deletion/Log/%'
   AND NOT (tl_namespace = 4 AND tl_title REGEXP '^(Articles|Pages|Votes)_for_deletion/')
 GROUP BY tl_namespace, tl_title
     ;