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(496)
}
}
Sorry, I don't celebrate Australia day, (more like a genocide day) so totally forgot about it.
Good idea thought. I think going head to head with cricket on Australia day is what we need to do. Time for administrators to have some guts because I'm sick of the one option on certain holidays, (football or cricket). If only one sport is played on a particular day of course it will dominate. Now let's just hope someone promotes it!
Alternatively, you could keep with tradition and just go to the cricket, as I have every year that we haven't gone to the Eltham carnival. Basketball is going to lose on that day!