Event Details

You are here: >>


Submit

Professional Education: Transitioning from Summer to Winter Sport

15/05/2024 18:00 to 15/05/2024 21:00

Venue:

Karen Rolton Oval (Park 25)

Details:

Join us for our first Professional Education Session of 2024! The Professional Education Program is tailored for those working or studying in the medical and allied health industry.

"Transitioning from Summer to Winter Sport" will highlight considerations for multi-sport athletes moving into the winter sporting seasons following the warmer months, with emphasis on children and adolescents.

The evening will consist of a range of expert speakers, with the opportunity to ask questions and network with the wider medical and allied health community.

Confirmed presenters include... Dr David Spurrier (APA Musculoskeletal and Sports Physiotherapist) and Steven Van Diepen (SASI Strength & Conditioning Coach), with more to come!

DATE: Wednesday the 15th of May 2024

TIMES: 6:00pm - 9:00pm (approx.)

VENUE: Karen Rolton Oval (Park 25), Corner Port Rd & West Tce, Adelaide SA

COST: SASMA Member $20 / Non-Member $35

Name	Event Start Date	Start Time	Event End Date	End Time	Venue	Event Description	Booking URL	Event Id

Professional Education: Transitioning from Summer to Winter Sport	15/05/2024	18:00	15/05/2024	21:00	Karen Rolton Oval (Park 25)	Join us for our first Professional Education Session of 2024! The Professional Education Program is tailored for those working or studying in the medical and allied health industry. "Transitioning from Summer to Winter Sport" will highlight considerations for multi-sport athletes moving into the winter sporting seasons following the warmer months, with emphasis on children and adolescents. The evening will consist of a range of expert speakers, with the opportunity to ask questions and network with the wider medical and allied health community. Confirmed presenters include... Dr David Spurrier (APA Musculoskeletal and Sports Physiotherapist) and Steven Van Diepen (SASI Strength & Conditioning Coach), with more to come! DATE: Wednesday the 15th of May 2024 TIMES: 6:00pm - 9:00pm (approx.) VENUE: Karen Rolton Oval (Park 25), Corner Port Rd & West Tce, Adelaide SA COST: SASMA Member $20 / Non-Member $35	Register Now	1773

Dynamic Loaded - Select Name ,CONVERT(VARCHAR(12),Event.StartDate,103) AS EventStartDate ,StartTime ,CONVERT(VARCHAR(12),event.EndDate,103) AS EventEndDate ,EndTime ,Venue ,EventDescription ,CASE WHEN EventStatus = 'Open' AND AvailableOnline = 1 AND StartDate >= DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) THEN CASE WHEN RegistrationLimit is not null and RegistrationLimit > 0 and RegistrationLimit <= attendeeNumbers.NoAttendees THEN 'SOLD OUT' ELSE 'Register Now' END WHEN Event.HtmlGalleryLink IS NOT NULL AND Event.HtmlGalleryLink <> '' THEN 'Image Gallery' ELSE '' END AS BookingURL ,Event.EventId FROM Event left outer join ( select EventRegistrationType.EventId as Eid, COUNT(1) as NoAttendees from EventAttendee inner join EventRegistration on EventAttendee.EventRegistrationId = EventRegistration.EventRegistrationId inner join EventRegistrationType on EventRegistration.EventRegistrationTypeId = EventRegistrationType.EventRegistrationTypeId where PrimaryEvent = 1 group by EventRegistrationType.EventId ) attendeeNumbers on Event.EventId = attendeeNumbers.Eid WHERE Event.EventId = [QRY-EventId]
Dynamic Alternate Loaded -
Security - Edit Roles set to
Security - Add Roles set to
Security - Delete Roles set to
Using Existing Dynamic Set - Select Name ,CONVERT(VARCHAR(12),Event.StartDate,103) AS EventStartDate ,StartTime ,CONVERT(VARCHAR(12),event.EndDate,103) AS EventEndDate ,EndTime ,Venue ,EventDescription ,CASE WHEN EventStatus = 'Open' AND AvailableOnline = 1 AND StartDate >= DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) THEN CASE WHEN RegistrationLimit is not null and RegistrationLimit > 0 and RegistrationLimit <= attendeeNumbers.NoAttendees THEN 'SOLD OUT' ELSE 'Register Now' END WHEN Event.HtmlGalleryLink IS NOT NULL AND Event.HtmlGalleryLink <> '' THEN 'Image Gallery' ELSE '' END AS BookingURL ,Event.EventId FROM Event left outer join ( select EventRegistrationType.EventId as Eid, COUNT(1) as NoAttendees from EventAttendee inner join EventRegistration on EventAttendee.EventRegistrationId = EventRegistration.EventRegistrationId inner join EventRegistrationType on EventRegistration.EventRegistrationTypeId = EventRegistrationType.EventRegistrationTypeId where PrimaryEvent = 1 group by EventRegistrationType.EventId ) attendeeNumbers on Event.EventId = attendeeNumbers.Eid WHERE Event.EventId = [QRY-EventId]
Executed SQL - Select Name ,CONVERT(VARCHAR(12),Event.StartDate,103) AS EventStartDate ,StartTime ,CONVERT(VARCHAR(12),event.EndDate,103) AS EventEndDate ,EndTime ,Venue ,EventDescription ,CASE WHEN EventStatus = 'Open' AND AvailableOnline = 1 AND StartDate >= DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) THEN CASE WHEN RegistrationLimit is not null and RegistrationLimit > 0 and RegistrationLimit <= attendeeNumbers.NoAttendees THEN 'SOLD OUT' ELSE 'Register Now' END WHEN Event.HtmlGalleryLink IS NOT NULL AND Event.HtmlGalleryLink <> '' THEN 'Image Gallery' ELSE '' END AS BookingURL ,Event.EventId FROM Event left outer join ( select EventRegistrationType.EventId as Eid, COUNT(1) as NoAttendees from EventAttendee inner join EventRegistration on EventAttendee.EventRegistrationId = EventRegistration.EventRegistrationId inner join EventRegistrationType on EventRegistration.EventRegistrationTypeId = EventRegistrationType.EventRegistrationTypeId where PrimaryEvent = 1 group by EventRegistrationType.EventId ) attendeeNumbers on Event.EventId = attendeeNumbers.Eid WHERE Event.EventId = 1773 AND EventId LIKE '%1773%'