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(35615)
}
}
Appreciate the kind words. It's a real shame that the league and some of the teams still aren't aware of how much promotion actually helps the game.... It'd also be half decent if the Sixers recognized this because, lets face it, they haven't really got any of their own material out there!
I'll be catching up with DQ a few more times through the season and also hope to get onto some of the other imports so keep an eye out for them. Thankyou all for the support.. Means a lot to a 20 year old kid trying to help promote the game in country Vic