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(18373)
}
}
I wish I could find my source to quote, but in the NBA if you pass to a player who "makes an immediate reaction to the basket" and scores, it's an assist. IIRR it was an answer posted to a question about whether taking a dribble stopped a player getting an assist -you can still get an assist if the player takes a dribble, but only if it is part of the "immediate reaction".
I've also seen an explanation of a player in the NBA getting a defensive rebound and throwing a pass 10 feet to a quick guard, who happened to have a clear path to the basket, and who took off up-court and made an uncontested lay-up. The rebounder got credited with an assist - again, it was an "immediate reaction" to the basket, even though the play started in the player's own half.
From my understanding;
1. Score must be made immediately (ie FG, not FT)
2. The next action the shooter does once the pass is received is shoot or layup.