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(21151)
}
}
BTW i didn't make that video (someone from the club did) but i am looking to do my own weekly show where i interview players, coaches, cheers leaders ;-) lol I'll keep ya's posted on when that happens!!!
Yeah, I like the players names on the backdrop too. Looks nice and professional having that background for interviews.
Just a small criticism, but I thought the interview questions were flashed up for too long. Would be better IMO if you could just hear the interviewer asking the question really.
Thanks for putting this stuff together though Tru Blue.
Also, Does anyone know if i would run into any problems doing my own YouTube style show with sixer player interviews? I just think i could add a bit more of a fan perspective, and hopefully a laugh or two...