DEBUG
9
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
AND (subtype LIKE 'Gymnastics')
),
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
AND (/* OG JSON_VALUE(ART.DataJSON, '$.aractivity_typecode') LIKE 'Youth Athletics' */ ART.typecode LIKE 'Youth Athletics')
/* OG
ORDER BY JSON_VALUE(ART.DataJSON, '$.aractivity_typecode')
*/
ORDER BY ART.typecode
;
4011502 / Gymnastics Rising Stars
Are you looking for a fun class for your child? Your star learns basic tumbling, bars, beam, vaulting skills, and movements associated with gymnastics at an appropriate level for their age. This class develops coordination, self-confidence, listening, strength, balance, and body awareness. Please note that children need to participate without parent assistance.
4011502-1 - Gymnastics Rising Stars
Res/NonRes
$126.00/$126.00
7/1/2024 - 8/26/2024
9:55 am - 10:25 am
4011502-2 - Gymnastics Rising Stars
Res/NonRes
$126.00/$126.00
7/2/2024 - 8/27/2024
9:55 am - 10:25 am
4011502-3 - Gymnastics Rising Stars
Res/NonRes
$126.00/$126.00
7/3/2024 - 8/28/2024
9:55 am - 10:25 am
4011840 / Hot Shots Sports Adult-Tot Tumbling
Your child's physical, mental, emotional, and social skills are developed through this fun and challenging class. Children are introduced to age-appropriate exercises specifically designed for balance and coordination of their large muscle groups. Through basic gymnastics and movement, participants experience their world in a whole new way and begin to understand how their bodies work. Wear loose fitting clothing, gym shoes and be prepared to have tons of fun! Parent or caregiver participation is required.
4011840-1 - Hot Shots Sports Adult-Tot Tumbling
Res/NonRes
$121.00/$185.00
6/12/2024 - 8/7/2024
6:00 pm - 6:45 pm
4011840-2 - Hot Shots Sports Adult-Tot Tumbling
Res/NonRes
$121.00/$185.00
6/13/2024 - 8/8/2024
9:15 am - 10:00 am
4011840-3 - Hot Shots Sports Adult-Tot Tumbling
Res/NonRes
$121.00/$185.00
6/15/2024 - 8/10/2024
11:15 am - 12:00 pm
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