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(23980)
}
}
Hurdles can also be at the users end and not just the supplier, different people all trying to access from different isp's through varying connection speeds.
I only streamed one game which was Adelaide vs Melbourne tigers in melbourne, gotta admit quality was pretty damn shocking. It would be good to see iinet do some awesome streaming. damn government needs to lay out this fibre optic internets already so we can stream in High def
I enjoyed four Sixers streams - two were choppy, two were great.
Two Tigers streams and two Crocs streams which both worked fine and a Perth LMSC? stream which was great.
I would like to see the club stick with it and hopefully iron out the bugs if possible.
I hope they do stream but find a new group to stream them. Rivus sucked bad. Its like using telstra dodgey dial up.
It gives those in regional areas a chance to watch basketball when its way too far to travel to the BMC for games. $5 a pop and have a service that doesnt jam up or freeze on people