2016 CSP Oberhofen / Lebkuchen

From 05 Nov 2016 to 06 Nov 2016

Switzerland ----
Switzerland
Regattaclub Oberhofen

2016 Hong Kong 420 National Championships

From 12 Nov 2016 to 13 Nov 2016

Hong Kong ----
Hong Kong
Hong Kong Sail Training Association Centre
Great Britain ----
Great Britain
Grafham Water Sailing Club

US SAILING Olympic Development Program Racing Camp

From 25 Nov 2016 to 27 Nov 2016

USA ----
USA
US Sailing Center

2016 Go For Gold Regatta

From 26 Nov 2016 to 27 Nov 2016

Australia ----
Australia
Black Rock Yacht Club
Australia ----
Australia
Brighton and Seacliff Yacht Club
Indonesia ----
Indonesia
Indonesian Sailing Federation
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 < '2016-12-1' AND puntual_date >= '2016-11-1') AND (published = 'YES') ORDER BY puntual_date,R.id