Added left join so reports without media would also be displayed.