2016/2017 Australian 420 National Championship

From 01 Jan 2017 to 08 Jan 2017

Australia ----
Australia
Brighton and Seacliff Yacht Club

2017 International Grand Prix Vila de Blanes

From 02 Jan 2017 to 05 Jan 2017

Spain ----
Spain
Club Vela Blanes

2017 Australian Youth Championships

From 10 Jan 2017 to 14 Jan 2017

Australia ----
Australia
Adelaide Sailing Club

2017 420 North American Championships

From 14 Jan 2017 to 16 Jan 2017

USA ----
USA
Coconut Grove Sailing Club

2017 Brazil 420 National Championship

From 16 Jan 2017 to 21 Jan 2017

Brazil ----
Brazil
Ilhabela

2017 Sail The Gulf

From 31 Jan 2017 to 04 Feb 2017

Qatar ----
Qatar
Katara
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 < '2017-2-1' AND puntual_date >= '2017-1-1') AND (published = 'YES') ORDER BY puntual_date,R.id