2007 Campeonato de España

From 01 Apr 2007 to 06 Apr 2007

Spain ----
Spain
Club Vela Blanes
Australia ----
Australia
Sandy Bay Yacht Club

2007 Capman Cup

From 30 Mar 2007 to 02 Apr 2007

Switzerland ----
Switzerland
Regattaclub Oberhofen

2007 Campeonato Sudamericano / Sul-Americano

From 02 Apr 2007 to 07 Apr 2007

Argentina ----
Argentina
Yacht Club Argentino

2007 South American Championship

From 02 Apr 2007 to 06 Apr 2007

Argentina ----
Argentina
Yacht Club Argentino

2007 Izola Spring Cup

From 04 Apr 2007 to 09 Apr 2007

Slovenia ----
Slovenia
Yacht Club Burja Izola

8th Meeting of the Third Millenium

From 05 Apr 2007 to 07 Apr 2007

Italy ----
Italy
Fraglia Vela Malcesine

2007 New Zealand National Championships

From 06 Apr 2007 to 09 Apr 2007

New Zealand ----
New Zealand
Evans Bay Yacht Club and Motor Club

2007 Italian Regata Nazionale 2

From 07 Apr 2007 to 09 Apr 2007

Italy ----
Italy
Yacht Club Cagliari

2007 420 RYA Youth Championships & Trials

From 10 Apr 2007 to 14 Apr 2007

Great Britain ----
Great Britain
Hayling Island Sailing 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-5-1' AND puntual_date >= '2007-4-1') AND (published = 'YES') ORDER BY puntual_date,R.id