Argentina ----
Argentina
Yacht Club Argentino

2018 Oceanbridge NZL Sailing Regatta

From 03 Feb 2018 to 05 Feb 2018

New Zealand ----
New Zealand
Murrays Bay Sailing Club

2017-2018 Southern Charter Classics - Event 3

From 03 Feb 2018 to 04 Feb 2018

South Africa ----
South Africa
Hermanus Yacht Club

2018 New Zealand North Island Championship

From 10 Feb 2018 to 11 Feb 2018

New Zealand ----
New Zealand
Takapuna Boating Club
Portugal ----
Portugal
Clube Internacional da Marina de Vilamoura

2018 Irish Munster Regional Championships

From 16 Feb 2018 to 17 Feb 2018

Ireland ----
Ireland
Fastnet Marine & Outdoor Education Centre

2018 420 Class Zadar Open

From 16 Feb 2018 to 18 Feb 2018

Croatia ----
Croatia
Sailing Club Uskok Zadar

2018 420 US Mid-Winter Championships

From 17 Feb 2018 to 19 Feb 2018

USA ----
USA
Miami Yacht Club

2018 George Mac Regatta

From 17 Feb 2018 to 18 Feb 2018

Australia ----
Australia
Royal Brighton Yacht Club

2018 Carnival Race

From 22 Feb 2018 to 25 Feb 2018

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