Query take to long

[KhalDrogo1988]

Hi, this query :

        SELECT
            hlstats_Ribbons.awardCode AS ribbonCode,
            hlstats_Ribbons.ribbonName AS ribbonName,
            IF(ISNULL(hlstats_Players_Ribbons.playerId), 'noaward.png', hlstats_Ribbons.image) AS image,
            hlstats_Ribbons.special,
            hlstats_Ribbons.image AS imagefile,
            hlstats_Ribbons.awardCount
        FROM
            hlstats_Ribbons
        LEFT JOIN
        (
            SELECT
                hlstats_Players_Ribbons.playerId,
                hlstats_Ribbons.awardCode,
                hlstats_Players_Ribbons.ribbonId
            FROM
                hlstats_Players_Ribbons
            INNER JOIN
                hlstats_Ribbons
            ON
                hlstats_Ribbons.ribbonId = hlstats_Players_Ribbons.ribbonId
                AND hlstats_Ribbons.game = hlstats_Players_Ribbons.game
            WHERE
                hlstats_Players_Ribbons.playerId = ".$playerdata['playerId']."
                AND hlstats_Players_Ribbons.game = '$game'
            ORDER BY
                hlstats_Ribbons.awardCount DESC
        ) AS hlstats_Players_Ribbons
        ON
            hlstats_Players_Ribbons.ribbonId = hlstats_Ribbons.ribbonId
        WHERE
            hlstats_Ribbons.game = '$game'
            AND
            (
                ISNULL(hlstats_Players_Ribbons.playerId)
                OR hlstats_Players_Ribbons.playerId = ".$playerdata['playerId']."
            )
        ORDER BY
            hlstats_Ribbons.awardCode,
            hlstats_Players_Ribbons.playerId DESC,
            hlstats_Ribbons.special,
            hlstats_Ribbons.awardCount DESC

Took 52s on my database and cause 100% CPU usage by mysqld . Can this be more optimise ?