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(23349)
}
}
If I may, BSA seems to have 3 courts available for Reserves on Tuesday nights Dome, Pasadena and Morphett Vale
The last time South played centrals it was at the dome thus a northern(ish) game if it is close to a home and away style structure then a game at Morphett Vale is the only option.
Centrals get shafted because a home game for them is at the Dome still a 35km drive (yuck) from Starplex, South home game is either Morphett Vale or Pasadena either way its at 6km-15km from marion stadium.
Yeah teams have to travel but in a district competition I think BSA is doing a fairly good job to accomodate with the facilities they have. I for 1 would rather travel to either the Dome, Pasadena or Morphett vale then have trips to every teams home stadium, 2 trips to Starplex or Mt. Barker for reserves?... no thanks.
80% of reserves teams are within 10km of these 3 stadiums I think this may be a case of appeasing the masses. So until venues are willing to forgo a night of social where they make money we may be stuck with the system which isnt really that bad!