mysql> select e.name, count(p.event), e.date, e.events, count(c.id) from events e left join pictures p on p.event=e.events left join comments c on c.picture=p.id group by e.events order by e.date desc;
+---------------------------------+----------------+------------+--------+-------------+
|...