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(6872)
}
}
Skip, when the Sixers played NZ first up, being a historical game, the club organised a trip for fans who were interested through the travel agent they were using at the time (not sure if they still use them). It was a fantastic trip but I thought quite expensive. We could have done it more cheaply ourselves but we did get 5 star accomodation (Sky City Auckland), transport from the hotel to the game and also a drinks and nibbles session with the players after the game at our hotel. It would be good if something like this is done again as this game is of equal importance. I will wait and see if the club does anything about it and if not, I will put my name forward to look into some costs as a group and call for expressions of interest.