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(4086)
}
}
Of course - any time there is uneven amount of games and there are byes it will be unfair - but at least this gives the so called better teams (higher ranked teams) the oppurtunity to set their destiny :-)
And whilst the lower teams can get a free ride (a free win) there is alot more satisfaction making the finals knowing you did it without a freebie.
In our social comp (in Melbourne) - in the case of uneven byes (which happens nearly every year). You get awarded a win, they try to give the extra bye to the lower teams (based on 2 grading games each year), but it dosn't always work out that way (although the 4 teams featuring in finals the season before will never get the extra bye).
I think I actually prefer this system though as it makes you win your games to make the finals/top of the ladder, especially if you are from top four the season before.
Im sure it has happened were a team has made the finals based on that free win/bye but I would say it would be less likely to occur.