SELECT 

    YEAR(creation.rev_timestamp) AS year,

    COUNT(*) AS nomination_count

FROM page

JOIN revision AS creation

    ON page.page_id = creation.rev_page

    AND creation.rev_parent_id = 0

WHERE page.page_namespace = 4

    AND page.page_title LIKE 'Articles_for_deletion/%'

    AND creation.rev_timestamp >= DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 5 YEAR), '%Y%m%d%H%i%s')

GROUP BY year

ORDER BY year;