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(29867)
}
}
The length of a season is always hotly contested. Too long and people lose interest, too short and it's not worth it.
For fairness, the teams should play away each other twice (once at home, once away), and then there's finals. If the games are played at a common stadium, then it's a bit different.
The top 4 system of finals means a shorter major season, but rewards teams who are consistent all season. A major season that includes half or more of the teams means those teams who improve towards the end of the season are rewarded. With a top 4 of 10 teams, a team needs to win around 75% of games to qualify for finals. With a top 5 of 10 teams, a team can still qualify with around 50% wins.
The other thing to consider is school terms. If a season can squeeze into two terms, then it aligns with parent's expectations as well as school sports.