array(2) {
[0]=>
string(815) "
select r.*,
rc.info,
t.title as threadtitle,
u.username as username,
u.anonymous as useranonymous,
`f`.`value` AS `flairvalue`,
`ft`.`name` AS `flairname`,
`ft`.`colour` AS `flaircolour`,
`ft`.`icon` AS `flairicon`
from reply as r
join thread as t on t.id = r.threadid
join replycontent as rc on rc.replyid = r.id
join user as u on u.id = r.userid
left join `flair` `f` on `f`.`userid` = `u`.`id` and `f`.`categoryid` = `t`.`categoryid`
left join `flairoption` `ft` on `ft`.`id` = `f`.`flairoptionid`
where r.businessid = :businessId
and r.threadid = :threadId
group by r.id
order by r.utcdated desc
limit 0,50
"
[1]=>
array(2) {
["businessId"]=>
int(1)
["threadId"]=>
int(46628)
}
}
It's a good question when a player gets injured they usually get replaced on the playing roster at least temporarily so presumably their contract would come off the salary cap for that injury period but who keeps paying them the team or their insurance company?
I know in the NBA when Luc Longley retired from the Knicks with 3 years remaining on his contract they worked out a deal where it was ruled a medical retirement and thus the last 3 years of his contract came off the Knicks books and was paid by their insurance company. It also meant he was never allowed to play pro basketball again otherwise he would have to repay the insurance company but that was for a medical retirement not a temporary injury.
Pretty funny story here from Western Australia's State League - http://www.sportingpulse.com/assoc_page.cgi?client=1-5011-0-0-0&sID=78732&&news_task=DETAIL&articleID=22367298
American Spencer Perrin claimed to American media that he had a $1mil contract along with private jet flight from USA to Aus, along with a beachfront apartment.