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(38280)
}
}
The view will be fine... it's the sound that will be the biggest thing that changes and doesn't get better the more expensive your seats sit.
Here's the trick. If you're seats are in the nose bleeds, just don't look at the court when you walk into the arena. Wait till you get to your seat then take in the view. You won't know what you are missing.
I have never sat in the nickel section but I've heard everywhere has a decent view. I sit in Bronze and I'm more than happy with how close I am to the action.