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(36241)
}
}
Thanks for clarifying Jardz and taking the time to share on this forum.
I was definitely under the wrong impression then as I heard from what I believed to be a very reliable source that that was the case but stand to be corrected.
I wonder how much of it has to do with /per and $$.. I know a lot of sports who would love to do more in this area but the "social media manager"is realistically only .2 in their role with the rest spent in admin and so forth.
With SEABL going to BA perhaps we could see something similar to what they do to the WNBL and junior stuff. It does the job and looks okay... No point in appointing someone new when you don't know how the immediate future will look.
It's a great league and great standard - I don't see why anyone wouldn't want to do more to promote it? Especially with Brisbane, Hobart, NWT and MtG being the best the sport has to offer in their area. Get people excited and around it.