Event Details

You are here: >>


Submit

Sideline Help and Concussion / MILLICENT

07/02/2025 18:30 to 07/02/2025 20:30

Venue:

TBC

Details:

The SA Sports Medicine Association is excited to be running a number of community workshops at the Southeast in February 2025. This education is ideal for those living in the region, equipping them with practical skills and knowledge to promote a safer sporting and active environment.

Thank you to the Limestone Coast LGA, 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: Friday 7th February 2025

TIMES: 6:30pm - 8:30pm

VENUE: TBC - Millicent.

TICKETS: $20 per person

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

Sideline Help and Concussion / MILLICENT	07/02/2025	18:30	07/02/2025	20:30	TBC	The SA Sports Medicine Association is excited to be running a number of community workshops at the Southeast in February 2025. This education is ideal for those living in the region, equipping them with practical skills and knowledge to promote a safer sporting and active environment. Thank you to the Limestone Coast LGA, 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: Friday 7th February 2025 TIMES: 6:30pm - 8:30pm VENUE: TBC - Millicent. TICKETS: $20 per person	Register Now	1835

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