2011 South African 420 National Championships

From 30 Apr 2011 to 02 May 2011

South Africa ----
South Africa
Zeekoe Vlei Yacht Club

Italian Regata Nazionale 3

From 13 May 2011 to 15 May 2011

Italy ----
Italy
Yacht Club Cupa

2011 Mediterranean Sailing Meeting

From 14 May 2011 to 15 May 2011

Spain ----
Spain
Club Nautico El Balis

2011 Alpe Adria Challenge

From 21 May 2011 to 22 May 2011

2011 Portuguese National Championships

From 26 May 2011 to 28 May 2011

Portugal ----
Portugal
Club Nautico de Tavira

2011 Lilac Regatta Festival

From 28 May 2011 to 29 May 2011

Canada ----
Canada
Royal Hamilton Yacht Club

2011 Singapore National 420 Championships

From 30 May 2011 to 04 Jun 2011

Singapore ----
Singapore
Singapore National Sailing Centre
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 < '2011-6-1' AND puntual_date >= '2011-5-1') AND (published = 'YES') ORDER BY puntual_date,R.id