2019 British 420 Spring Championships

From 06 Apr 2019 to 07 Apr 2019

Great Britain ----
Great Britain
Weymouth and Portland National Sailing Academy

2019 RYA Youth National Championships

From 12 Apr 2019 to 19 Apr 2019

Great Britain ----
Great Britain
Weymouth and Portland National Sailing Academy

2019 420 South American Championship

From 15 Apr 2019 to 21 Apr 2019

Brazil ----
Brazil
Iate Clube do Rio de Janeiro
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 < '2019-5-1' AND puntual_date >= '2019-4-1') AND (published = 'YES') ORDER BY puntual_date,R.id