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(20786)
}
}
I think sporting pulse sites will be basic now and problematic in the future when the NBL wants to change to some other model. These guys are generally about locking in the client and making it hard for them to leave. Who will own the data on the site that is provided by the club? Far from ideal and a definate step backwards by the NBL IMHO.
Isaac - Essendon miss out on about $100,000 a year in AFL funding by running their Official Website away from Bigpond. However, their website is far superior and quicker to use than any other clubs site which they view as more important in the long run.
I understand however, NBL clubs dont have the same sort of money that AFL clubs have and for the time being its probably best to run with Sporting Pulse. I just hope they are an improvement on Sportal.