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(14813)
}
}
10 teams is what si required moving forward - we need to create more depth in our junior program and you can only do this through exposing more players to the top level. But at the same time we haver to create a structure that will support it.
10 teams in Div 1. 8 is too few as we need to develop depth. May take some time to grow and get stronger but it is worth the effort. As pointed out in another thread, look at what VIC have achieved with their 20 teams, 2 conferences at the top level.
Like the idea of 2 conferences for Div 2 based on regions. Has a lot of merit and may even entice more players to take part with reduced travel.
What about an eight Team Div 1, with each team playing each other 3 times, resulting in 21 games.
This way we are playing strength with strength.
Division 2, split into a North and South division, each with eight teams, playing each other twice, and one game/round accross the division. Also end up having a 21 game regular season.
Maybe this scenario will help the teams that are far out cut their travelling.