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(30648)
}
}
Yeah can someone PLEASE do something about the ugly brown North Shore court. It makes me hate New Zealand even more, then they go to Vector and it seems to go away some.
I'd really like Perth (of whom has been called the yardstick of this league) to really blow us away with court design and have everyone want to change theirs.
The uniforms are so bloody ugly and it takes one heritage round to show that (minus the ANZAC Townsville jersey) and it would be great to have their second colour more prominent and even on the sidelines of the court and as for Melbourne, its simple - we just cross our fingers and hope they spend more time at Hisense arena !
No companies are going to survive in an industry where the customers and consumers are propped up by rebates/subsidies.
In these economic times getting major sponsors to contribute large sums of money will be near impossible, unless you can appeal to the masses.