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(37432)
}
}
Not only good for team stability but also gives security and stability to a player. He knows what he's doing for the next 3 years so can really buy into to team, the city, the teams supporters. Also supporter can buiy into the players. We can actually become attached to players and theirfore increase our support.
I'm also hoping this more stable core group means reduced costs in recruiting new players every year which frees up more resources to get he next possible imports.
Ideally every NBL team has spectacular and exciting imports that on game nights efectively neutralise each other so its actualy the quality of the Aussie contingent that decides the final team stadnings.
Agree. Look at the success of the recent NBL champions - NZ and Perth.
Both had a strong and stable core of players. Their systems and styles were (and still are) settled and the only player movements tended to be in regards to 6th men and onwards down the bench.