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(21120)
}
}
Got my tickets and carpark pass Monday in post. Waiting on members card. Happy to wait as i only responded to email last Friday. Been busy and missed e-mail for a while.
Ben, thanks for your response. I emailed Dean Parker. I have been away for the last 3 1/2 weeks and missed the pre season game, however made up for it by attending the game in Cairns last night. It was good to get a view of the "new team". I was not really impressed with the performance as a team although a few individuals did a good job. Hoping this will improve as the team gel and put us where we really should be.
Should get them this week, I'm waiting on the members card and season car park permit, when I emailed the club they mentioned they'd be sent out in time for the first game.
Haven't got mine yet and sent an email to the club last week to enquire about it. No response. If it doesn't come this week, hope there will be someone in the office to do a check so they can let us in to the game.