Indian 420 Inland Championship 2017

From 31 Aug 2017 to 03 Sep 2017

India ----
India
Little Bay Sailing & Rowing Club

2017 US SAILING ODP Heavy Weather Camp

From 02 Sep 2017 to 04 Sep 2017

USA ----
USA
San Francisco - Venue TBD

2017 CSP Ipsach

From 02 Sep 2017 to 03 Sep 2017

Switzerland ----
Switzerland
Yachtclub Bielersee YCB

2017 CSP Yvonand

From 02 Sep 2017 to 03 Sep 2017

Switzerland ----
Switzerland
Cercle Nautique des Tapa-Sabllias

50th Balkan and Open Sailing Championship

From 05 Sep 2017 to 10 Sep 2017

Turkey ----
Turkey
Tekirdag Sailing Club

NSC Cup Series 2 - 2017

From 06 Sep 2017 to 09 Sep 2017

Singapore ----
Singapore
Singapore National Sailing Centre

2017 Swiss Youth Sailing Championship

From 07 Sep 2017 to 10 Sep 2017

Switzerland ----
Switzerland
Yacht Club Ascona

2017 Italian Two-Person Dinghy Championship

From 07 Sep 2017 to 10 Sep 2017

Italy ----
Italy
Centro Vela Dervio

2017 BYC Cup

From 08 Sep 2017 to 10 Sep 2017

Hungary ----
Hungary
Balatonfüredi Yacht Club

ABC 50th Anniversary Opening Dinghy Regatta

From 09 Sep 2017 to 10 Sep 2017

Hong Kong ----
Hong Kong
Aberdeen Boat 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-10-1' AND puntual_date >= '2017-9-1') AND (published = 'YES') ORDER BY puntual_date,R.id