Southern Charter Grand Slam Series 3

From 31 Jan 2015 to 01 Feb 2015

South Africa ----
South Africa
Hermanus Yacht Club

2015 420 US Gulf Coast Championship

From 31 Jan 2015 to 01 Feb 2015

USA ----
USA
Texas Corinthian Yacht Club

2015 Trofeo CN Arenal

From 07 Feb 2015 to 08 Feb 2015

Spain ----
Spain
Club Nautic S Arenal

2015 Argonaut Mini Series

From 07 Feb 2015 to 08 Feb 2015

Australia ----
Australia
Royal Perth Yacht Club (Fremantle Annexe)

2015 VI Velanium Trophy

From 12 Feb 2015 to 15 Feb 2015

Spain ----
Spain
Club Nautico El Balis

2015 KFC Langkawi International Regatta Perdana

From 12 Feb 2015 to 15 Feb 2015

Malaysia ----
Malaysia
Malaysia National Sailing Centre

2015 Regata de Carnaval

From 13 Feb 2015 to 15 Feb 2015

Spain ----
Spain
Real Club Nautico de Gran Canaria

2015 Vilamoura Carnival Regatta

From 14 Feb 2015 to 16 Feb 2015

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

ASAF Youth Sailing Cup 2

From 14 Feb 2015 to 17 Feb 2015

Hong Kong ----
Hong Kong
Hong Kong Sail Training Association Centre

Portuguese 420 Class - Regatta 2

From 14 Feb 2015 to 16 Feb 2015

Portugal ----
Portugal
Clube Internacional da Marina de Vilamoura
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 < '2015-3-1' AND puntual_date >= '2015-2-1') AND (published = 'YES') ORDER BY puntual_date,R.id