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(36766)
}
}
Not really, as this way it gives Finals teams the chance to negotiate with their players after the games and allows them to focus on the games at hand... Of course, very annoying for new teams coming in (or if you're after a particular player for your current team who currently plays for someone else), with the quality players re-signing with their current teams before you've had a chance to approach them... But if they were that keen on staying with a current team, more often than not, they would have re-signed with them anyways, saying "I wouldn't mind checking out my street value" isn't an uncommon thing in the NBL, Mitch Creek has done it a couple of times, just as an example I think?
Am I the only one who thinks it's a bit strange that Free Agency doesn't include Free Agents who re-sign with their own teams? I have no doubt that Trigger would have re-signed regardless, but still.