Event Details

You are here: >>


Submit

Sideline Help and Concussion / OLYMPIC DAM

02/03/2025 10:00 to 02/03/2025 12:00

Venue:

Olympic Dam Sporting Club

Details:

The SA Sports Medicine Association is excited to be running a number of community workshops at the Olympic Dam Sporting Club in March 2025. This education is ideal for those living in the Far North of SA, equipping them with practical skills and knowledge to promote a safer sporting and active environment.

Thank you to the Olympic Dam Sporting Club, SANFL, Sport SA, MediPro Sports Tape & Medical and the Office for Recreation, Sport and Racing for their support of this education.

The Sideline Help and Concussion Workshop introduces attendees to a range of injury prevention and management principles. Including soft and hard tissue injury management, on/off field injury assessments, concussion management, wound management and more.

EVENT: Sideline Help and Concussion

DATE: Sunday 2nd March 2025

TIMES: 10:00am - 12:00pm

VENUE: Olympic Dam Sporting Club, Olympic Way

TICKETS: NO COST to attendees, thanks to the support of the Olympic Dam SC

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

Sideline Help and Concussion / OLYMPIC DAM	02/03/2025	10:00	02/03/2025	12:00	Olympic Dam Sporting Club	The SA Sports Medicine Association is excited to be running a number of community workshops at the Olympic Dam Sporting Club in March 2025. This education is ideal for those living in the Far North of SA, equipping them with practical skills and knowledge to promote a safer sporting and active environment. Thank you to the Olympic Dam Sporting Club, SANFL, Sport SA, MediPro Sports Tape & Medical and the Office for Recreation, Sport and Racing for their support of this education. The Sideline Help and Concussion Workshop introduces attendees to a range of injury prevention and management principles. Including soft and hard tissue injury management, on/off field injury assessments, concussion management, wound management and more. EVENT: Sideline Help and Concussion DATE: Sunday 2nd March 2025 TIMES: 10:00am - 12:00pm VENUE: Olympic Dam Sporting Club, Olympic Way TICKETS: NO COST to attendees, thanks to the support of the Olympic Dam SC	Register Now	1830

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 = 1830 AND EventId LIKE '%1830%'