KFC Malaysia YA-MILO/NSC National Open Championship

From 27 Nov 2013 to 01 Dec 2013

Malaysia ----
Malaysia
Malaysia National Sailing Centre

2013 Sail Melbourne

From 01 Dec 2013 to 08 Dec 2013

Australia ----
Australia
Sandringham Yacht Club

2013 Cascais Christmas Race

From 30 Nov 2013 to 01 Dec 2013

Portugal ----
Portugal
Clube Naval de Cascais

2013 Imperia Winter Regatta

From 04 Dec 2013 to 08 Dec 2013

Italy ----
Italy
Yacht Club Imperia

2013 Trofeo Ciutat de Palma

From 05 Dec 2013 to 08 Dec 2013

Spain ----
Spain
Real Club Nautico de Palma

Southern Charter Grand Slam Series 1

From 10 Dec 2013 to 13 Dec 2013

South Africa ----
South Africa
Zeekoe Vlei Yacht Club

27th South East Asian Games

From 11 Dec 2013 to 20 Dec 2013

Myanmar ----
Myanmar
Ngwe Saung Yacht Club

2013 South African Sailing Youth Nationals

From 14 Dec 2013 to 20 Dec 2013

South Africa ----
South Africa
Henley Midmar Yacht Club

2013 GAES Christmas Race

From 17 Dec 2013 to 22 Dec 2013

Spain ----
Spain
Club de Vela Palamos

2013 Campeonato Argentino

From 19 Dec 2013 to 22 Dec 2013

Argentina ----
Argentina
Club Nautico San Isidro
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 < '2014-1-1' AND puntual_date >= '2013-12-1') AND (published = 'YES') ORDER BY puntual_date,R.id