added query to fetch songs by event id through link table