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(27568)
}
}
Anon - Disagree with the Townsville comments. Having had season tickets for 10 years in the past, I would say Townsville is up the there with the best entertainment wise. Music is fine. They don't have a great home court advantage for nothing.
Phil, what does Lemanis need to hide from? His team which won a title last year is still top of the table despite most people writing them off pre season.
Adelaide was really bad for this a few years ago toward the end of Smyth's reign. You couldn't hear yourself think and there was no point cheering, no one would hear you. Even Ken Cole called them out in it in an interview with the paper!