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(7672)
}
}
I agree that there have been some great changes, as mentioned by Isaac.
What I'm still missing is the point/benefit of renewing/signing up for a season ticket now as opposed to after the July 14th deadline.
If the only difference is a chance to win 1 of 3 29" tv's that dosn't really make people feel like signing up ASAP! Sure it's a great idea but wouldnt it be better to reward ALL who renew their membership or sign up early after all they are the ones showing faith in the club (not just the team because the team isnt finalised as yet, although porbably closer than it has been in previous years).
Lastly just had to pick on this comment from Darren :-)
"we look forward to having the Distinctive Homes Dome as the most feared venue in the NBL"