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(3687)
}
}

Anonymous
Years ago
Reserves finals format
Final 6
First week
3 v 6 (FIRST ELIMINATION FINAL)
4 v 5 (SECOND ELIMINATION FINAL)
Second week
SECOND SEMI FINAL
1 v 2 - winner goes straight to grand final.
THIRD ELIMINATION FINAL
Winners of first week's games (ie F.E.F. AND S.E.F.) play each other
Third week
PRELIMINARY FINAL
Loser of 1 v 2 (SECOND SEMI FINAL)plays winner of THIRD ELIMINATION FINAL.
Final week
GRAND FINAL
Winner of 1 v 2 (S.S.F.) plays the winner of the PRELIMINARY FINAL.
Only the top 2 sides have the double chance and all finals but for the Second Semi Final are instant death. If you are 3 - 6 on the Premiership table at the end of the minor round - you need 4 wins in a row to claim the championship. All the best.

