DEBUG
294
WITH cteSection AS
(
/* OG
SELECT ROW_NUMBER() OVER (
PARTITION BY JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_activitycode')
Order BY JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_activitycode'),
JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_section')
) AS RowNum,
JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_activitycode') AS ActivityCode,
JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_section') AS SectionNum,
JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_brochurecode') AS BrochureCode,
JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_brochuretext') AS ActivityDescription,
JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_facilitylocation') AS LocationCode,
JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_displayonweb') AS Display
FROM AccuRecTrac
WHERE AccuRecTrac.TableName LIKE 'arsection'
-- [X] TODO - move to api filter
AND JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_archived') = 'false'
--AND JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_displayonweb') LIKE 'Yes'
*/
SELECT ROW_NUMBER() OVER (
PARTITION BY activitycode
Order BY activitycode,
section
) AS RowNum,
activitycode AS ActivityCode,
section AS SectionNum,
brochurecode AS BrochureCode,
brochuretext AS ActivityDescription,
facilitylocation AS LocationCode
FROM AccuRecTrac_arsection
),
cteSectionFilter AS
(
/* OG
SELECT DISTINCT JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_activitycode') AS ActivityCode
FROM AccuRecTrac
WHERE AccuRecTrac.TableName LIKE 'arsection'
-- [X] TODO - move to api filter
AND JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_displayonweb') LIKE 'Yes'
*/
SELECT DISTINCT activitycode AS ActivityCode
FROM AccuRecTrac_arsection
WHERE 1 = 1
),
cteBrochure AS
(
SELECT JSON_VALUE(AccuRecTrac.DataJSON, '$.sacommentcode_commentcode') AS BrochureCode,
JSON_VALUE(AccuRecTrac.DataJSON, '$.sacommentcode_comments') AS ActivityDescription
FROM AccuRecTrac
WHERE AccuRecTrac.TableName LIKE 'sacommentcode'
)
/* OG
SELECT DISTINCT JSON_VALUE(ART.DataJSON, '$.aractivity_activitycode') AS ActivityCode,
JSON_VALUE(ART.DataJSON, '$.aractivity_shortdescription') AS Title,
JSON_VALUE(ART.DataJSON, '$.aractivity_typecode') AS TypeCode,
CASE WHEN Brochure.ActivityDescription IS NOT NULL THEN Brochure.ActivityDescription ELSE SecDesc.ActivityDescription END AS ActivityDescription,
SecDesc.SectionNum as SectionNum,
SecDesc.RowNum
FROM AccuRecTrac AS ART
INNER JOIN cteSection AS SecDesc ON SecDesc.ActivityCode = JSON_VALUE(ART.DataJSON, '$.aractivity_activitycode')
LEFT JOIN cteBrochure AS Brochure ON Brochure.BrochureCode = SecDesc.BrochureCode
-- [] TODO - uncomment as the fallback skip activities with no sections returned will mess with pagination by possibly having less than rpp on a page
--INNER JOIN cteSectionFilter AS Filter ON Filter.ActivityCode = SecDesc.ActivityCode
WHERE ART.TableName LIKE 'aractivity'
-- [X] TODO - move to api filter
AND JSON_VALUE(ART.DataJSON, '$.aractivity_activitycode') <> ''
-- [X] TODO - move to api filter
AND SecDesc.ActivityDescription <> ''
AND RowNum = 1
-- [X] TODO - move to api filter
AND SecDesc.Display LIKE 'Yes'
*/
SELECT DISTINCT ART.activitycode AS ActivityCode,
ART.shortdescription AS Title,
ART.typecode AS TypeCode,
CASE WHEN Brochure.ActivityDescription IS NOT NULL THEN Brochure.ActivityDescription ELSE SecDesc.ActivityDescription END AS ActivityDescription,
SecDesc.SectionNum as SectionNum,
SecDesc.RowNum
FROM AccuRecTrac_aractivity AS ART
INNER JOIN cteSection AS SecDesc ON SecDesc.ActivityCode = ART.activitycode
LEFT JOIN cteBrochure AS Brochure ON Brochure.BrochureCode = SecDesc.BrochureCode
-- [] TODO - uncomment as the fallback skip activities with no sections returned will mess with pagination by possibly having less than rpp on a page
INNER JOIN cteSectionFilter AS Filter ON Filter.ActivityCode = SecDesc.ActivityCode
WHERE SecDesc.RowNum = 1
/* OG
ORDER BY JSON_VALUE(ART.DataJSON, '$.aractivity_typecode')
*/
ORDER BY ART.typecode
;
Programs
4011841 / Hot Shots Sports Gymnastics 101
This introductory course will expose participants to the basics of gymnastics, working on balance and how to control their core and form. Participants will learn how to properly invert themselves and do so in a safe a controlled manner, while also working on basic technique. There will be no specific focus on any one aspect of gymnastics, but a broad study of what it takes to be a gymnast. Skill competitions and individual challenges will be used to provide a fun, safe, and interactive environment to learn and grow. Wear loose fitting clothing, gym shoes and be prepared to have tons of fun!
4011841-1 - Hot Shots Sports Gymnastics 101
Res/NonRes
$163.00/$248.00
6/10/2024 - 8/5/2024
5:00 pm - 6:00 pm
4011841-2 - Hot Shots Sports Gymnastics 101
Res/NonRes
$163.00/$248.00
6/10/2024 - 8/5/2024
6:00 pm - 7:00 pm
4011841-3 - Hot Shots Sports Gymnastics 101
Res/NonRes
$163.00/$248.00
6/15/2024 - 8/10/2024
2:00 pm - 3:00 pm
4011841-4 - Hot Shots Sports Gymnastics 101
Res/NonRes
$163.00/$248.00
6/15/2024 - 8/10/2024
3:00 pm - 4:00 pm
4011842 / Hot Shots Sports Gymnastics 201
This intermediate class will work great for both beginners and those with a solid foundation of gymnastics form and technique. Participants will focus on developing control and balance while learning more advanced concepts on how to control the body during handstands, handsprings, and cartwheels. Kids will be exposed to a general knowledge of all the different events involved in gymnastics, and how each event requires a different skill set.
4011842-1 - Hot Shots Sports Gymnastics 201
Res/NonRes
$145.00/$221.00
6/12/2024 - 8/7/2024
5:00 pm - 6:00 pm
4011842-2 - Hot Shots Sports Gymnastics 201
Res/NonRes
$145.00/$221.00
6/15/2024 - 8/10/2024
4:00 pm - 5:00 pm
4011843 / Hot Shots Sports Mini Tumblers
The next step in our tumbling program, the Mini Tumblers will provide access for beginners, but also continue the development of those who have taken our Tiny Tumbler program. Players will continue to refine basic movements, while also doing more combination movements and increasing their body control. New games and apparatus will be introduced to continue to develop players, while ensuring gear is age appropriate. Skill competitions will be introduced to allow players to compete in a fun and interactive setting. Wear loose fitting clothing, gym shoes and be prepared to have tons of fun!
4011843-1 - Hot Shots Sports Mini Tumblers
Res/NonRes
$136.00/$207.00
6/10/2024 - 8/5/2024
4:15 pm - 5:00 pm
4011843-2 - Hot Shots Sports Mini Tumblers
Res/NonRes
$136.00/$207.00
6/13/2024 - 8/8/2024
10:45 am - 11:30 am
4011843-3 - Hot Shots Sports Mini Tumblers
Res/NonRes
$136.00/$207.00
6/15/2024 - 8/10/2024
1:15 pm - 2:00 pm
4011844 / Hot Shots Sports Tiny Tumblers
This program is perfect for getting your child active and moving in a fun and safe setting. Children are introduced to basic gymnastics and tumbling movements to help them build coordination and body control. Players will execute introductory acrobatic movements such as rolls, twists, handsprings, and somersaults as well as other concepts the instructor deems appropriate after getting to know the class. Fun equipment and apparatus are used to provide participants with fun, challenging, but safe ways to become an amazing tiny tumbler! Wear loose fitting clothing, gym shoes and be prepared to have tons of fun!
4011844-1 - Hot Shots Sports Tiny Tumblers
Res/NonRes
$121.00/$185.00
6/12/2024 - 8/7/2024
4:15 pm - 5:00 pm
4011844-2 - Hot Shots Sports Tiny Tumblers
Res/NonRes
$121.00/$185.00
6/13/2024 - 8/8/2024
10:00 am - 10:45 am
4011844-3 - Hot Shots Sports Tiny Tumblers
Res/NonRes
$121.00/$185.00
6/14/2024 - 8/9/2024
9:45 am - 10:30 am
4011844-4 - Hot Shots Sports Tiny Tumblers
Res/NonRes
$121.00/$185.00
6/15/2024 - 8/10/2024
12:30 pm - 1:15 pm
4011845 / Hot Shots Sports Titan Tumblers
This program blends the technique of our tumbling classes with the fun, upbeat activities of our Ninja Warriors programs. Come in to learn basic stance, rolls, somersaults and twists for tumbling while also getting to end with exciting and fun obstacle courses to ensure a tremendous workout each class. Join us today to learn the basics of Gymnastics while getting the thrill of being a Titan Warrior!
4011845-1 - Hot Shots Sports Titan Tumblers
Res/NonRes
$136.00/$207.00
6/12/2024 - 8/7/2024
11:45 am - 12:30 pm
4011845-2 - Hot Shots Sports Titan Tumblers
Res/NonRes
$136.00/$207.00
6/14/2024 - 8/9/2024
11:15 am - 12:00 pm
4011845-3 - Hot Shots Sports Titan Tumblers
Res/NonRes
$136.00/$207.00
6/12/2024 - 8/7/2024
6:45 pm - 7:30 pm
4011845-4 - Hot Shots Sports Titan Tumblers
Res/NonRes
$136.00/$207.00
6/10/2024 - 8/5/2024
7:00 pm - 7:45 pm