Event Details

You are here: >>


Submit

2024 Paris Olympic Conversations

12/12/2024 18:30 to 12/12/2024 21:00

Venue:

NEW SASI Complex

Details:

Join us for our final education session of 2024! Hear from a range of Olympic and Paralympic athletes, as well as SASMA Members who were involved with the Paris Olympic Games.

This session is open to both sports trainers, and those working or studying in the medical and allied health industry.

The evening will consist of a range of speakers, with the opportunity to ask questions and network with the wider Sports Medicine community.

---

DATE: Thursday 12th December 2024

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

VENUE: New SASI Complex (new SASMA location), Railway Tce, Mile End

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

2024 Paris Olympic Conversations	12/12/2024	18:30	12/12/2024	21:00	NEW SASI Complex	Join us for our final education session of 2024! Hear from a range of Olympic and Paralympic athletes, as well as SASMA Members who were involved with the Paris Olympic Games. This session is open to both sports trainers, and those working or studying in the medical and allied health industry. The evening will consist of a range of speakers, with the opportunity to ask questions and network with the wider Sports Medicine community. --- DATE: Thursday 12th December 2024 TIMES: 7:00pm - 9:00pm (approx.) VENUE: New SASI Complex (new SASMA location), Railway Tce, Mile End COST: SASMA Member $20 / Non-Member $35	Register Now	1788

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