2015 JSAF Enoshima Olympic Week

From 04 Jun 2015 to 07 Jun 2015

Japan ----
Japan
Enoshima Yacht Club

Southeast Asian Games 2015

From 05 Jun 2015 to 16 Jun 2015

Singapore ----
Singapore
Singapore National Sailing Centre

2015 420 East Coast Championship

From 06 Jun 2015 to 07 Jun 2015

Australia ----
Australia
Middle Harbour Yacht Club

2015 Buzios Sailing Week

From 06 Jun 2015 to 07 Jun 2015

Brazil ----
Brazil
Iate Clube Armação de Buzios

2015 Choco Cup

From 19 Jun 2015 to 21 Jun 2015

Hungary ----
Hungary
Spartacus Sailing Club

2015 Kieler Woche

From 25 Jun 2015 to 28 Jun 2015

Germany ----
Germany
Kieler Yacht Club

Singapore National Sailing Championship 2015

From 25 Jun 2015 to 28 Jun 2015

Singapore ----
Singapore
Singapore National Sailing Centre
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 < '2015-7-1' AND puntual_date >= '2015-6-1') AND (published = 'YES') ORDER BY puntual_date,R.id