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(37215)
}
}
Anonymous
Years ago
BA should categorize tournaments nationally
Eltham/Dandenong tournament is by far a better tournament than Nunawading. Almost every VC team plays in this as it is a good intro back from school holidays. As a previous poster said, Nunawading does not include the best 8 Vic teams and there is no guarantee of the rest as some don't bother because the standard is not that high.
It sounds easier than it would be to do, reason being exactly what anon^ is suggesting. Each state has a different structure and while I think the idea has merit, not sure if BA would put in the effort.
HO, the Vic Country Club Champs, it is on in October and has been running for a while, I seem to recall some others, even in Geelong they tried it for a couple of years and got some decent numbers but the concept dropped off.