Skip to content

Instantly share code, notes, and snippets.

@semenoffalex
Created February 10, 2017 15:38
Show Gist options
  • Save semenoffalex/bae88c1297c9c9002e196b371de0056a to your computer and use it in GitHub Desktop.
Save semenoffalex/bae88c1297c9c9002e196b371de0056a to your computer and use it in GitHub Desktop.
q_miders <- "
SELECT
pm2.leagueid,
pm2.start_time,
pm2.match_id,
pm2.account_id,
pm2.is_radiant,
pm2.win,
pm2.player_slot,
pm2.hero_id,
pm.kills,
pm.deaths,
pm.assists,
pm.gold,
pm.last_hits,
pm.denies,
pm.gold_per_min,
pm.xp_per_min,
pm.gold_spent,
FROM (
SELECT
pm.account_id, m.match_id, m.start_time, pm.player_slot,
m.leagueid, pm.hero_id,
(pm.player_slot < 100) AS is_radiant,
(pm.player_slot < 100) = m.radiant_win AS win
FROM (
SELECT *
FROM player_matches
WHERE account_id IN (81852496, 96196828, 70388657, 87586992, 250114507, 113995822, 106573901, 237238721, 86840554, 113372833)
) pm
JOIN matches m ON pm.match_id = m.match_id
WHERE (m.start_time > 1460581200) and (m.start_time < 1504299600)
) pm2
"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment