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(38126)
}
}
Okay, like the add but I agree with hm on the coverage so far (being week one of course), and I have never though the #Hardball was a great way to go.
Having said that, we are stuck with it, so I am moving on...
What is it about this add that works and how can we extract that coolness to an NBL game coverage.
Sound
Atmosphere
Excitement
These are the key elements (to start with) that I thought were lacking in some way last night for the NBL opener.
How can we improve on these, well for a start the sound quality can be acoustically improved and music coordinated to suit but not being an expert on this I can't exactly say how it would be done.
The atmosphere can improve right from the get-go, when players are introduced. How hard would it be to get the lighting right and do intro's in the dark for example?
Get the commentary right and it will add to the the ecxitement...