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(34219)
}
}
I did see a little sports snippet on Weekend Sunrise about Adelaide tying up the series, but it only went for about 10 seconds and the "highlight" they showed was Wagstaff crashing into the cameraman.
The Alan Black article was more talking about how he expected when they moved from their old place to the Perth Arena that the place might feel very empty and he was somewhat surprised that even more people turned up. It was also talking about the fact they have now been in 28 final campaigns straight.
Almost.......The Crow-vertiser wouldn't be the Crow-vertiser if it didn't do a Crows story. There was a little Crows story "Flag Dream Still Alive" that got slotted onto the back page, so not quite 100% NBL!