Event Details

You are here: >>


Submit

ADVANCED SPORTS TAPING COURSE / NARACOORTE

26/05/2024 09:30 to 26/05/2024 12:30

Venue:

Good Country Physiotherapy

Details:

Inviting all sports trainers to join us for an Advanced Taping Course this May in the Southeast! Presented by local Physiotherapist and SASMA Member, Angela Willsmore.

Includes a variety of upper and lower limb taping;

UPPER LIMB / Wrist, Elbow, Shoulder, AC Joint, Back

LOWER LIMB / Planter Fasciitis & Arch Support, Achilles, Medial/Lateral Knee, Patella Strap, McConnell Taping, ACL Taping, Advanced Ankle

DATE: Sunday 26th May, 2024

TIMES: 9:30am - 12:30pm (approx)

VENUE: Good Country Physiotherapy / 157 Smith Street, Naracoorte

COST: SASMA Accredited Trainer - $20 / Non-Member - $35

Name	Event Start Date	Start Time	Event End Date	End Time	Venue	Event Description	Booking URL	Event Id

ADVANCED SPORTS TAPING COURSE / NARACOORTE	26/05/2024	09:30	26/05/2024	12:30	Good Country Physiotherapy	Inviting all sports trainers to join us for an Advanced Taping Course this May in the Southeast! Presented by local Physiotherapist and SASMA Member, Angela Willsmore. Includes a variety of upper and lower limb taping; UPPER LIMB / Wrist, Elbow, Shoulder, AC Joint, Back LOWER LIMB / Planter Fasciitis & Arch Support, Achilles, Medial/Lateral Knee, Patella Strap, McConnell Taping, ACL Taping, Advanced Ankle DATE: Sunday 26th May, 2024 TIMES: 9:30am - 12:30pm (approx) VENUE: Good Country Physiotherapy / 157 Smith Street, Naracoorte COST: SASMA Accredited Trainer - $20 / Non-Member - $35	Register Now	1771

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