2006 International Optispring Cup

From 08 Apr 2006 to 09 Apr 2006

Netherlands ----
Netherlands
Marina Stellendam

2006 Princess Sofia

From 08 Apr 2006 to 16 Apr 2006

Spain ----
Spain
Escola de Vela de Calanova

2006 RYA Youth Championships and Trials

From 08 Apr 2006 to 14 Apr 2006

Great Britain ----
Great Britain
Weymouth and Portland National Sailing Academy

2006 Brazilian National Championships

From 08 Apr 2006 to 10 Apr 2006

Brazil ----
Brazil
Clube dos Jangadeiros

2006 International 420 South American Championship

From 11 Apr 2006 to 15 Apr 2006

Brazil ----
Brazil
Clube dos Jangadeiros

2006 Portuguese Youth National Championship

From 28 Apr 2006 to 01 May 2006

Portugal ----
Portugal
Clube Naval de Cascais
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 < '2006-5-1' AND puntual_date >= '2006-4-1') AND (published = 'YES') ORDER BY puntual_date,R.id