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(40005)
}
}
If you belong to an association then contact some of the associations that have recently hosted them or contact BA or your state basketball body for information.
Recent events have been held at Perry Lakes, Belconnen (Basketball ACT), Geelong, Ulverstone, Brisbane, Dandenong, Ballarat, Geelong, Kilsyth/Knox, Ipswich, Sturt, Tamworth, etc
I believe the younger the age group the more spectators will attend. The interest and enthusiasm from families and friends is less for the U18's & U20's.
I'm not so sure many, if any, of the associations make any money from hosting these events.