2006 15th Asian Games

From 01 Dec 2006 to 15 Dec 2006

Qatar ----
Qatar
Doha Sailing Club

2006 Imperia Winter Regatta

From 07 Dec 2006 to 10 Dec 2006

Italy ----
Italy
Porto Maurizio YC

2006 Sydney International Regatta

From 16 Dec 2006 to 19 Dec 2006

Australia ----
Australia
Woollahra Sailing Club

2007 Open & Ladies' World Championships (December)

From 31 Dec 2006 to 09 Jan 2007

New Zealand ----
New Zealand
Takapuna Boating 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 < '2007-1-1' AND puntual_date >= '2006-12-1') AND (published = 'YES') ORDER BY puntual_date,R.id