2016 Spring Sails - National Team Trials

From 30 Apr 2016 to 07 May 2016

Russia ----
Russia
Yacht Club Taganrog
Bulgaria ----
Bulgaria
Yacht Club Port Bourgas

2016 CSP Thun

From 07 May 2016 to 08 May 2016

Switzerland ----
Switzerland
Thunersee Yachtclub
Germany ----
Germany
Kieler Yacht Club
Austria ----
Austria
Union Yacht Club Neusiedlersee

2016 Semaine de La Rochelle Dériveurs

From 14 May 2016 to 16 May 2016

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

2016 Interligue 420 Les Sablettes

From 14 May 2016 to 16 May 2016

France ----
France
Yacht Club des Sablettes

2016 Murrays Bay Sailing Club 420 Club Championship

From 14 May 2016 to 15 May 2016

New Zealand ----
New Zealand
Murrays Bay Sailing Club

2016 Chilean Grand Prix 2

From 14 May 2016 to 15 May 2016

Chile ----
Chile
Club de Yates de Algarrobo

2016 Olimpic Grand Prix Event 2

From 21 May 2016 to 22 May 2016

Great Britain ----
Great Britain
Royal Lymington Yacht 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 < '2016-6-1' AND puntual_date >= '2016-5-1') AND (published = 'YES') ORDER BY puntual_date,R.id