2012 Palamos Christmas Race

From 18 Dec 2012 to 23 Dec 2012

Spain ----
Spain
Club de Vela Palamos

KFC - MYA - Milo

From 20 Dec 2012 to 23 Dec 2012

International 420 Class - Christmas Clinic

From 26 Dec 2012 to 30 Dec 2012

Brazil ----
Brazil
Clube dos Jangadeiros

2012 North American 420 Championships

From 27 Dec 2012 to 30 Dec 2012

USA ----
USA
Coconut Grove Sailing Club

2012-2013 Australian 420 National Championships

From 28 Dec 2012 to 04 Jan 2013

Australia ----
Australia
Derwent Sailing Squadron

2013 420 South American Championships

From 31 Dec 2012 to 06 Jan 2013

Brazil ----
Brazil
Clube dos Jangadeiros
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