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(32636)
}
}
Sorry to drift off the usual path of whinging about what the NBL isn't going to do this season to take us back to the heights of the 90s popularity, but speaking of the launch, has there been anything actually announced, like a media thing, or fans meet and greet in the city or something?
I heard somewhere that something is happening on Thursday afternoon/evening, but for the life of me I can't remember where...
Maybe they will announce this season's Dream Team!
But seriously Isaac I was wondering mate, if for example Perth Wildcats and Adelaide 36ers released rivalry DVDs of say 5 greatest wins against Perth/Adelaide, who would get monies for that?
Is it something that would go to NBL or those teams and lastly do you know who owns the royalties to old NBL games and is there any possibility that NBL.tv will be putting old games there for us in the future?