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

Southern Charter Grand Slam Series 2

From 12 Jul 2013 to 12 Aug 2013

South Africa ----
South Africa
Theewater Sports Club

2013 Helicon Youth Cup

From 03 Aug 2013 to 04 Aug 2013

EUROSAF Youth Sailing European Championships 2013

From 03 Aug 2013 to 09 Aug 2013

Portugal ----
Portugal
Club Nautico de Tavira

2013 Irish National Championships

From 09 Aug 2013 to 11 Aug 2013

Ireland ----
Ireland
Royal Cork Yacht Club

2013 British 420 National Championships

From 10 Aug 2013 to 13 Aug 2013

Great Britain ----
Great Britain
Pwllheli Sailing Club

2013 US Youth Championships

From 12 Aug 2013 to 16 Aug 2013

USA ----
USA
Corpus Christi Yacht Club

2013 420 Junior European Championships

From 14 Aug 2013 to 22 Aug 2013

Great Britain ----
Great Britain
Pwllheli Sailing Club

2013 Campeonato Metropolitano

From 18 Aug 2013 to 20 Aug 2013

Argentina ----
Argentina
Club Universitario de Buenos Aires
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-9-1' AND puntual_date >= '2013-8-1') AND (published = 'YES') ORDER BY puntual_date,R.id