Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- (
- SELECT
- 'match_players.kills' AS what,
- match_players.kills AS amount,
- match_players.win as result,
- matches.id,
- matches.date,
- matches.gamemode,
- match_players.champion_id
- FROM
- match_players
- INNER JOIN matches ON matches.id = match_players.match_id
- WHERE
- match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
- AND match_players.remake = 0
- 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_players.win as result,
- matches.id,
- matches.date,
- matches.gamemode,
- match_players.champion_id
- FROM
- match_players
- INNER JOIN matches ON matches.id = match_players.match_id
- WHERE
- match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
- AND match_players.remake = 0
- 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_players.win as result,
- matches.id,
- matches.date,
- matches.gamemode,
- match_players.champion_id
- FROM
- match_players
- INNER JOIN matches ON matches.id = match_players.match_id
- WHERE
- match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
- AND match_players.remake = 0
- 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_players.win as result,
- matches.id,
- matches.date,
- matches.gamemode,
- match_players.champion_id
- FROM
- match_players
- INNER JOIN matches ON matches.id = match_players.match_id
- WHERE
- match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
- AND match_players.remake = 0
- 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_players.win as result,
- matches.id,
- matches.date,
- matches.gamemode,
- match_players.champion_id
- FROM
- match_players
- INNER JOIN matches ON matches.id = match_players.match_id
- WHERE
- match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
- AND match_players.remake = 0
- 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_players.win as result,
- matches.id,
- matches.date,
- matches.gamemode,
- match_players.champion_id
- FROM
- match_players
- INNER JOIN matches ON matches.id = match_players.match_id
- WHERE
- match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
- AND match_players.remake = 0
- 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_players.win as result,
- matches.id,
- matches.date,
- matches.gamemode,
- match_players.champion_id
- FROM
- match_players
- INNER JOIN matches ON matches.id = match_players.match_id
- WHERE
- match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
- AND match_players.remake = 0
- 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_players.win as result,
- matches.id,
- matches.date,
- matches.gamemode,
- match_players.champion_id
- FROM
- match_players
- INNER JOIN matches ON matches.id = match_players.match_id
- WHERE
- match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
- AND match_players.remake = 0
- 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_players.win as result,
- matches.id,
- matches.date,
- matches.gamemode,
- match_players.champion_id
- FROM
- match_players
- INNER JOIN matches ON matches.id = match_players.match_id
- WHERE
- match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
- AND match_players.remake = 0
- 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_players.win as result,
- matches.id,
- matches.date,
- matches.gamemode,
- match_players.champion_id
- FROM
- match_players
- INNER JOIN matches ON matches.id = match_players.match_id
- WHERE
- match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
- AND match_players.remake = 0
- 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_players.win as result,
- matches.id,
- matches.date,
- matches.gamemode,
- match_players.champion_id
- FROM
- match_players
- INNER JOIN matches ON matches.id = match_players.match_id
- WHERE
- match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
- AND match_players.remake = 0
- 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_players.win as result,
- matches.id,
- matches.date,
- matches.gamemode,
- match_players.champion_id
- FROM
- match_players
- INNER JOIN matches ON matches.id = match_players.match_id
- WHERE
- match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
- AND match_players.remake = 0
- 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_players.win as result,
- matches.id,
- matches.date,
- matches.gamemode,
- match_players.champion_id
- FROM
- match_players
- INNER JOIN matches ON matches.id = match_players.match_id
- WHERE
- match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
- AND match_players.remake = 0
- 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_players.win as result,
- matches.id,
- matches.date,
- matches.gamemode,
- match_players.champion_id
- FROM
- match_players
- INNER JOIN matches ON matches.id = match_players.match_id
- WHERE
- match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
- AND match_players.remake = 0
- 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_players.win as result,
- matches.id,
- matches.date,
- matches.gamemode,
- match_players.champion_id
- FROM
- match_players
- INNER JOIN matches ON matches.id = match_players.match_id
- WHERE
- match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
- AND match_players.remake = 0
- 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_players.win as result,
- matches.id,
- matches.date,
- matches.gamemode,
- match_players.champion_id
- FROM
- match_players
- INNER JOIN matches ON matches.id = match_players.match_id
- WHERE
- match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
- AND match_players.remake = 0
- 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_players.win as result,
- matches.id,
- matches.date,
- matches.gamemode,
- match_players.champion_id
- FROM
- match_players
- INNER JOIN matches ON matches.id = match_players.match_id
- WHERE
- match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
- AND match_players.remake = 0
- 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_players.win as result,
- matches.id,
- matches.date,
- matches.gamemode,
- match_players.champion_id
- FROM
- match_players
- INNER JOIN matches ON matches.id = match_players.match_id
- WHERE
- match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
- AND match_players.remake = 0
- 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_players.win as result,
- matches.id,
- matches.date,
- matches.gamemode,
- match_players.champion_id
- FROM
- match_players
- INNER JOIN matches ON matches.id = match_players.match_id
- WHERE
- match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
- AND match_players.remake = 0
- 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_players.win as result,
- matches.id,
- matches.date,
- matches.gamemode,
- match_players.champion_id
- FROM
- match_players
- INNER JOIN matches ON matches.id = match_players.match_id
- WHERE
- match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
- AND match_players.remake = 0
- 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_players.win as result,
- matches.id,
- matches.date,
- matches.gamemode,
- match_players.champion_id
- FROM
- match_players
- INNER JOIN matches ON matches.id = match_players.match_id
- WHERE
- match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
- AND match_players.remake = 0
- 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
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement