2017 British Autumn Championships

From 30 Sep 2017 to 01 Oct 2017

Great Britain ----
Great Britain
Weymouth and Portland National Sailing Academy

2017 Semana de Buenos Aires

From 04 Oct 2017 to 16 Oct 2017

Argentina ----
Argentina
Yacht Club Argentino

Ersatztermin ÖJM 2017

From 06 Oct 2017 to 08 Oct 2017

Austria ----
Austria
Union-Yacht-Club Attersee

2017 US SAILING ODP Speed Camp

From 07 Oct 2017 to 09 Oct 2017

USA ----
USA
Clearwater Yacht Club

2017 STACK Winter Championships

From 07 Oct 2017 to 08 Oct 2017

New Zealand ----
New Zealand
Murrays Bay Sailing Club

2017 New Zealand Youth Worlds Trials

From 12 Oct 2017 to 15 Oct 2017

New Zealand ----
New Zealand
Manly Sailing Club

2017 HKSF Youth Championships

From 21 Oct 2017 to 22 Oct 2017

Hong Kong ----
Hong Kong
Royal Hong Kong Yacht Club

2017 Croatian 420 National Championship

From 26 Oct 2017 to 29 Oct 2017

Croatia ----
Croatia
JK Bura
Great Britain ----
Great Britain
Itchenor Sailing Club

2017 Hibiscus Coast Youth Regatta

From 28 Oct 2017 to 28 Oct 2017

New Zealand ----
New Zealand
Manly Sailing Club
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 < '2017-11-1' AND puntual_date >= '2017-10-1') AND (published = 'YES') ORDER BY puntual_date,R.id