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(6239)
}
}
Anonymous
Years ago
ABL - Blitz. Where's the other teams?
a fundraiser for 3 clubs. Obviosly you have run many tornaments. Discounting the volunteer man hours, by the time court hire and umpires are paid for, it will be close to break even. If we are lucky
there are some good ideas here that the tournament committee will look at for next year. A week before the tournament we had 9 mens teams and the program was set. Then two pulled out. That is why one group has 3 teams.
I was there last night and really enjoyed the pace of the games. Prize money would be a great ideas,but that requires sponsors. If the Blitz is a success this year, maybe next year. All post tournament comments ( hopefully a few positive ones) will be welcome.
Let's hope that the blitz goes well, because I have my doubts about its success in this format.
Next year could see more clubs pull out and organise their own 'beneficial' trials, not a fund raiser for 3 clubs.