Southern Charter Grand Slam Series 2

From 01 Dec 2012 to 02 Dec 2012

South Africa ----
South Africa
Theewater Sports Club

2012 Sir Peter Blake Regatta

From 01 Dec 2012 to 02 Dec 2012

New Zealand ----
New Zealand
Torbay Sailing Club

2012 Sail Melbourne

From 02 Dec 2012 to 08 Dec 2012

Australia ----
Australia
Sandringham Yacht Club

2012 Imperia Winter Regatta

From 06 Dec 2012 to 09 Dec 2012

Italy ----
Italy
Yacht Club Imperia

2012 Trofeo Ciutat de Palma

From 06 Dec 2012 to 09 Dec 2012

Spain ----
Spain
Real Club Nautico de Palma

2012 Singapore National 420 Championships

From 06 Dec 2012 to 09 Dec 2012

Singapore ----
Singapore
Singapore National Sailing Centre

2012 North Shore Championships

From 08 Dec 2012 to 09 Dec 2012

New Zealand ----
New Zealand
Takapuna Boating Club

2012 South African National Championships

From 08 Dec 2012 to 14 Dec 2012

South Africa ----
South Africa
Pine Lake Marina

2012 Sail Sydney

From 13 Dec 2012 to 16 Dec 2012

Australia ----
Australia
Woollahra Sailing Club

Haifa Winter Regatta

From 13 Dec 2012 to 15 Dec 2012

Israel ----
Israel
Reuven Sadnai Haifa Sailing Center
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 < '2013-1-1' AND puntual_date >= '2012-12-1') AND (published = 'YES') ORDER BY puntual_date,R.id