stdClass Object
(
[pts] => Array
(
)
[rbs] => Array
(
)
[ast] => Array
(
)
[stl] => Array
(
)
[blk] => Array
(
)
[turnovers] => Array
(
)
[fg_percent] => Array
(
)
[ft_percent] => Array
(
)
[three_pt] => Array
(
)
[brand] => 3ssb
[type] => boys
[level] => 17U
[event] => all
[org] => 11341
[sql] =>
WITH player_stats AS ( SELECT
s.player,
p.name,
p.profile_img,
GROUP_CONCAT(DISTINCT g.division) AS game_division,
ROUND(AVG(CAST(JSON_UNQUOTE(JSON_EXTRACT(s.stats, '$.pts')) AS UNSIGNED)), 1) AS pts,
ROUND(AVG(CAST(JSON_UNQUOTE(JSON_EXTRACT(s.stats, '$.rbs')) AS UNSIGNED)), 1) AS rbs,
ROUND(AVG(CAST(JSON_UNQUOTE(JSON_EXTRACT(s.stats, '$.ast')) AS UNSIGNED)), 1) AS ast,
ROUND(AVG(CAST(JSON_UNQUOTE(JSON_EXTRACT(s.stats, '$.stl')) AS UNSIGNED)), 1) AS stl,
ROUND(AVG(CAST(JSON_UNQUOTE(JSON_EXTRACT(s.stats, '$.blk')) AS UNSIGNED)), 1) AS blk,
ROUND(AVG(CAST(JSON_EXTRACT(s.stats, '$.turnovers') AS DECIMAL(10,2))), 1) AS turnovers,
ROUND(AVG(CAST(JSON_UNQUOTE(JSON_EXTRACT(s.stats, '$.fg_percentage')) AS DECIMAL(10,2))), 1) AS fg_percent,
ROUND(AVG(CAST(JSON_UNQUOTE(JSON_EXTRACT(s.stats, '$.ft_percentage')) AS DECIMAL(10,2))), 1) AS ft_percent,
ROUND(AVG(CAST(JSON_UNQUOTE(JSON_EXTRACT(s.stats, '$.three_pt_percentage')) AS DECIMAL(10,2))), 1) AS three_pt
FROM
wp_54ab678738_g365_stats s
LEFT JOIN
wp_54ab678738_g365_players p ON s.player = p.id
INNER JOIN
wp_54ab678738_g365_events e ON s.event = e.id
INNER JOIN
wp_54ab678738_g365_games g ON s.game = g.id
WHERE
e.org = '11341'
AND e.eventtime >= '2024-08-16 00:00:00' AND e.eventtime <= '2025-08-15 00:00:00'
AND s.enabled = 1
AND JSON_UNQUOTE(JSON_EXTRACT(p.notes, '$.gender')) = 'boy'
AND g.division LIKE '%17U%'
GROUP BY
s.player, p.name, p.profile_img )
SELECT * FROM (
SELECT
player,
name,
profile_img,
pts AS stat_value,
'pts' AS stat,
ROW_NUMBER() OVER (ORDER BY pts DESC) AS stat_rank
FROM player_stats
WHERE pts IS NOT NULL
ORDER BY pts DESC
LIMIT 5
) AS pts_leaders
UNION ALL
SELECT * FROM (
SELECT
player,
name,
profile_img,
rbs AS stat_value,
'rbs' AS stat,
ROW_NUMBER() OVER (ORDER BY rbs DESC) AS stat_rank
FROM player_stats
WHERE rbs IS NOT NULL
ORDER BY rbs DESC
LIMIT 5
) AS rbs_leaders
UNION ALL
SELECT * FROM (
SELECT
player,
name,
profile_img,
ast AS stat_value,
'ast' AS stat,
ROW_NUMBER() OVER (ORDER BY ast DESC) AS stat_rank
FROM player_stats
WHERE ast IS NOT NULL
ORDER BY ast DESC
LIMIT 5
) AS ast_leaders
UNION ALL
SELECT * FROM (
SELECT
player,
name,
profile_img,
stl AS stat_value,
'stl' AS stat,
ROW_NUMBER() OVER (ORDER BY stl DESC) AS stat_rank
FROM player_stats
WHERE stl IS NOT NULL
ORDER BY stl DESC
LIMIT 5
) AS stl_leaders
UNION ALL
SELECT * FROM (
SELECT
player,
name,
profile_img,
blk AS stat_value,
'blk' AS stat,
ROW_NUMBER() OVER (ORDER BY blk DESC) AS stat_rank
FROM player_stats
WHERE blk IS NOT NULL
ORDER BY blk DESC
LIMIT 5
) AS blk_leaders
UNION ALL
SELECT * FROM (
SELECT
player,
name,
profile_img,
turnovers AS stat_value,
'turnovers' AS stat,
ROW_NUMBER() OVER (ORDER BY turnovers DESC) AS stat_rank
FROM player_stats
WHERE turnovers IS NOT NULL
ORDER BY turnovers DESC
LIMIT 5
) AS turnovers_leaders
UNION ALL
SELECT * FROM (
SELECT
player,
name,
profile_img,
fg_percent AS stat_value,
'fg_percent' AS stat,
ROW_NUMBER() OVER (ORDER BY fg_percent DESC) AS stat_rank
FROM player_stats
WHERE fg_percent IS NOT NULL
ORDER BY fg_percent DESC
LIMIT 5
) AS fg_percent_leaders
UNION ALL
SELECT * FROM (
SELECT
player,
name,
profile_img,
ft_percent AS stat_value,
'ft_percent' AS stat,
ROW_NUMBER() OVER (ORDER BY ft_percent DESC) AS stat_rank
FROM player_stats
WHERE ft_percent IS NOT NULL
ORDER BY ft_percent DESC
LIMIT 5
) AS ft_percent_leaders
UNION ALL
SELECT * FROM (
SELECT
player,
name,
profile_img,
three_pt AS stat_value,
'three_pt' AS stat,
ROW_NUMBER() OVER (ORDER BY three_pt DESC) AS stat_rank
FROM player_stats
WHERE three_pt IS NOT NULL
ORDER BY three_pt DESC
LIMIT 5
) AS three_pt_leaders
ORDER BY stat, stat_rank;
[event_list] => Array
(
[0] => stdClass Object
(
[short_name] => 3SSB Boys Bryan 2025
[id] => 1117
)
[1] => stdClass Object
(
[short_name] => 3SSB Boys Council Bluffs (Live Event) 2025
[id] => 1118
)
[2] => stdClass Object
(
[short_name] => 3SSB Boys Ladera - West Regional 2025
[id] => 1115
)
[3] => stdClass Object
(
[short_name] => 3SSB Boys South Carolina (Live Event) 2025
[id] => 1119
)
[4] => stdClass Object
(
[short_name] => 3SSB Earn Your Stripes Invitational 2025
[id] => 1116
)
[5] => stdClass Object
(
[short_name] => 3SSB Girls Bryan 2025
[id] => 1121
)
[6] => stdClass Object
(
[short_name] => 3SSB Girls South Carolina (Live Event) 2025
[id] => 1122
)
[7] => stdClass Object
(
[short_name] => adidas 3SSB Girls Spring Session I (Rock Hill)
[id] => 1120
)
)
)
| Points per Game |
|---|
No points leaders available.
| Rebounds per Game |
|---|
No rebounds leaders available.
| Assists per game |
|---|
No assists leaders available.
| Steals per game |
|---|
No steals leaders available.
| Blocks per game |
|---|
No blocks leaders available.
| Field Goal % |
|---|
No field goal percent leaders available.
| Free Throw % |
|---|
No free throw percent leaders available.
| 3 Point % |
|---|
No three point leaders available.