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 = '5823')
GROUP BY i.player_id
ORDER BY i.injury_id DESC
LIMIT 1000 OFFSET 0
Sep 20 2018 | Pittsburgh Penguins
Assigned LW Troy Josephs to Wilkes-Barre/Scranton (AHL).
Advertisement
Advertisement