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(36444)
}
}
As part of the deal to keep The Hopman Cup, it has an opening roof. This means that it tends to be a big "bowl" and "upper tiers" are only on one end and a long way back.
Location has a lot to do with the numbers they are getting at the Arena. Challenge was a horrible location. Hard to get to and the public transport situation was pretty much non existent. I purchased my memberships as soon as they made the move back to the CBD as did thousands of others.
And i like the design of the Arena :P Looks awesome and modern.
As discussed in another thread, there is hope of a new home for the Kings at or near Darling Harbour in the future. This would be big for the Kings as it would also be central.
I hope Bullets (if and when they come back) dont go to Boondal as its not very central although Im not sure on what other options they have.