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(18893)
}
}
The site is moreso just for one team, to keep track of games, and see stats (points, fouls, average win/loss margin, record against other teams). It isn't really for a team <> team thing with an entire stadiums results on there.
I just got sick of getting to the end of a season and not having anything concrete to look back on!
Just a suggestion for a big man to partner Cooper. Dench missed out on a roster spot last year so may come cheaply. He has his critics, but I quite like him. Can shoot it. Would possibly thrive in that role under Smyth who lets players shoot. Has good size too.
To me he seems like a much better option than Rees or Hambour. Thoughts?
Oh, yeah. And Smyth selected him for the Boomers. He must think he's alright.