2013 Oceanbridge Sail Auckland

From 01 Feb 2013 to 05 Feb 2013

New Zealand ----
New Zealand
Royal Akarana Yacht Club

XXV Carnaval Race

From 03 Feb 2013 to 03 Mar 2013

2013 Lauderdale Olympic Classes Ocean Regatta

From 07 Feb 2013 to 10 Feb 2013

USA ----
USA
Lauderdale Yacht Club

New Zealand North Island 420 Championships

From 08 Feb 2013 to 10 Feb 2013

New Zealand ----
New Zealand
Napier Sailing Club

2013 Vilamoura Carnival Regatta

From 09 Feb 2013 to 11 Feb 2013

Portugal ----
Portugal
Clube Internacional da Marina de Vilamoura

2013 Junior Sail Auckland

From 09 Feb 2013 to 10 Feb 2013

New Zealand ----
New Zealand
Kohimarama Yacht Club

2013 46ᄎ Semana Internacional del Yachting

From 11 Feb 2013 to 16 Feb 2013

Argentina ----
Argentina
Yacht Club Argentino

2013 Torneo Contramaestre Willan

From 11 Feb 2013 to 11 Mar 2013

Argentina ----
Argentina
Yacht Club Centrol Naval

Southern Charter Grand Slam Series 3

From 16 Feb 2013 to 17 Feb 2013

South Africa ----
South Africa
Hermanus Yacht Club

Vuelta a la Laguna

From 18 Feb 2013 to 19 Feb 2013

Argentina ----
Argentina
Club de Regatas Chascomus
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-3-1' AND puntual_date >= '2013-2-1') AND (published = 'YES') ORDER BY puntual_date,R.id