2016 420 Team Racing World Championship

From 31 Aug 2016 to 03 Sep 2016

Italy ----
Italy
Campione Univela

49th Balkan and Open Sailing Championship

From 02 Sep 2016 to 08 Sep 2016

Greece ----
Greece
Port of Palaia

2016 Aon Focus Clinic

From 03 Sep 2016 to 04 Sep 2016

New Zealand ----
New Zealand
Gulf Harbour Yacht Club

2016 Olimpic Grand Prix Event 3

From 03 Sep 2016 to 04 Sep 2016

Great Britain ----
Great Britain
Royal Lymington Yacht Club

2016 Blueberry Regatta

From 03 Sep 2016 to 04 Sep 2016

Czech Republic ----
Czech Republic
Plachetnice a Yacht Club Lipno nad Vltavou

2016 Lower Saxony State and Youth Championship

From 03 Sep 2016 to 04 Sep 2016

Germany ----
Germany
Segler Verband Niedersachsen

2016 CSP Ipsach

From 03 Sep 2016 to 04 Sep 2016

Switzerland ----
Switzerland
Yachtclub Bielersee YCB

2016 Russian Youth Championship

From 05 Sep 2016 to 12 Sep 2016

Russia ----
Russia
St Petersburg Yacht Club
Myanmar ----
Myanmar
Yangon Sailing Club

2016 Italian National Championships

From 07 Sep 2016 to 11 Sep 2016

Italy ----
Italy
Circolo Vela Termoli
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 < '2016-10-1' AND puntual_date >= '2016-9-1') AND (published = 'YES') ORDER BY puntual_date,R.id