cleaning up some SQL queries and adding committee only event type