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 = '3948')
GROUP BY i.player_id
ORDER BY i.injury_id DESC
LIMIT 1000 OFFSET 0
Mar 26 2014 | Dallas Stars
Signed C Alexander Guptill to an entry-level contract.
Advertisement
Advertisement