Site Is So Slow!

[eluser]Jay Logan[/eluser]
OK so 1 page that appears to run particularly slow is a page that shows all the events for a meet and counts how many athletes are participating in that event. Some meets have 40 events or more so I would imagine that kind of query could tax my server a bit. Is there any obvious bad practice with the code I use below for my model?

Code:

function get_events_extended($meet_id, $coach_id)
    {
        
        $result = $this->db->query(
            "SELECT Meet_Event.*, Event.*, COUNT(Meet_Athlete.id) AS Total, ".
                "COUNT(Coach.id) AS Coach ".
                "FROM meet_events AS Meet_Event ".
                "LEFT JOIN events AS Event ".
                    "ON Meet_Event.event_id = Event.id ".
                "LEFT JOIN meet_athletes AS Meet_Athlete ".
                    "ON Meet_Event.id = Meet_Athlete.meet_event_id ".
                "LEFT JOIN athletes AS Athlete ".
                    "ON Meet_Athlete.athlete_id = Athlete.id ".
                "LEFT JOIN roster AS Roster ".
                    "ON Roster.athlete_id = Athlete.id ".
                "Left Join coaches AS Coach ".
                    "ON Roster.coach_id = Coach.id AND Coach.id = ? ".
                "WHERE Meet_Event.meet_id = ? ".
                "GROUP BY Meet_Event.id ".
                "ORDER BY Event.type DESC, Event.name ASC, Meet_Event.gender ASC",
            array(
                $coach_id,
                $meet_id
            )
        );
        return $this->clean_result($result);
    }