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(19614)
}
}
Hey Umbrella,
Your suggestion about trades reminds me of something I was thinking a little while back: is it possible to start the new NBL with a bang, by holding a draft prior to the first season?
Obviously there are issues here, for example players who have the security of a contract may challenge its cancellation in court. Also, it could be tough on some players if they are drafted by an interstate club and have to move to continue their career.
But it would certainly make for some great media interest and would appeal to a lot of fans out there.
Maybe each team could be given four or five slots to spend on less established 'home town' players (ie, those who will be paid less, and may not want to risk moving interstate if their career may not last).
Then teams could draft their starting 5 from the pool of established stars. Add a couple of imports after that and you're done!
So what do people think of such a 'courageous' idea? *ducks head below parapet*