"pg" (27 ms)
(
    SELECT
        'match_players.kills' AS what,
        match_players.kills AS amount,
        match_teams.result,
        matches.id,
        matches.DATE,
        matches.gamemode,
        match_players.champion_id
    FROM
        match_players
        INNER JOIN matches ON matches.id = match_players.match_id
        INNER JOIN match_teams ON match_players.match_id = match_teams.match_id
        AND match_players.team = match_teams.color
    WHERE
        match_players.summoner_puuid = 'EdlDRRAPVUAYf9iDPF9iKNyF-6rkpnXXBLiF4VUfcPYZXV9xaiQsgGKiaIz4IgBX3JCiL_oS5fmXAQ'
        AND match_teams.result != 'Remake'
        AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
    ORDER BY
        match_players.kills DESC,
        matches.id
    LIMIT
        1
)
UNION ALL
    (
        SELECT
            'match_players.deaths' AS what,
            match_players.deaths AS amount,
            match_teams.result,
            matches.id,
            matches.DATE,
            matches.gamemode,
            match_players.champion_id
        FROM
            match_players
            INNER JOIN matches ON matches.id = match_players.match_id
            INNER JOIN match_teams ON match_players.match_id = match_teams.match_id
            AND match_players.team = match_teams.color
        WHERE
            match_players.summoner_puuid = 'EdlDRRAPVUAYf9iDPF9iKNyF-6rkpnXXBLiF4VUfcPYZXV9xaiQsgGKiaIz4IgBX3JCiL_oS5fmXAQ'
            AND match_teams.result != 'Remake'
            AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
        ORDER BY
            match_players.deaths DESC,
            matches.id
        LIMIT
            1
    )
UNION ALL
    (
        SELECT
            'match_players.assists' AS what,
            match_players.assists AS amount,
            match_teams.result,
            matches.id,
            matches.DATE,
            matches.gamemode,
            match_players.champion_id
        FROM
            match_players
            INNER JOIN matches ON matches.id = match_players.match_id
            INNER JOIN match_teams ON match_players.match_id = match_teams.match_id
            AND match_players.team = match_teams.color
        WHERE
            match_players.summoner_puuid = 'EdlDRRAPVUAYf9iDPF9iKNyF-6rkpnXXBLiF4VUfcPYZXV9xaiQsgGKiaIz4IgBX3JCiL_oS5fmXAQ'
            AND match_teams.result != 'Remake'
            AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
        ORDER BY
            match_players.assists DESC,
            matches.id
        LIMIT
            1
    )
UNION ALL
    (
        SELECT
            'match_players.gold' AS what,
            match_players.gold AS amount,
            match_teams.result,
            matches.id,
            matches.DATE,
            matches.gamemode,
            match_players.champion_id
        FROM
            match_players
            INNER JOIN matches ON matches.id = match_players.match_id
            INNER JOIN match_teams ON match_players.match_id = match_teams.match_id
            AND match_players.team = match_teams.color
        WHERE
            match_players.summoner_puuid = 'EdlDRRAPVUAYf9iDPF9iKNyF-6rkpnXXBLiF4VUfcPYZXV9xaiQsgGKiaIz4IgBX3JCiL_oS5fmXAQ'
            AND match_teams.result != 'Remake'
            AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
        ORDER BY
            match_players.gold DESC,
            matches.id
        LIMIT
            1
    )
UNION ALL
    (
        SELECT
            'matches.game_duration' AS what,
            matches.game_duration AS amount,
            match_teams.result,
            matches.id,
            matches.DATE,
            matches.gamemode,
            match_players.champion_id
        FROM
            match_players
            INNER JOIN matches ON matches.id = match_players.match_id
            INNER JOIN match_teams ON match_players.match_id = match_teams.match_id
            AND match_players.team = match_teams.color
        WHERE
            match_players.summoner_puuid = 'EdlDRRAPVUAYf9iDPF9iKNyF-6rkpnXXBLiF4VUfcPYZXV9xaiQsgGKiaIz4IgBX3JCiL_oS5fmXAQ'
            AND match_teams.result != 'Remake'
            AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
        ORDER BY
            matches.game_duration DESC,
            matches.id
        LIMIT
            1
    )
UNION ALL
    (
        SELECT
            'match_players.minions' AS what,
            match_players.minions AS amount,
            match_teams.result,
            matches.id,
            matches.DATE,
            matches.gamemode,
            match_players.champion_id
        FROM
            match_players
            INNER JOIN matches ON matches.id = match_players.match_id
            INNER JOIN match_teams ON match_players.match_id = match_teams.match_id
            AND match_players.team = match_teams.color
        WHERE
            match_players.summoner_puuid = 'EdlDRRAPVUAYf9iDPF9iKNyF-6rkpnXXBLiF4VUfcPYZXV9xaiQsgGKiaIz4IgBX3JCiL_oS5fmXAQ'
            AND match_teams.result != 'Remake'
            AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
        ORDER BY
            match_players.minions DESC,
            matches.id
        LIMIT
            1
    )
UNION ALL
    (
        SELECT
            'match_players.kda' AS what,
            match_players.kda AS amount,
            match_teams.result,
            matches.id,
            matches.DATE,
            matches.gamemode,
            match_players.champion_id
        FROM
            match_players
            INNER JOIN matches ON matches.id = match_players.match_id
            INNER JOIN match_teams ON match_players.match_id = match_teams.match_id
            AND match_players.team = match_teams.color
        WHERE
            match_players.summoner_puuid = 'EdlDRRAPVUAYf9iDPF9iKNyF-6rkpnXXBLiF4VUfcPYZXV9xaiQsgGKiaIz4IgBX3JCiL_oS5fmXAQ'
            AND match_teams.result != 'Remake'
            AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
        ORDER BY
            match_players.kda DESC,
            matches.id
        LIMIT
            1
    )
UNION ALL
    (
        SELECT
            'match_players.damage_taken' AS what,
            match_players.damage_taken AS amount,
            match_teams.result,
            matches.id,
            matches.DATE,
            matches.gamemode,
            match_players.champion_id
        FROM
            match_players
            INNER JOIN matches ON matches.id = match_players.match_id
            INNER JOIN match_teams ON match_players.match_id = match_teams.match_id
            AND match_players.team = match_teams.color
        WHERE
            match_players.summoner_puuid = 'EdlDRRAPVUAYf9iDPF9iKNyF-6rkpnXXBLiF4VUfcPYZXV9xaiQsgGKiaIz4IgBX3JCiL_oS5fmXAQ'
            AND match_teams.result != 'Remake'
            AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
        ORDER BY
            match_players.damage_taken DESC,
            matches.id
        LIMIT
            1
    )
UNION ALL
    (
        SELECT
            'match_players.damage_dealt_champions' AS what,
            match_players.damage_dealt_champions AS amount,
            match_teams.result,
            matches.id,
            matches.DATE,
            matches.gamemode,
            match_players.champion_id
        FROM
            match_players
            INNER JOIN matches ON matches.id = match_players.match_id
            INNER JOIN match_teams ON match_players.match_id = match_teams.match_id
            AND match_players.team = match_teams.color
        WHERE
            match_players.summoner_puuid = 'EdlDRRAPVUAYf9iDPF9iKNyF-6rkpnXXBLiF4VUfcPYZXV9xaiQsgGKiaIz4IgBX3JCiL_oS5fmXAQ'
            AND match_teams.result != 'Remake'
            AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
        ORDER BY
            match_players.damage_dealt_champions DESC,
            matches.id
        LIMIT
            1
    )
UNION ALL
    (
        SELECT
            'match_players.damage_dealt_objectives' AS what,
            match_players.damage_dealt_objectives AS amount,
            match_teams.result,
            matches.id,
            matches.DATE,
            matches.gamemode,
            match_players.champion_id
        FROM
            match_players
            INNER JOIN matches ON matches.id = match_players.match_id
            INNER JOIN match_teams ON match_players.match_id = match_teams.match_id
            AND match_players.team = match_teams.color
        WHERE
            match_players.summoner_puuid = 'EdlDRRAPVUAYf9iDPF9iKNyF-6rkpnXXBLiF4VUfcPYZXV9xaiQsgGKiaIz4IgBX3JCiL_oS5fmXAQ'
            AND match_teams.result != 'Remake'
            AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
        ORDER BY
            match_players.damage_dealt_objectives DESC,
            matches.id
        LIMIT
            1
    )
UNION ALL
    (
        SELECT
            'match_players.kp' AS what,
            match_players.kp AS amount,
            match_teams.result,
            matches.id,
            matches.DATE,
            matches.gamemode,
            match_players.champion_id
        FROM
            match_players
            INNER JOIN matches ON matches.id = match_players.match_id
            INNER JOIN match_teams ON match_players.match_id = match_teams.match_id
            AND match_players.team = match_teams.color
        WHERE
            match_players.summoner_puuid = 'EdlDRRAPVUAYf9iDPF9iKNyF-6rkpnXXBLiF4VUfcPYZXV9xaiQsgGKiaIz4IgBX3JCiL_oS5fmXAQ'
            AND match_teams.result != 'Remake'
            AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
        ORDER BY
            match_players.kp DESC,
            matches.id
        LIMIT
            1
    )
UNION ALL
    (
        SELECT
            'match_players.vision_score' AS what,
            match_players.vision_score AS amount,
            match_teams.result,
            matches.id,
            matches.DATE,
            matches.gamemode,
            match_players.champion_id
        FROM
            match_players
            INNER JOIN matches ON matches.id = match_players.match_id
            INNER JOIN match_teams ON match_players.match_id = match_teams.match_id
            AND match_players.team = match_teams.color
        WHERE
            match_players.summoner_puuid = 'EdlDRRAPVUAYf9iDPF9iKNyF-6rkpnXXBLiF4VUfcPYZXV9xaiQsgGKiaIz4IgBX3JCiL_oS5fmXAQ'
            AND match_teams.result != 'Remake'
            AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
        ORDER BY
            match_players.vision_score DESC,
            matches.id
        LIMIT
            1
    )
UNION ALL
    (
        SELECT
            'match_players.critical_strike' AS what,
            match_players.critical_strike AS amount,
            match_teams.result,
            matches.id,
            matches.DATE,
            matches.gamemode,
            match_players.champion_id
        FROM
            match_players
            INNER JOIN matches ON matches.id = match_players.match_id
            INNER JOIN match_teams ON match_players.match_id = match_teams.match_id
            AND match_players.team = match_teams.color
        WHERE
            match_players.summoner_puuid = 'EdlDRRAPVUAYf9iDPF9iKNyF-6rkpnXXBLiF4VUfcPYZXV9xaiQsgGKiaIz4IgBX3JCiL_oS5fmXAQ'
            AND match_teams.result != 'Remake'
            AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
        ORDER BY
            match_players.critical_strike DESC,
            matches.id
        LIMIT
            1
    )
UNION ALL
    (
        SELECT
            'match_players.time_spent_living' AS what,
            match_players.time_spent_living AS amount,
            match_teams.result,
            matches.id,
            matches.DATE,
            matches.gamemode,
            match_players.champion_id
        FROM
            match_players
            INNER JOIN matches ON matches.id = match_players.match_id
            INNER JOIN match_teams ON match_players.match_id = match_teams.match_id
            AND match_players.team = match_teams.color
        WHERE
            match_players.summoner_puuid = 'EdlDRRAPVUAYf9iDPF9iKNyF-6rkpnXXBLiF4VUfcPYZXV9xaiQsgGKiaIz4IgBX3JCiL_oS5fmXAQ'
            AND match_teams.result != 'Remake'
            AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
        ORDER BY
            match_players.time_spent_living DESC,
            matches.id
        LIMIT
            1
    )
UNION ALL
    (
        SELECT
            'match_players.heal' AS what,
            match_players.heal AS amount,
            match_teams.result,
            matches.id,
            matches.DATE,
            matches.gamemode,
            match_players.champion_id
        FROM
            match_players
            INNER JOIN matches ON matches.id = match_players.match_id
            INNER JOIN match_teams ON match_players.match_id = match_teams.match_id
            AND match_players.team = match_teams.color
        WHERE
            match_players.summoner_puuid = 'EdlDRRAPVUAYf9iDPF9iKNyF-6rkpnXXBLiF4VUfcPYZXV9xaiQsgGKiaIz4IgBX3JCiL_oS5fmXAQ'
            AND match_teams.result != 'Remake'
            AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
        ORDER BY
            match_players.heal DESC,
            matches.id
        LIMIT
            1
    )
UNION ALL
    (
        SELECT
            'match_players.turret_kills' AS what,
            match_players.turret_kills AS amount,
            match_teams.result,
            matches.id,
            matches.DATE,
            matches.gamemode,
            match_players.champion_id
        FROM
            match_players
            INNER JOIN matches ON matches.id = match_players.match_id
            INNER JOIN match_teams ON match_players.match_id = match_teams.match_id
            AND match_players.team = match_teams.color
        WHERE
            match_players.summoner_puuid = 'EdlDRRAPVUAYf9iDPF9iKNyF-6rkpnXXBLiF4VUfcPYZXV9xaiQsgGKiaIz4IgBX3JCiL_oS5fmXAQ'
            AND match_teams.result != 'Remake'
            AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
        ORDER BY
            match_players.turret_kills DESC,
            matches.id
        LIMIT
            1
    )
UNION ALL
    (
        SELECT
            'match_players.killing_spree' AS what,
            match_players.killing_spree AS amount,
            match_teams.result,
            matches.id,
            matches.DATE,
            matches.gamemode,
            match_players.champion_id
        FROM
            match_players
            INNER JOIN matches ON matches.id = match_players.match_id
            INNER JOIN match_teams ON match_players.match_id = match_teams.match_id
            AND match_players.team = match_teams.color
        WHERE
            match_players.summoner_puuid = 'EdlDRRAPVUAYf9iDPF9iKNyF-6rkpnXXBLiF4VUfcPYZXV9xaiQsgGKiaIz4IgBX3JCiL_oS5fmXAQ'
            AND match_teams.result != 'Remake'
            AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
        ORDER BY
            match_players.killing_spree DESC,
            matches.id
        LIMIT
            1
    )
UNION ALL
    (
        SELECT
            'match_players.double_kills' AS what,
            match_players.double_kills AS amount,
            match_teams.result,
            matches.id,
            matches.DATE,
            matches.gamemode,
            match_players.champion_id
        FROM
            match_players
            INNER JOIN matches ON matches.id = match_players.match_id
            INNER JOIN match_teams ON match_players.match_id = match_teams.match_id
            AND match_players.team = match_teams.color
        WHERE
            match_players.summoner_puuid = 'EdlDRRAPVUAYf9iDPF9iKNyF-6rkpnXXBLiF4VUfcPYZXV9xaiQsgGKiaIz4IgBX3JCiL_oS5fmXAQ'
            AND match_teams.result != 'Remake'
            AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
        ORDER BY
            match_players.double_kills DESC,
            matches.id
        LIMIT
            1
    )
UNION ALL
    (
        SELECT
            'match_players.triple_kills' AS what,
            match_players.triple_kills AS amount,
            match_teams.result,
            matches.id,
            matches.DATE,
            matches.gamemode,
            match_players.champion_id
        FROM
            match_players
            INNER JOIN matches ON matches.id = match_players.match_id
            INNER JOIN match_teams ON match_players.match_id = match_teams.match_id
            AND match_players.team = match_teams.color
        WHERE
            match_players.summoner_puuid = 'EdlDRRAPVUAYf9iDPF9iKNyF-6rkpnXXBLiF4VUfcPYZXV9xaiQsgGKiaIz4IgBX3JCiL_oS5fmXAQ'
            AND match_teams.result != 'Remake'
            AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
        ORDER BY
            match_players.triple_kills DESC,
            matches.id
        LIMIT
            1
    )
UNION ALL
    (
        SELECT
            'match_players.quadra_kills' AS what,
            match_players.quadra_kills AS amount,
            match_teams.result,
            matches.id,
            matches.DATE,
            matches.gamemode,
            match_players.champion_id
        FROM
            match_players
            INNER JOIN matches ON matches.id = match_players.match_id
            INNER JOIN match_teams ON match_players.match_id = match_teams.match_id
            AND match_players.team = match_teams.color
        WHERE
            match_players.summoner_puuid = 'EdlDRRAPVUAYf9iDPF9iKNyF-6rkpnXXBLiF4VUfcPYZXV9xaiQsgGKiaIz4IgBX3JCiL_oS5fmXAQ'
            AND match_teams.result != 'Remake'
            AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
        ORDER BY
            match_players.quadra_kills DESC,
            matches.id
        LIMIT
            1
    )
UNION ALL
    (
        SELECT
            'match_players.penta_kills' AS what,
            match_players.penta_kills AS amount,
            match_teams.result,
            matches.id,
            matches.DATE,
            matches.gamemode,
            match_players.champion_id
        FROM
            match_players
            INNER JOIN matches ON matches.id = match_players.match_id
            INNER JOIN match_teams ON match_players.match_id = match_teams.match_id
            AND match_players.team = match_teams.color
        WHERE
            match_players.summoner_puuid = 'EdlDRRAPVUAYf9iDPF9iKNyF-6rkpnXXBLiF4VUfcPYZXV9xaiQsgGKiaIz4IgBX3JCiL_oS5fmXAQ'
            AND match_teams.result != 'Remake'
            AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
        ORDER BY
            match_players.penta_kills DESC,
            matches.id
        LIMIT
            1
    )