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(26585)
}
}
Hey guys, first time poster here. These are the NBL TV ratings so far, using TV tonight and @MediaweekAUS on Twitter as sources. I'm keeping track of each game's ratings on my website, but not sure if posting the link would be considered spam or not so I'll just do a copy-and-paste job atm...
Round 1
Fri - Melbourne Tigers v Sydney Kings, 60,000 (24k in Melb, 14k in Syd)
Sat - Adelaide 36ers v Perth Wildcats, 28,000
Sun - Wollongong Hawks v NZ Breakers, 13,000
Round 2
Fri - Townsville Crocs v Cairns Taipans, 19,000
Sat - Sydney Kings v NZ Breakers, 22,000 (WNBL same day: 35k)