Advertisement
Guest User

Untitled

a guest
Feb 2nd, 2022
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. (
  2.     SELECT
  3.         'match_players.kills' AS what,
  4.         match_players.kills AS amount,
  5.         match_players.win as result,
  6.         matches.id,
  7.         matches.date,
  8.         matches.gamemode,
  9.         match_players.champion_id
  10.     FROM
  11.         match_players
  12.         INNER JOIN matches ON matches.id = match_players.match_id
  13.     WHERE
  14.         match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
  15.         AND match_players.remake = 0
  16.         AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
  17.     ORDER BY
  18.         match_players.kills DESC,
  19.         matches.id
  20.     LIMIT
  21.         1
  22. )
  23. UNION ALL
  24.     (
  25.         SELECT
  26.             'match_players.deaths' AS what,
  27.             match_players.deaths AS amount,
  28.             match_players.win as result,
  29.             matches.id,
  30.             matches.date,
  31.             matches.gamemode,
  32.             match_players.champion_id
  33.         FROM
  34.             match_players
  35.             INNER JOIN matches ON matches.id = match_players.match_id
  36.         WHERE
  37.             match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
  38.             AND match_players.remake = 0
  39.             AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
  40.         ORDER BY
  41.             match_players.deaths DESC,
  42.             matches.id
  43.         LIMIT
  44.             1
  45.     )
  46. UNION ALL
  47.     (
  48.         SELECT
  49.             'match_players.assists' AS what,
  50.             match_players.assists AS amount,
  51.             match_players.win as result,
  52.             matches.id,
  53.             matches.date,
  54.             matches.gamemode,
  55.             match_players.champion_id
  56.         FROM
  57.             match_players
  58.             INNER JOIN matches ON matches.id = match_players.match_id
  59.         WHERE
  60.             match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
  61.             AND match_players.remake = 0
  62.             AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
  63.         ORDER BY
  64.             match_players.assists DESC,
  65.             matches.id
  66.         LIMIT
  67.             1
  68.     )
  69. UNION ALL
  70.     (
  71.         SELECT
  72.             'match_players.gold' AS what,
  73.             match_players.gold AS amount,
  74.             match_players.win as result,
  75.             matches.id,
  76.             matches.date,
  77.             matches.gamemode,
  78.             match_players.champion_id
  79.         FROM
  80.             match_players
  81.             INNER JOIN matches ON matches.id = match_players.match_id
  82.         WHERE
  83.             match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
  84.             AND match_players.remake = 0
  85.             AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
  86.         ORDER BY
  87.             match_players.gold DESC,
  88.             matches.id
  89.         LIMIT
  90.             1
  91.     )
  92. UNION ALL
  93.     (
  94.         SELECT
  95.             'matches.game_duration' AS what,
  96.             matches.game_duration AS amount,
  97.             match_players.win as result,
  98.             matches.id,
  99.             matches.date,
  100.             matches.gamemode,
  101.             match_players.champion_id
  102.         FROM
  103.             match_players
  104.             INNER JOIN matches ON matches.id = match_players.match_id
  105.         WHERE
  106.             match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
  107.             AND match_players.remake = 0
  108.             AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
  109.         ORDER BY
  110.             matches.game_duration DESC,
  111.             matches.id
  112.         LIMIT
  113.             1
  114.     )
  115. UNION ALL
  116.     (
  117.         SELECT
  118.             'match_players.minions' AS what,
  119.             match_players.minions AS amount,
  120.             match_players.win as result,
  121.             matches.id,
  122.             matches.date,
  123.             matches.gamemode,
  124.             match_players.champion_id
  125.         FROM
  126.             match_players
  127.             INNER JOIN matches ON matches.id = match_players.match_id
  128.         WHERE
  129.             match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
  130.             AND match_players.remake = 0
  131.             AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
  132.         ORDER BY
  133.             match_players.minions DESC,
  134.             matches.id
  135.         LIMIT
  136.             1
  137.     )
  138. UNION ALL
  139.     (
  140.         SELECT
  141.             'match_players.kda' AS what,
  142.             match_players.kda AS amount,
  143.             match_players.win as result,
  144.             matches.id,
  145.             matches.date,
  146.             matches.gamemode,
  147.             match_players.champion_id
  148.         FROM
  149.             match_players
  150.             INNER JOIN matches ON matches.id = match_players.match_id
  151.         WHERE
  152.             match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
  153.             AND match_players.remake = 0
  154.             AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
  155.         ORDER BY
  156.             match_players.kda DESC,
  157.             matches.id
  158.         LIMIT
  159.             1
  160.     )
  161. UNION ALL
  162.     (
  163.         SELECT
  164.             'match_players.damage_taken' AS what,
  165.             match_players.damage_taken AS amount,
  166.             match_players.win as result,
  167.             matches.id,
  168.             matches.date,
  169.             matches.gamemode,
  170.             match_players.champion_id
  171.         FROM
  172.             match_players
  173.             INNER JOIN matches ON matches.id = match_players.match_id
  174.         WHERE
  175.             match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
  176.             AND match_players.remake = 0
  177.             AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
  178.         ORDER BY
  179.             match_players.damage_taken DESC,
  180.             matches.id
  181.         LIMIT
  182.             1
  183.     )
  184. UNION ALL
  185.     (
  186.         SELECT
  187.             'match_players.damage_dealt_champions' AS what,
  188.             match_players.damage_dealt_champions AS amount,
  189.             match_players.win as result,
  190.             matches.id,
  191.             matches.date,
  192.             matches.gamemode,
  193.             match_players.champion_id
  194.         FROM
  195.             match_players
  196.             INNER JOIN matches ON matches.id = match_players.match_id
  197.         WHERE
  198.             match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
  199.             AND match_players.remake = 0
  200.             AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
  201.         ORDER BY
  202.             match_players.damage_dealt_champions DESC,
  203.             matches.id
  204.         LIMIT
  205.             1
  206.     )
  207. UNION ALL
  208.     (
  209.         SELECT
  210.             'match_players.damage_dealt_objectives' AS what,
  211.             match_players.damage_dealt_objectives AS amount,
  212.             match_players.win as result,
  213.             matches.id,
  214.             matches.date,
  215.             matches.gamemode,
  216.             match_players.champion_id
  217.         FROM
  218.             match_players
  219.             INNER JOIN matches ON matches.id = match_players.match_id
  220.         WHERE
  221.             match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
  222.             AND match_players.remake = 0
  223.             AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
  224.         ORDER BY
  225.             match_players.damage_dealt_objectives DESC,
  226.             matches.id
  227.         LIMIT
  228.             1
  229.     )
  230. UNION ALL
  231.     (
  232.         SELECT
  233.             'match_players.kp' AS what,
  234.             match_players.kp AS amount,
  235.             match_players.win as result,
  236.             matches.id,
  237.             matches.date,
  238.             matches.gamemode,
  239.             match_players.champion_id
  240.         FROM
  241.             match_players
  242.             INNER JOIN matches ON matches.id = match_players.match_id
  243.         WHERE
  244.             match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
  245.             AND match_players.remake = 0
  246.             AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
  247.         ORDER BY
  248.             match_players.kp DESC,
  249.             matches.id
  250.         LIMIT
  251.             1
  252.     )
  253. UNION ALL
  254.     (
  255.         SELECT
  256.             'match_players.vision_score' AS what,
  257.             match_players.vision_score AS amount,
  258.             match_players.win as result,
  259.             matches.id,
  260.             matches.date,
  261.             matches.gamemode,
  262.             match_players.champion_id
  263.         FROM
  264.             match_players
  265.             INNER JOIN matches ON matches.id = match_players.match_id
  266.         WHERE
  267.             match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
  268.             AND match_players.remake = 0
  269.             AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
  270.         ORDER BY
  271.             match_players.vision_score DESC,
  272.             matches.id
  273.         LIMIT
  274.             1
  275.     )
  276. UNION ALL
  277.     (
  278.         SELECT
  279.             'match_players.critical_strike' AS what,
  280.             match_players.critical_strike AS amount,
  281.             match_players.win as result,
  282.             matches.id,
  283.             matches.date,
  284.             matches.gamemode,
  285.             match_players.champion_id
  286.         FROM
  287.             match_players
  288.             INNER JOIN matches ON matches.id = match_players.match_id
  289.         WHERE
  290.             match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
  291.             AND match_players.remake = 0
  292.             AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
  293.         ORDER BY
  294.             match_players.critical_strike DESC,
  295.             matches.id
  296.         LIMIT
  297.             1
  298.     )
  299. UNION ALL
  300.     (
  301.         SELECT
  302.             'match_players.time_spent_living' AS what,
  303.             match_players.time_spent_living AS amount,
  304.             match_players.win as result,
  305.             matches.id,
  306.             matches.date,
  307.             matches.gamemode,
  308.             match_players.champion_id
  309.         FROM
  310.             match_players
  311.             INNER JOIN matches ON matches.id = match_players.match_id
  312.         WHERE
  313.             match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
  314.             AND match_players.remake = 0
  315.             AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
  316.         ORDER BY
  317.             match_players.time_spent_living DESC,
  318.             matches.id
  319.         LIMIT
  320.             1
  321.     )
  322. UNION ALL
  323.     (
  324.         SELECT
  325.             'match_players.heal' AS what,
  326.             match_players.heal AS amount,
  327.             match_players.win as result,
  328.             matches.id,
  329.             matches.date,
  330.             matches.gamemode,
  331.             match_players.champion_id
  332.         FROM
  333.             match_players
  334.             INNER JOIN matches ON matches.id = match_players.match_id
  335.         WHERE
  336.             match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
  337.             AND match_players.remake = 0
  338.             AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
  339.         ORDER BY
  340.             match_players.heal DESC,
  341.             matches.id
  342.         LIMIT
  343.             1
  344.     )
  345. UNION ALL
  346.     (
  347.         SELECT
  348.             'match_players.turret_kills' AS what,
  349.             match_players.turret_kills AS amount,
  350.             match_players.win as result,
  351.             matches.id,
  352.             matches.date,
  353.             matches.gamemode,
  354.             match_players.champion_id
  355.         FROM
  356.             match_players
  357.             INNER JOIN matches ON matches.id = match_players.match_id
  358.         WHERE
  359.             match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
  360.             AND match_players.remake = 0
  361.             AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
  362.         ORDER BY
  363.             match_players.turret_kills DESC,
  364.             matches.id
  365.         LIMIT
  366.             1
  367.     )
  368. UNION ALL
  369.     (
  370.         SELECT
  371.             'match_players.killing_spree' AS what,
  372.             match_players.killing_spree AS amount,
  373.             match_players.win as result,
  374.             matches.id,
  375.             matches.date,
  376.             matches.gamemode,
  377.             match_players.champion_id
  378.         FROM
  379.             match_players
  380.             INNER JOIN matches ON matches.id = match_players.match_id
  381.         WHERE
  382.             match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
  383.             AND match_players.remake = 0
  384.             AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
  385.         ORDER BY
  386.             match_players.killing_spree DESC,
  387.             matches.id
  388.         LIMIT
  389.             1
  390.     )
  391. UNION ALL
  392.     (
  393.         SELECT
  394.             'match_players.double_kills' AS what,
  395.             match_players.double_kills AS amount,
  396.             match_players.win as result,
  397.             matches.id,
  398.             matches.date,
  399.             matches.gamemode,
  400.             match_players.champion_id
  401.         FROM
  402.             match_players
  403.             INNER JOIN matches ON matches.id = match_players.match_id
  404.         WHERE
  405.             match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
  406.             AND match_players.remake = 0
  407.             AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
  408.         ORDER BY
  409.             match_players.double_kills DESC,
  410.             matches.id
  411.         LIMIT
  412.             1
  413.     )
  414. UNION ALL
  415.     (
  416.         SELECT
  417.             'match_players.triple_kills' AS what,
  418.             match_players.triple_kills AS amount,
  419.             match_players.win as result,
  420.             matches.id,
  421.             matches.date,
  422.             matches.gamemode,
  423.             match_players.champion_id
  424.         FROM
  425.             match_players
  426.             INNER JOIN matches ON matches.id = match_players.match_id
  427.         WHERE
  428.             match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
  429.             AND match_players.remake = 0
  430.             AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
  431.         ORDER BY
  432.             match_players.triple_kills DESC,
  433.             matches.id
  434.         LIMIT
  435.             1
  436.     )
  437. UNION ALL
  438.     (
  439.         SELECT
  440.             'match_players.quadra_kills' AS what,
  441.             match_players.quadra_kills AS amount,
  442.             match_players.win as result,
  443.             matches.id,
  444.             matches.date,
  445.             matches.gamemode,
  446.             match_players.champion_id
  447.         FROM
  448.             match_players
  449.             INNER JOIN matches ON matches.id = match_players.match_id
  450.         WHERE
  451.             match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
  452.             AND match_players.remake = 0
  453.             AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
  454.         ORDER BY
  455.             match_players.quadra_kills DESC,
  456.             matches.id
  457.         LIMIT
  458.             1
  459.     )
  460. UNION ALL
  461.     (
  462.         SELECT
  463.             'match_players.penta_kills' AS what,
  464.             match_players.penta_kills AS amount,
  465.             match_players.win as result,
  466.             matches.id,
  467.             matches.date,
  468.             matches.gamemode,
  469.             match_players.champion_id
  470.         FROM
  471.             match_players
  472.             INNER JOIN matches ON matches.id = match_players.match_id
  473.         WHERE
  474.             match_players.summoner_puuid = 'nl72EHfItlCDSew8Y0TneYbM9Wcy03GKXrdXs3LB--hnUScEJ2O5XzyEp4pkYNAJhK0pEoaKgobVIg'
  475.             AND match_players.remake = 0
  476.             AND matches.gamemode NOT IN (800, 810, 820, 830, 840, 850, 2000, 2010, 2020)
  477.         ORDER BY
  478.             match_players.penta_kills DESC,
  479.             matches.id
  480.         LIMIT
  481.             1
  482.     )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement