2017 Regata Nazionale Classe 420 - Event 3

From 02 Jun 2017 to 05 Jun 2017

Italy ----
Italy
Circolo Nautico Caposele

2017 Spring Cup Neusiedlersee

From 03 Jun 2017 to 05 Jun 2017

Austria ----
Austria
Segelzentrum - Der Neusiedler See

Trofeu CNEstanyol 2017

From 03 Jun 2017 to 04 Jun 2017

Spain ----
Spain
Club Nàutic S'Estanyol

2017 Interligue 2 Nord - Le Havre

From 03 Jun 2017 to 05 Jun 2017

France ----
France
Centre Nautique Paul Vatine

2017 Interligue 2 Atlantique - La Rochelle

From 03 Jun 2017 to 05 Jun 2017

France ----
France
La Societe des Regates de La Rochelle

2017 Semaine de La Rochelle Dériveurs

From 03 Jun 2017 to 05 Jun 2017

France ----
France
La Societe des Regates de La Rochelle

2017 Young Europeans Sailing

From 03 Jun 2017 to 05 Jun 2017

Germany ----
Germany
Kieler Yacht Club

Singapore National Sailing Championships 2017

From 07 Jun 2017 to 11 Jun 2017

Singapore ----
Singapore
Singapore National Sailing Centre

2017 Wickford Regatta

From 10 Jun 2017 to 11 Jun 2017

USA ----
USA
Wickford Yacht Club

2017 420 East Coast Championship

From 10 Jun 2017 to 11 Jun 2017

Australia ----
Australia
Georges River 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-7-1' AND puntual_date >= '2017-6-1') AND (published = 'YES') ORDER BY puntual_date,R.id