2011 Trofeo Ciutat de Palma

From 03 Dec 2011 to 06 Dec 2011

Spain ----
Spain
Real Club Nautico de Palma

2011 Imperia Winter Regatta

From 08 Dec 2011 to 10 Dec 2011

Italy ----
Italy
Marina degli Aregai

2011 Copa de España de 420

From 08 Dec 2011 to 11 Dec 2011

Spain ----
Spain
Marina Juan Montiel

2011 420 South American Championships

From 26 Dec 2011 to 30 Dec 2011

Chile ----
Chile
Club de Yates de Algarrobo

2012 Australian 420 National Championships

From 27 Dec 2011 to 02 Jan 2012

Australia ----
Australia
Moreton Bay Boat Club

2011 Open Orange Bowl Regatta

From 27 Dec 2011 to 30 Dec 2011

USA ----
USA
Coral Reef Yacht 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 < '2012-1-1' AND puntual_date >= '2011-12-1') AND (published = 'YES') ORDER BY puntual_date,R.id