2014 ISAF Youth Sailing World Championship

From 12 Jul 2014 to 19 Jul 2014

Portugal ----
Portugal
Club Nautico de Tavira

2014 French Coupe Nationale

From 12 Jul 2014 to 17 Jul 2014

France ----
France
OCEAN

Intervela 420

From 14 Jul 2014 to 16 Jul 2014

Italy ----
Italy
Fraglia Vela Riva

2014 420 World and Ladies World Championships

From 25 Jul 2014 to 03 Aug 2014

Germany ----
Germany
Lübecker Yacht Club

2014 420 General Assembly Meeting

From 26 Jul 2014 to 26 Jul 2014

Germany ----
Germany
Lübecker 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 < '2014-8-1' AND puntual_date >= '2014-7-1') AND (published = 'YES') ORDER BY puntual_date,R.id