Event Details

You are here: >>


Submit

2020 Sports Medicine in General Practice Course

10/09/2020 08:30 to 13/09/2020 17:00

Venue:

Online and Face to Face Option

Details:

Musculoskeletal medicine is the third most common presentation in General Practice. This course is targeted at improving GP’s examination, diagnostic and management skills in the area of musculoskeletal and sports medicine.

There will be opportunity to learn from nationally recognised experts across the Sports Medicine disciplines, and is an excellent opportunity to network with leading MSK Physicians and Surgeons in Adelaide.

It will provide GP’s with an excellent introduction to Sports Medicine focusing on muscular skeletal examination, diagnostic and management techniques for both common and complex sports injuries. The course is focused around the use of Case Studies.

Location :

Two Options:
Attend in person		Adelaide, South Australia (exact location TBC)
Online:		Participate via Zoom

Dates:

Thursday 10th September to Sunday 13th September 2020

Course Times:

Thursday 10 September	8.30am - 5.00pm
Friday 11 September	8.45am - 5.00pm
Saturday 12 September	8.45am - 5.00pm
Sunday 13 September	8.45am - 1.00pm

Name

Event Start Date

Start Time

Event End Date

End Time

Venue

Event Description

Booking URL

Event Id

2020 Sports Medicine in General Practice Course

10/09/2020

08:30

13/09/2020

17:00

Online and Face to Face Option

Location :

Two Options:
Attend in person		Adelaide, South Australia (exact location TBC)
Online:		Participate via Zoom

Dates:

Thursday 10th September to Sunday 13th September 2020

Course Times:

Thursday 10 September	8.30am - 5.00pm
Friday 11 September	8.45am - 5.00pm
Saturday 12 September	8.45am - 5.00pm
Sunday 13 September	8.45am - 1.00pm

1297

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