SELECT page_title, rev_timestamp

  FROM page, revision

 WHERE page_namespace = 0

   AND page_id = rev_page

   AND rev_parent_id = 0

   AND rev_timestamp > REPLACE(DATE_SUB(CURDATE(), INTERVAL 1 WEEK), '-', '')

/* SELECT LK.page_title, WG.page_title

  FROM page AS LK, pagelinks, linktarget, page as WG

 WHERE LK.page_namespace = 4

   AND LK.page_title LIKE "Löschkandidaten%"

   AND pl_from = LK.page_id

   AND pl_target_id = lt_id

   AND lt_namespace = 0

   AND lt_title = WG.page_title

   AND lt_namespace = WG.page_title

*/