2014 Imperia Winter Regatta

From 03 Dec 2014 to 07 Dec 2014

Italy ----
Italy
Yacht Club Imperia

2014 Trofeo Ciutat de Palma

From 04 Dec 2014 to 07 Dec 2014

Spain ----
Spain
Real Club Nautico de Palma

2014 Semana Olímpica Canaria de Vela

From 04 Dec 2014 to 08 Dec 2014

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

2014 Sail Sydney

From 05 Dec 2014 to 07 Dec 2014

Australia ----
Australia
Woollahra Sailing Club

Southern Charter Grand Slam Series 2

From 06 Dec 2014 to 07 Dec 2014

South Africa ----
South Africa
Theewater Sports Club

2014 Sir Peter Blake Regatta

From 06 Dec 2014 to 07 Dec 2014

New Zealand ----
New Zealand
Torbay Sailing Club

2014 ISAF Sailing World Cup Melbourne

From 07 Dec 2014 to 14 Dec 2014

Australia ----
Australia
Sandringham Yacht Club

2014 SSF Festive Season Regatta

From 10 Dec 2014 to 14 Dec 2014

Singapore ----
Singapore
Singapore National Sailing Centre

2014 South African Youth National Championships

From 13 Dec 2014 to 19 Dec 2014

South Africa ----
South Africa
Aeolians Yacht Club

2014 GAES Christmas Race

From 17 Dec 2014 to 22 Dec 2014

Spain ----
Spain
Club de Vela Palamos
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-1-1' AND puntual_date >= '2014-12-1') AND (published = 'YES') ORDER BY puntual_date,R.id