United 4 (1)

From 04 Jun 2013 to 04 Jul 2013

Netherlands ----
Netherlands
International Sailing Centre Medemblik

2013 Nieuwpoortweek Regatta

From 29 Jun 2013 to 03 Jul 2013

Belgium ----
Belgium
Koninklijke Yacht Club Nieuwpoort

2013 Slunce a Vitr (Republic Championship)

From 04 Jul 2013 to 08 Jul 2013

Czech Republic ----
Czech Republic
Jachetni Klub Cerna v Posumavi

2013 Warnemunder Woche

From 06 Jul 2013 to 14 Jul 2013

Germany ----
Germany
Warnemunder Segel-Club

United 4 (3)

From 09 Jul 2013 to 09 Aug 2013

Netherlands ----
Netherlands
Workum

2013 Grand Prix Internacional Luis Alberto Cerrato

From 09 Jul 2013 to 09 Aug 2013

Argentina ----
Argentina
Club Náutico Olivos

2013 ISAF Youth Sailing World Championship

From 11 Jul 2013 to 20 Jul 2013

Cyprus ----
Cyprus
Limassol

Southern Charter Grand Slam Series 2

From 12 Jul 2013 to 12 Aug 2013

South Africa ----
South Africa
Theewater Sports Club

2013 Kaagweek

From 12 Jul 2013 to 17 Jul 2013

Netherlands ----
Netherlands
Royal Watersportvereniging De Kaag

2013 French Coupe Nationale

From 13 Jul 2013 to 18 Jul 2013

France ----
France
Centre Nautique Pleneuf Val Andre
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 < '2013-8-1' AND puntual_date >= '2013-7-1') AND (published = 'YES') ORDER BY puntual_date,R.id