Canada National 420 Class Association
CAN
From 13 Aug 2018 to 17 Aug 2018
Canada
Portsmouth Olympic Harbour
From 21 Sep 2018 to 23 Sep 2018
Canada
Portsmouth Olympic Harbour
From 22 Sep 2017 to 24 Sep 2017
Canada
Portsmouth Olympic Harbour
From 13 Aug 2017 to 17 Aug 2017
Canada
Portsmouth Olympic Harbour
Linking with CORK, the International 420 Class is hosting a 420 Class Clinic from 9-13 August - find out more
From 09 Aug 2017 to 13 Aug 2017
Canada
Portsmouth Olympic Harbour
The Class Development plan for 2017 includes the running of 420 Coaches and Sailors clinics in 8 countries around the world. The clinic in Canada will be led by Michalis Mileos (GRE) who will be sharing his knowledge and expertise. Take a read of the Clinic Programme and General Conditions and make sure you apply to participate by the deadline of 5 August 2017 via https://www.facebook.com/i420Canada
From 27 May 2017 to 28 May 2017
Canada
Royal Nova Scotia Yacht Squadron
From 10 Aug 2014 to 14 Aug 2014
Canada
Portsmouth Olympic Harbour
From 17 May 2014 to 18 May 2014
Canada
Toronto Sailing and Canoe Club
From 28 May 2011 to 29 May 2011
Canada
Royal Hamilton Yacht Club
From 12 Jul 2007 to 21 Jul 2007
Canada
Portsmouth Olympic Harbour
CANADIAN 420 PARTNERSHIP HONOURED WITH SAILOR OF THE MONTH AWARD
420 General Event News
Read more
CANADA’S CORK FALL REGATTA WON BY LEWIN-LAFRANCE/ GILLIS
420 General Event News
Read more
CORK INTERNATIONAL REGATTA PUTS 420 TEAMS THROUGH THEIR PACES
420 General Event News
Read more
420 CLASS COACHES AND SAILORS CLINIC IN CANADA
Development News
Read more
JOIN THE 420 CLASS COACHES AND SAILORS CLINIC IN CANADA
Development News
Read more
STRONG 420 CLASS LINE-UP AT CANADA'S SPRING DINGHY REGATTA
420 General Event News
Read more
SIGN UP TO 2017 420 CLASS COACH AND SAILOR CLINICS
Development News
Read more
SIGN UP TO 2017 420 CLASS COACH AND SAILOR CLINICS
Development News
Read more
420 CLASS SECURES ITS PLACE AT CANADA'S PREMIER MULTI-CLASS EVENT
420 General Event News
Read more
2017 420 DEVELOPMENT PROGRAMMES
Development News
Read more
USA'S ROGERS/PARKIN RACK UP ANOTHER 420 CHAMPIONSHIP TITLE
420 National Championships
Read more
CANADA ANNOUNCES 420 CLASS TEAM FOR YOUTH WORLDS
WS Youth
Read more
420 Sailors Qualify Canada and Chile to Rio 2016 Olympics in 470 Women
420 General News
Read more
SELECT DISTINCT R.id
FROM gerace R
INNER JOIN genericelements GE ON GE.id = R.id_genericelement
INNER JOIN racecalendar RC ON RC.id_gerace = R.id
LEFT JOIN sailclass2gerace SC2GER ON SC2GER.id_gerace = R.id
left JOIN gerelations GER ON R.id_genericelement = GER.id_ge_1
left JOIN geclub C ON C.id_genericelement = GER.id_ge_2
WHERE (C.id IN (549,375,337,309,191)) AND (published = 'YES') AND (end_date >= '2018-06-24T06:55:07+02:00' OR puntual_date >= '2018-06-24T06:55:07+02:00')
ORDER BY puntual_date ASC,R.id
SELECT DISTINCT R.id
FROM gerace R
INNER JOIN genericelements GE ON GE.id = R.id_genericelement
INNER JOIN racecalendar RC ON RC.id_gerace = R.id
LEFT JOIN sailclass2gerace SC2GER ON SC2GER.id_gerace = R.id
left JOIN gerelations GER ON R.id_genericelement = GER.id_ge_1
left JOIN geclub C ON C.id_genericelement = GER.id_ge_2
WHERE (C.id IN (549,375,337,309,191)) AND (published = 'YES') AND (end_date <= '2018-06-24T06:55:07+02:00' )
ORDER BY puntual_date DESC,R.id
