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(32459)
}
}
It's an interesting question. None of the major parties have devoted much time to sport and recreation as most polls don't see it as a major issue.
One would expect that if there were a number of close electorates come the election, some "sweeteners" may be on the table, but the issue is that all sport is fighting for the same bread crumbs.
An outdoor oval complex is also going to be a front runner. It can be AFL, NRL, cricket, dog walkers, softball, baseball, lacrosse etc. A corner of the oval can be concreted for netball, tennis etc etc. A government could spent $5M and keep a large group of people happy.
That same $5M could be used to build a court facility for basketball, indoor soccer, netball, volleyball, badminton, korfball, but a small number of people would be happy.
Governments always want to have a social agenda so their is always a funding pie somewhere.