Indonesia ----
Indonesia
Indonesian Sailing Federation

2016 Argentina 420 Youth Championship

From 02 Dec 2016 to 04 Dec 2016

Argentina ----
Argentina
Club de Veleros San Isidro

2016 Semana Olímpica Canaria de Vela

From 02 Dec 2016 to 06 Dec 2016

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

2016 George Mac Regatta

From 02 Dec 2017 to 03 Dec 2017

Australia ----
Australia
Royal Brighton Yacht Club

Regata de Natal LUSITANIA MAR 2016

From 03 Dec 2016 to 04 Dec 2016

Portugal ----
Portugal
Clube Naval de Cascais

2016 Sir Peter Blake Regatta

From 03 Dec 2016 to 04 Dec 2016

New Zealand ----
New Zealand
Torbay Sailing Club

2016 International Classes Regatta

From 03 Dec 2016 to 04 Dec 2016

Australia ----
Australia
Royal Freshwater Bay Yacht Club

2016-2017 Southern Charter Classics - Event 2

From 03 Dec 2016 to 04 Dec 2016

South Africa ----
South Africa
Theewater Sports Club

2016 African 420 Championship

From 04 Dec 2016 to 11 Dec 2016

Mozambique ----
Mozambique
Clube Maritimo de Desportes

2016 Imperia Winter Regatta

From 08 Dec 2016 to 11 Dec 2016

Italy ----
Italy
Yacht Club Imperia
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-1-1' AND puntual_date >= '2016-12-1') AND (published = 'YES') ORDER BY puntual_date,R.id