Summary Selection

    public function rankingSummary($lb = 0)
    {
        $temp = "temp_summary";
        $board = "classic_summary";
        if ($lb == 1) {
            $board = "express_summary";
        }
        if ($lb != 2) {
            $sql = "
                DROP TABLE IF EXISTS ".$temp.";
                CREATE TABLE ".$temp."
                (
                    rank INT NOT NULL AUTO_INCREMENT,
                    steamID INT NOT NULL,
                    dataID INT NOT NULL,
                    PRIMARY KEY (rank)
                );
                SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ;
                INSERT INTO ".$temp." (steamID , dataID)
                SELECT a.steamID, a.id FROM player_data a RIGHT JOIN (SELECT steamID, MAX(score) max_score FROM player_data p LEFT JOIN match_data m ON p.matchID = m.matchID WHERE m.version = '".VERSION."' and m.mode = ".$lb." and cheat = 0 GROUP BY steamID) b ON a.steamID = b.steamID AND a.score = b.max_score ORDER BY score DESC;
                RENAME TABLE ".$board." TO temp, ".$temp." TO ".$board.", temp TO ".$temp.";
                COMMIT ;
            ";
        }
        if ($lb == 2) {
            $board = "frogs_summary";
            $sql = "
                DROP TABLE IF EXISTS ".$temp.";
                CREATE TABLE ".$temp."
                (
                    rank INT NOT NULL AUTO_INCREMENT,
                    steamID INT NOT NULL,
                    dataID INT NOT NULL,
                    PRIMARY KEY (rank)
                );
                SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ;
                INSERT INTO ".$temp." (steamID , dataID)
                SELECT a.steamID, a.id FROM player_data a RIGHT JOIN (SELECT steamID, MAX(icefrog_kills) max_frogs FROM player_data p LEFT JOIN match_data m ON p.matchID = m.matchID WHERE m.version = '".VERSION."' and m.mode = 0 and cheat = 0 GROUP BY steamID) b ON a.steamID = b.steamID AND a.icefrog_kills = b.max_frogs ORDER BY icefrog_kills DESC;
                RENAME TABLE ".$board." TO temp, ".$temp." TO ".$board.", temp TO ".$temp.";
                COMMIT ;
            ";
        }
        $query = $this->db->prepare($sql);
        $query->execute();
    }