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(32470)
}
}
OK, there's been a lot of slagging off at stadiums here regarding leaking roof, bad floors, dodgy scoreboards, dodgy sausage rolls at canteens etc. So, how do all the stadiums rank out of 10?
To get the ball rolling, initial scores:
1. Dome 9.5/10
2. Starplex 9
3. Pasedena 8.5
4. MARS 8
5. Morphett Vale 8
7. Marion 7
8. Mt Barker 7
9. Pt Adelaide 7
10. Wayville 5
11. Hillcrest 4
I propose the following points:
* 5 points for player facilities (bench, court condition, rings, lighting etc)
* 4 points for spectator facilties (parking, seating, climate, canteen, scoreboard etc)
* 1 point for overall mix (ease of entry, "feel"