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(142)
}
}
To 'Basketball is Life' - when Adelaide City were in the NSL and had a similar setup for their 'B' team in the local SA Premier League, they had to pay transfer fees to get the players out of their contracts at one club (ie Raiders and Mario Karlovic) to come play for them and subesequently contract their youth players. I'm sure that if the 36ers ever proposed to have a team in teh ABL, the clubs will look to this option of compensation for their losses, defeating this purpose?
I think the current system is fine - the Sixers (or 36ers :P) get the pick of the current bunch of players from ALL teams, without having to deal with all that kind of messy stuff. If only they could DO IT PROPERLY and not let the BEST YOUTH TALENT from SA go to bloody Townsville.