2017 Nieuwpoort Week

From 01 Jul 2017 to 05 Jul 2017

Belgium ----
Belgium
Koninklijke Yacht Club Nieuwpoort

2017 Achensee

From 01 Jul 2017 to 02 Jul 2017

Austria ----
Austria
Segelclub TWV Achensee

2017 French National Championship

From 07 Jul 2017 to 12 Jul 2017

France ----
France
Centre Nautique Crozon Morgat

2017 420 Leinster Championship

From 07 Jul 2017 to 09 Jul 2017

Ireland ----
Ireland
Royal St George Yacht Club

Trofeo Renault Llucmajor 2017

From 08 Jul 2017 to 09 Jul 2017

Spain ----
Spain
Club Nautic S Arenal

420 Class @ 2017 Optimist World Championship

From 11 Jul 2017 to 21 Jul 2017

Thailand ----
Thailand
Royal Varuna Yacht Club

2017 Texas Youth Race Week

From 11 Jul 2017 to 16 Jul 2017

USA ----
USA
Lakewood Yacht Club

2017 THE Olympic Regatta

From 15 Jul 2017 to 17 Jul 2017

Hungary ----
Hungary
Tihany Yacht Club

Volvo Gdynia Sailing Days 2017

From 17 Jul 2017 to 19 Jul 2017

Poland ----
Poland
Marina Gdynia

2017 Warm-Up Regatta for 420 Europeans

From 17 Jul 2017 to 19 Jul 2017

Greece ----
Greece
Nautical Club of Tzitzifies – Kallithea (NOTK)
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-8-1' AND puntual_date >= '2017-7-1') AND (published = 'YES') ORDER BY puntual_date,R.id