2011 All Africa Games

From 03 Sep 2011 to 18 Sep 2011

Mozambique ----
Mozambique
Clube Maritimo de Desportes

2011 Irish 420 National Championships

From 03 Sep 2011 to 04 Sep 2011

Ireland ----
Ireland
Spiddal

United 4 2011

From 10 Sep 2011 to 11 Sep 2011

Netherlands ----
Netherlands
Workum

2011 Hong Kong International Open Dinghy Regatta

From 10 Sep 2011 to 13 Sep 2011

Hong Kong ----
Hong Kong
Hong Kong Sail Training Association Centre

2011 GBR 420 Inland Championships

From 17 Sep 2011 to 19 Sep 2011

Great Britain ----
Great Britain
Rutland Sailing Club

2011 Open Belgian Championships

From 17 Sep 2011 to 18 Sep 2011

Belgium ----
Belgium
Nieuwpoort
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-10-1' AND puntual_date >= '2011-9-1') AND (published = 'YES') ORDER BY puntual_date,R.id