2018 International 420 High Level Coaches' Clinic

From 03 Oct 2018 to 07 Oct 2018

Portugal ----
Portugal
Vilamoura Sailing Centre

Turkish Training Camp #6

From 10 Oct 2018 to 14 Oct 2018

Turkey ----
Turkey
Çeşme Paşalimanı Kamp

Turkish Training Camp #7

From 17 Oct 2018 to 21 Oct 2018

Turkey ----
Turkey
Çeşme Paşalimanı Kamp

2018 British 420 Inland Championships

From 20 Oct 2018 to 21 Oct 2018

Great Britain ----
Great Britain
Rutland Sailing Club

2018 420 Lovran Regatta

From 20 Oct 2018 to 21 Oct 2018

Croatia ----
Croatia
Jedriličarski Klub Istra

Turkish Training Camp #8

From 23 Oct 2018 to 25 Oct 2018

Turkey ----
Turkey
Çeşme Paşalimanı Kamp

2018 Croatian 420 National Championship

From 26 Oct 2018 to 28 Oct 2018

Croatia ----
Croatia
JK Omis

2018 French National d'Automne

From 30 Oct 2018 to 04 Nov 2018

France ----
France
Cercle de la Voile de Bordeaux
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 WHERE (puntual_date < '2018-11-1' AND puntual_date >= '2018-10-1') AND (published = 'YES') ORDER BY puntual_date,R.id