2017 I Trofeo Mestre Rafel

From 16 Sep 2017 to 17 Sep 2017

Spain ----
Spain
Club Nautic S Arenal

2017 Ataturk Cup

From 18 Sep 2017 to 23 Sep 2017

Turkey ----
Turkey
Yalikavak

2017 Queensland Youth Camp and Championships

From 19 Sep 2017 to 24 Sep 2017

Australia ----
Australia
Keppel Bay Sailing Club

2017 Fall CORK Regatta

From 22 Sep 2017 to 24 Sep 2017

Canada ----
Canada
Portsmouth Olympic Harbour

2017 Pacific Rim School Team Sailing Championships

From 22 Sep 2017 to 26 Sep 2017

Australia ----
Australia
Sandringham Yacht Club

2017 Open Event - Qatar

From 22 Sep 2017 to 23 Sep 2017

Qatar ----
Qatar
Doha Marine Sports Club

2017 CSP Kreuzlingen

From 23 Sep 2017 to 24 Sep 2017

Switzerland ----
Switzerland
Yacht Club Kreuzlingen

RYA Northern Ireland Youth Championships

From 23 Sep 2017 to 24 Sep 2017

Great Britain ----
Great Britain
Ballyholme Yacht Club

2017 Springsail Regatta

From 23 Sep 2017 to 24 Sep 2017

Australia ----
Australia
Royal Geelong Yacht Club

2017 Czech Cup Series Regatta - Modry Hrozen

From 23 Sep 2017 to 24 Sep 2017

Czech Republic ----
Czech Republic
Yacht Club Dyje Breclav
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