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(13944)
}
}
AFL - West Lakes - Yes, this is a fair hike from the CBD.
Basketball - Findon - <10 mins by taxi from CBD.
Cricket - North Adelaide - <5 mins by taxi from CBD.
Soccer - Hindmarsh - <5 mins by taxi from CBD.
Velodrome - Pooraka - Decent trip outside of the CBD
Swimming Centre - Marion - What about the Adelaide Aquatics Centre in North Adelaide? <5 mins by taxi from CBD.
Hockey - Pooraka - Decent trip outside of the CBD.
Netball - West Parklands - <5 mins by taxi from CBD.
As you can see, the majority of the facilities are close to the CBD. Yes, there is no 'sporting precinct' like you find in other capital cities, but this is a good thing when multiple events are on in the one night - less traffic congestion in the one spot.