I AM using the logic you and Jochem suggest in the query, I am not performing any joins. I query for certain criteria re the start and end dates held in the database, and once I have my set I then work with it dynamically as I need to know, based on the event frequency, how many events from that range fall on dates within the user range.
