Event Details

You are here: >>


Submit

CONCUSSION WORKSHOP / Woodville South FC

22/07/2024 17:00 to 22/07/2024 19:00

Venue:

Woodville South FC

Details:

The SA Sports Medicine Association, with the support of the Office for Recreation, Sport and Racing are bringing important Concussion Education to the sporting community in 2024.

Register below for this community workshop to hear the latest advice on the invisible injury, recognising the signs and symptoms, and understand the role we ALL have in managing Concussion in community sport.

DATE: Monday 22nd July 2024

TIMES: 5:00pm - 7:00pm

VENUE: Woodville South FC / 108 Ledger Rd, Woodville South SA 5011

TICKETS: This event is exclusive to the Woodville South FC.

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