SELECT

  page_title,

  rev_timestamp

FROM

  page

  JOIN revision ON page_id = rev_page

  LEFT JOIN pagelinks ON pl_title = page_title

  AND pl_namespace = page_namespace

  /* FIXME JOIN linktarget */

  LEFT JOIN templatelinks ON tl_title = page_title

  AND tl_namespace = page_namespace

WHERE

  page_namespace = 4

  AND page_is_redirect = 0

  AND page_title LIKE "Articles_for_deletion/%"

  AND rev_parent_id = 0

  AND ISNULL(pl_namespace)

  AND ISNULL(tl_namespace);