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(23436)
}
}
It will still be the 2 import rule, so with 9 teams in the league, but only 8 in ours, it should mean that there will often be some decent free agents including imports.
I am thinking 2 leagues at this point with 8 teams in each.
Introducing Promotion/Relegation for the 2 top/bottom teams. So playoffs would apply to the bottom teams to avoid relegation too.
Last year the draft was done through Google groups. I'd be happy to do it through there again or maybe even setting up a facebook page to do it? Thoughts?
Of those that played last year, was there anything you didn't like that you would liek to see changed?