SELECT

  page_title,

  rev_timestamp

FROM

  page

  JOIN revision ON page_id = rev_page

  LEFT JOIN linktarget ON lt_title = page_title

  AND lt_namespace = page_namespace

  LEFT JOIN pagelinks ON pl_target_id = lt_id

  LEFT JOIN templatelinks ON tl_target_id = lt_id

WHERE

  page_namespace = 4

  AND page_is_redirect = 0

  AND page_title LIKE "Articles_for_deletion/%"

  AND rev_parent_id = 0

  AND ISNULL(tl_from)

  AND ISNULL(pl_from);