Portugal - 1st National Qualifying Regatta

From 01 Dec 2017 to 03 Dec 2017

Portugal ----
Portugal
Clube Naval de Cascais

2017 Sir Peter Blake Regatta

From 02 Dec 2017 to 03 Dec 2017

New Zealand ----
New Zealand
Torbay Sailing Club
Great Britain ----
Great Britain
Grafham Water Sailing Club

2017-2018 Southern Charter Classics - Event 2

From 02 Dec 2017 to 03 Dec 2017

South Africa ----
South Africa
Theewater Sports Club
Malaysia ----
Malaysia
Malaysia National Sailing Centre

2017 Semana Olímpica Canaria de Vela

From 06 Dec 2017 to 10 Dec 2017

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

2017 Imperia Winter Regatta

From 07 Dec 2017 to 10 Dec 2017

Italy ----
Italy
Yacht Club Imperia

2017 Trofeo Ciutat de Palma

From 07 Dec 2017 to 10 Dec 2017

Spain ----
Spain
Real Club Nautico de Palma

2017 Youth Sailing World Championship

From 09 Dec 2017 to 16 Dec 2017

China, PR ----
China, PR
Sanya - Hainan Island

2017 Haifa International Winter Regatta

From 14 Dec 2017 to 16 Dec 2017

Israel ----
Israel
Haifa Sailing Club
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-1-1' AND puntual_date >= '2017-12-1') AND (published = 'YES') ORDER BY puntual_date,R.id