Czech Republic ----
Czech Republic
Jachetni Klub Cerna v Posumavi

2017 Western Australia Youth Championships

From 27 Sep 2017 to 28 Sep 2017

Australia ----
Australia
Cruising Yacht Club of Western Australia

2017 British Autumn Championships

From 30 Sep 2017 to 01 Oct 2017

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

2017 Atlantic Coast Championship

From 30 Sep 2017 to 01 Oct 2017

USA ----
USA
Indian Harbor Yacht Club

2017 CSP Thalwil

From 30 Sep 2017 to 01 Oct 2017

Switzerland ----
Switzerland
Seglervereinigung Thalwil

2017 NSW State Youth Championships

From 30 Sep 2017 to 02 Oct 2017

Australia ----
Australia
South Lake Macquarie Amateur Sailing Club

2017 Czech Cup Series Regatta

From 30 Sep 2017 to 01 Oct 2017

Czech Republic ----
Czech Republic
Jachetní klub Černá v Pošumaví
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-10-1' AND puntual_date >= '2017-9-1') AND (published = 'YES') ORDER BY puntual_date,R.id