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(37337)
}
}

Years ago
Cairns re-sign Loughton for three years
Great to see teams appreciating the value of stability both on court and off. Teams can develop their game plans more and fans can become more connected.
Look at the player points value of long term players to Hawks.
Possible new teams in major cities is also a possible motivation for regional based teams.

Years ago
Did they take less per year but with longer term security as the trade off??
Leave more in the salary cap/budget for other players each year.
Could help with retaining guys like Wilbekin or attracting top imports/players.
Would that be the thinking?


Years ago
Depends on the deal handed out. May pay dividends in terms of culture and off court leadership as well.
