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(37330)
}
}
A lot of teams get very itchy when it comes to keeping Players on. It will be interesting to see how teams like Melbourne/Sydney and Adelaide go with points this season.
Wollongong, Perth and NZ have for the most part been able to benefit the most from this points system.
If those player points are accurate Hawks are ready to really benefit from the loyalty it has shown while other clubs have kept swapping their local content.
(I say loyal not knowing if these players have been paid in full for previous seasons)
You would be looking for 2 imports plus a marquee player, plus some great quality local (Guam) players to round out the list.
Rhys Martin is a great signing. I very underrated, smart point guard.