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(47007)
}
}
Surely THIS WEEK is the week to sign a new coach? Surely the board have been doing their homework over the last 4 months looking for the next coach? THIS WEEK is when players are gonna be looking elsewhere and sussing out their options for next season. The sooner a new coach is named, the chances of maintaining and recruiting the best players will improve significantly. NO ONE is going to renew their membership until this happens (I'd imagine) and singing new members will virtually not exist until a coach is announced.
This is probably the most important off-seasons in the clubs history. New board, new coach, recruiting must be second to none, imports must be second to none, lets get the ball rolling!