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

Years ago
What the NBL should do! IMO
Baby steps here...
First things first.
Sort out TV coverage. Either OneHD show live games or cut the losses, move to ABC for 1 game a week and set up a league pass for the rest. League pass could also show shows like "It goes off" and other fan made shows.
Second. Fix the phone app. Not that hard. Make it free.
Fix the jersey/AND1/Merch issue.
These three things alone would help out so much, bring in more fans, engage the existing fans then from there we can start talking about sal caps etc. Because whats the point of lifting the cap/Making marque player exemptions/Raising player point caps etc when these other issues will limit the league growing?
