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(28011)
}
}
Isn't there a broader question here about the structure of the WNBL.
Team ownership structures are all over the place - some teams are privately owned, some are association based, some are state based and the AIS is (was) federal government based.
Not a level playing field ...
All the association based teams seem to struggle financially from year to year, and depend heavily on the amount of sponsorship they can raise.
With the privately owned teams, seems to depend on how much the owner chooses to tip in on top of sponsorship.
And no framework for levelling the playing field - salary cap, points system etc ... it just seems to be a free for all.
Looks to me like BA can't decide what sort of competition is wants the WNBL to be ... and leaving the "market" to decide will just result in more WNBL teams coming and going over the years.