2013 Grand Prix Internacional Luis Alberto Cerrato

From 31 Aug 2013 to 01 Sep 2013

Argentina ----
Argentina
Club Náutico Olivos

2013 Austrian Junior Championships

From 27 Aug 2013 to 01 Sep 2013

Austria ----
Austria
Yacht Club Podersdorf

2013 Indian 420 Inland National Championship

From 04 Sep 2013 to 08 Sep 2013

India ----
India
Yacht Club of Hyerabad

2013 16th Asian Sailing Championship

From 05 Sep 2013 to 14 Sep 2013

Korea ----
Korea
Wangsan Beach

2013 Torneo Contramaestre Willan

From 11 Sep 2013 to 11 Oct 2013

Argentina ----
Argentina
Yacht Club Centrol Naval

2013 Open Belgian Championships

From 14 Sep 2013 to 15 Sep 2013

Belgium ----
Belgium
Nieuwpoort

2013 420 Inland National Championships

From 14 Sep 2013 to 15 Sep 2013

Great Britain ----
Great Britain
Rutland Sailing Club

2013 Hong Kong 420 National Championships

From 14 Sep 2013 to 15 Sep 2013

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

2013 Hong Kong International Open Dinghy Regatta

From 20 Sep 2013 to 22 Sep 2013

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

2013 Hong Kong 420 National Championships

From 20 Sep 2013 to 22 Sep 2013

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