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(34159)
}
}
Anonymous
Years ago
Stat query about fouls on shot attempts
Hi all thanks for the info. Devo I'm using Scoutlit Basketball which seems to be easy enough to use . We're do u access Livestats from. Thanks
If a player is fouled while attempting a field goal, an assist is awarded to the player who passed to the shooter, provided the pass meets the criteria described in this section and:
- The shot is made and the basket counted or
- The shot is missed but one or more of the resulting free throws is successful. The free throws must be the result of the foul on the shooter and not a team foul penalty.
The new version of the Livestats allows for the assist to be entered at the same time as recording the free throws.
Shot is originally called a shot. If a foul occurs and the shot is missed the shot call is reversed and foul recorded.
If there was a potential assist which was lost because of the foul then it is recorded as an assist if one or more shots are made.
No such thing as a ghost shot. If you are fouled while shooting then the missed shot is not counted. The player will receive free throws, 2 or 3, depending on where the foul was committed.