Get WordPress author post counts, within a date range, regardless of current access level

getAuthorPostCounts.sql

SELECT u.ID, u.display_name, COUNT(*) 
FROM wp_posts p
RIGHT JOIN wp_users u ON p.post_author = u.ID
	WHERE p.post_type = 'post'
	AND p.post_status = 'publish'
	AND p.post_date > '2017-11-01 00:00:00'
	AND p.post_date < '2018-11-01 00:00:00'
  -- Add any exclusions below
  -- AND p.post_author NOT IN (8962, 90013, 9256, 52277)
GROUP BY u.display_name