Transactions
Full Player Profile
SELECT i.*
FROM
puck_injury i
inner JOIN puck_transaction t ON i.injury_id = t.injury_id
WHERE (i.active = '1') AND (i.team_id != '0') AND (i.player_id = '6491')
GROUP BY i.player_id
ORDER BY i.injury_id DESC
LIMIT 1000 OFFSET 0
Oct 7 2020 | San Jose Sharks
Assigned D Karlis Cukste to HC Mogo (Latvia).
Advertisement
Advertisement