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(39759)
}
}
I've been able to watch the premium content in Firefox. I use NoScript and had to ensure the script options were set to allow all of the third party links. Havign doen that, I've had no Firefox specific problems streaming content.
When I've had problems it's been at the server end. They seem not to have allowed for the demand and it's impossible to view much of the content much of the time (I'm getting sick of the 'On your marks' graphic and video timelines jumping forwards and backwards at random). Those problems are browser independent as I've tested Chrome and IE as well as Firefox, with no differences in performance and accessibility of content.
It's worth trying premium access if you're a Telstra customer and so get it for free but I wouldn't pay for it.