2018 International 420 High Level Coaches' Clinic

From 03 Oct 2018 to 07 Oct 2018

Portugal ----
Portugal
Vilamoura Sailing Centre
Italy ----
Italy
Campione Univela

2018 San Diego Olympic Classes Regatta

From 05 Oct 2018 to 07 Oct 2018

USA ----
USA
San Diego Yacht Club

2018 AYC High Performance Regatta

From 06 Oct 2018 to 07 Oct 2018

USA ----
USA
American Yacht Club

2018 Spandauer Eis Cup

From 06 Oct 2018 to 07 Oct 2018

Germany ----
Germany
Spandauer Yacht Club

Turkish Training Camp #6

From 10 Oct 2018 to 14 Oct 2018

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

2018 Sail Sandy

From 13 Oct 2018 to 14 Oct 2018

Australia ----
Australia
Sandringham Yacht Club

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
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