Event Details

You are here: >>


Submit

2018 SASMA AGM & Education Finale

20/11/2018 18:30 to 20/11/2018 21:00

Venue:

The Hilton Hotel - Board Room

Details:

2018 SA Sports Medicine Association

Annual General Meeting & Education Finale

Date:	Tuesday 20th November 2018

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*
		"Indigenous culture in professional Australian football club"
		- Dr Marc Cesana, Adelaide Crows Chief Medical Officer
		"ACL risk reduction strategies: How to implement in the real world"
		- Kate Beerworth, APA Sports Physiotherapist, FFA National ACL Prevention & Injury Prevention Co-ordinator
		"Adolescent foot injuries"
		- Carlie Altmann, Podiatrist, Clinical Supervisor at UniSA
		"Interesting case: Groin pain in an athlete"
		- Dr Kevyn Hernandez, ACSEP Sports & Exercise Physician Registrar
	8:25pm	Presentation of the Owen Bowering Prize for the 2018 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

2018 SASMA AGM & Education Finale

20/11/2018

18:30

20/11/2018

21:00

The Hilton Hotel - Board Room

2018 SA Sports Medicine Association

Annual General Meeting & Education Finale

Date:	Tuesday 20th November 2018

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*
		"Indigenous culture in professional Australian football club"
		- Dr Marc Cesana, Adelaide Crows Chief Medical Officer
		"ACL risk reduction strategies: How to implement in the real world"
		- Kate Beerworth, APA Sports Physiotherapist, FFA National ACL Prevention & Injury Prevention Co-ordinator
		"Adolescent foot injuries"
		- Carlie Altmann, Podiatrist, Clinical Supervisor at UniSA
		"Interesting case: Groin pain in an athlete"
		- Dr Kevyn Hernandez, ACSEP Sports & Exercise Physician Registrar
	8:25pm	Presentation of the Owen Bowering Prize for the 2018 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.

1104

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