2017 Oceanbridge NZL Sailing Regatta

From 03 Feb 2017 to 06 Feb 2017

New Zealand ----
New Zealand
Murrays Bay Sailing Club
Argentina ----
Argentina
Yacht Club Argentino

2016-2017 Southern Charter Classics - Event 3

From 04 Feb 2017 to 05 Feb 2017

South Africa ----
South Africa
Hermanus Yacht Club

2017 Argonaut Series

From 05 Feb 2017 to 06 Feb 2017

Australia ----
Australia
Royal Perth Yacht Club

14th KFC Langkawi International Regatta

From 08 Feb 2017 to 12 Feb 2017

Malaysia ----
Malaysia
National Sailing Centre Langkawi

2017 Guixols Cup

From 11 Feb 2017 to 12 Feb 2017

Spain ----
Spain
Club Nautic Sant Feliu de Guixols
Australia ----
Australia
Adelaide Sailing Club

2017 Hong Kong Race Week

From 16 Feb 2017 to 19 Feb 2017

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

MedSailing Trophy 2017

From 17 Feb 2017 to 19 Feb 2017

Spain ----
Spain
Club Nautico El Balis

2017 Carnival Race

From 17 Feb 2017 to 19 Feb 2017

Italy ----
Italy
Yacht Club Sanremo
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 < '2017-3-1' AND puntual_date >= '2017-2-1') AND (published = 'YES') ORDER BY puntual_date,R.id