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(33323)
}
}
That is a very good deal if you don't have season tickets, or like Isaac said a gift for "Festivus".
There are some cracker home games coming up. Any 3 from this list won't disappoint any fan.
1. FRIDAY 14th March 2014: v Perth. Get your ticket while you can for that one. Scalpers will have them on e-bay soon selling for more than Rolling Stones tickets.
2. This Sunday v Cairns: Time to hit back hard!
3. Sat 4th Jan: v Breakers: We got 'em at home....twice. They don't like that and will be out to sneak into the Top 4.
4. Sun 23rd Feb: v Breakers: "I don't care how many gold medals Australia gets, just so long as it's one more than NZ" It's always good to watch the Breakers.
5. Sun 23rd Mar: v Melbourne: Last home game. Will affect final ladder position for sure, so this will be a good game.
6. Sun 12th Jan: v Sydeney: Fringe NBA player, local boy in Madge, coach we love to hate, oh and don't forget to cheer when Ben Allen dunks.