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(33825)
}
}


Years ago
^Anon, how many courts do you believe is necessary for junior Nationals at under 16 level?
They quite often get by with 3-4 court venues, as games are usually spaced and a team would only play one time per day for most of the week.
The quality of the stadium, seating and crowd comforts can vary quite a lot, but the amount of courts never seems to be a huge issue from what I have observed...
I am sure Tasmania has a 4 court venue of high enough standard to cater for Nationals!

Years ago
Pitty there is only one decent court in the whole of Tas. (Ulverstone) and that is in the middle of nowhere on its own. Struggle to find a venue anywhere capable of running a Nationals event without spreading it out over a number of towns.
