#/users and #/afds on June 20 each year

For June 20 of each year, count:
* The total number of afd pages transcluded onto [[Wikipedia:Articles for deletion/Log/{{{year}}}_June_20]]
* The total number of different users who've edited at least one of those transcluded afd pages
* The average number of different users who've edited each of those transcluded afd pages.

Excludes bots (that have a bot flag).

SQL

WITH transcluded AS
(SELECT page_title AS dailylog_title, tl_title AS afd_title
 FROM templatelinks
 JOIN page ON page_id = tl_from
 WHERE tl_namespace = 4
   AND (tl_title LIKE 'Articles\_for\_deletion/%'
        OR tl_title LIKE 'Votes\_for\_deletion/%')
   AND page_namespace = 4
   AND page_title LIKE 'Articles\_for\_deletion/Log/20__\_June\_20')
SELECT MID(dailylog_title, 27, 4) AS afd_year, COUNT(DISTINCT rev_actor), COUNT(DISTINCT afd_title)
FROM page AS afd_page
JOIN transcluded ON afd_page.page_namespace = 4 AND afd_page.page_title = transcluded.afd_title
JOIN revision ON rev_page = afd_page.page_id
GROUP BY afd_year;

SQL

Checking query status...