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(3762)
}
}
As for the out of bounds, the previous posts are right, ball touches something out of court, the roof, or the back of or supporting structure for the backboard (NOT the sides, top, or bottom of the board. That is still "in-bounds". Problem here is that a lot of supporting framework is close to the sides of the board, making it hard to tell unless you are looking straight at it).
As for subs, a player who is subbed out CAN leave the court anywhere. As has been pointed out, this can cause problems, and referees prefer that the players do go straight across the court to his/her bench. This makes it much simpler for them, as well as the teams if the game has restarted, to know who is on or off court.
A referee asking a player to go straight to the bench rather than walking around the lines, I consider to be a reasonable request. Otherwise, if there is a little bit of tension in the game, I do not start the game until the player concerned has at least gone past the opposition's bench, making sure that nothing happens.