Eloy spotted this query that might need some optimization

3) SELECT
            h.id AS id,
            h.name AS name,
            COUNT(*) AS count_attempts
        FROM
            hotpot h,
            hotpot_attempts a
        WHERE
            h.course = 34
            AND h.id = a.hotpot
            AND a.id = a.clickreportid
            AND a.starttime > 1187805492
        GROUP BY
            h.id, h.name;
    (not really often but happens)