Event Details

You are here: >>


Submit

2019 SASMA AGM & Education Finale

25/11/2019 18:30 to 25/11/2019 21:00

Venue:

The Hilton Hotel - Board Room

Details:

2019 SA Sports Medicine Association

Annual General Meeting & Education Finale

Date:	Monday 25th November 2019

Venue:	Hilton Hotel, 264 South Road, Hilton, SA

Times:	6:30pm	Networking Drinks & Finger Food for Members & Partners
	7:00pm	SA Sports Medicine Association Annual General Meeting
	7:20pm	*Education Finale* "Interesting Case: 17yo with heel pain" - Dr Robert Buckley, Sports Physician Registrar "Interesting Case: Leg pain in a runner" - Dr Sandy Kleinschmidt, Sports Physician Registrar "Clinical decision making process for high ankle (syndesmosis) sprains" - Dr Anthony Nguyen, Orthopaedic Surgeon Foot & Ankle Specialty, SPORTSMED SA "Maxiskate and its role in rehabilitation" - Dr Matthew Liptak, Orthopaedic Surgeon, Orthopaedics SA "Biomechanics of mid-substance Achilles tendinopathy" - Dr Geoffrey Verrall, Sports & Exercise Physician, SPARC (Sports & Arthritis Clinic)
	8:25pm	Presentation of the Owen Bowering Prize for the 2019 Sports Medicine in General Practice Course
	8:30pm - 9:00pm	Formalities Conclude & further networking with drinks & finger food

To Register click on "Register Now" below.

Name

Event Start Date

Start Time

Event End Date

End Time

Venue

Event Description

Booking URL

Event Id

2019 SASMA AGM & Education Finale

25/11/2019

18:30

25/11/2019

21:00

The Hilton Hotel - Board Room

2019 SA Sports Medicine Association

Annual General Meeting & Education Finale

Date:	Monday 25th November 2019

Venue:	Hilton Hotel, 264 South Road, Hilton, SA

Times:	6:30pm	Networking Drinks & Finger Food for Members & Partners
	7:00pm	SA Sports Medicine Association Annual General Meeting
	7:20pm	*Education Finale* "Interesting Case: 17yo with heel pain" - Dr Robert Buckley, Sports Physician Registrar "Interesting Case: Leg pain in a runner" - Dr Sandy Kleinschmidt, Sports Physician Registrar "Clinical decision making process for high ankle (syndesmosis) sprains" - Dr Anthony Nguyen, Orthopaedic Surgeon Foot & Ankle Specialty, SPORTSMED SA "Maxiskate and its role in rehabilitation" - Dr Matthew Liptak, Orthopaedic Surgeon, Orthopaedics SA "Biomechanics of mid-substance Achilles tendinopathy" - Dr Geoffrey Verrall, Sports & Exercise Physician, SPARC (Sports & Arthritis Clinic)
	8:25pm	Presentation of the Owen Bowering Prize for the 2019 Sports Medicine in General Practice Course
	8:30pm - 9:00pm	Formalities Conclude & further networking with drinks & finger food

To Register click on "Register Now" below.

1284

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