2015 Kékpántlika

From 01 Jul 2015 to 01 Jul 2015

Hungary ----
Hungary
Lake Balaton

2015 Nieuwpoortweek Regatta

From 04 Jul 2015 to 08 Jul 2015

Belgium ----
Belgium
Koninklijke Yacht Club Nieuwpoort

2015 Queensland Youth Week

From 04 Jul 2015 to 07 Jul 2015

Australia ----
Australia
Royal Queensland Yacht Squadron

2015 Warnemunder Woche

From 04 Jul 2015 to 12 Jul 2015

Germany ----
Germany
Warnemunder Segel-Club

2015 Munster 420 Championships

From 04 Jul 2015 to 05 Jul 2015

Ireland ----
Ireland
Waterford Harbour Sailing Club

2015 US Youth Championships

From 06 Jul 2015 to 10 Jul 2015

USA ----
USA
Bristol Yacht Club

2015 Sail Brisbane

From 09 Jul 2015 to 12 Jul 2015

Australia ----
Australia
Royal Queensland Yacht Squadron

2015 Texas Youth Race Week

From 11 Jul 2015 to 17 Jul 2015

USA ----
USA
Texas Corinthian Yacht Club

2015 420 World and Ladies World Championships

From 17 Jul 2015 to 25 Jul 2015

Japan ----
Japan
Saga Prefecture Yacht Harbour

2015 Diákolimpia

From 17 Jul 2015 to 19 Jul 2015

Hungary ----
Hungary
Lake Balaton
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-8-1' AND puntual_date >= '2015-7-1') AND (published = 'YES') ORDER BY puntual_date,R.id