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(36287)
}
}
Taking anon's list is this how we currently sit for player points?
Have assumed Motum and DJ are 10 points each or does that change under injury or part season?
Other points are from NBL site
6 p Creek: 1 year + option for another year left
10 p Motum: 1 year left (probably a player option)
10 p Gibson: Player option for next season
10 p Johnson-Free agent (nothing mentioned beyond that)
9 p Wilson-Free agent
9 p Petrie-Free agent
8 p Schenscher-Free agent
5 p Teys-Free agent
6 p Crawford-Free agent
1 p Daly-Free agent
74 points