I currently have:
SELECT *, COUNT(*) AS counter
WHERE TO_DAYS(EventDate) - TO_DAYS(NOW()) >= 7;
ORDER BY EventDate
SELECT *, ( SELECT COUNT( * ) FROM events WHERE WEEK( EventDate ) = WEEK( NOW() ) ) as counter FROM events ORDER BY EventDate
Try this, hopefully it will select all the information and then as a sub-query count the total events for the week.