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(39433)
}
}
Surely what you are doing is classified under fair use, I recently have been doing some personal research on fan generated content. An interesting article I recently read may be of interest to you - https://www.washingtonpost.com/sports/sports-video-clips-are-now-ubiquitous-on-social-media-can-the-nfl-put-the-genie-back-in-the-bottle/2015/10/13/e986f34c-71c9-11e5-8248-98e0f5a2e830_story.html
The no-charge zone, te area under the ring where the defence cannot take a charge. It gives the offence more freedom in the paint and send them to the free throw line more.
Another new rule being introduced.
Do we like it? Is it promoting more violent play (more injuries occcuring from it)? Is it making it too dificult to defend?