Southern Charter Grand Slam Final

From 03 Apr 2015 to 06 Apr 2015

South Africa ----
South Africa
False Bay Yacht Club

2015 Italian National Regatta Crotone

From 03 Apr 2015 to 06 Apr 2015

Italy ----
Italy
Club Velico Crotone

2015 RYA Youth National Championships

From 04 Apr 2015 to 10 Apr 2015

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

2015 420 Coaches' Clinic

From 09 Apr 2015 to 12 Apr 2015

Japan ----
Japan
Saga Prefecture Yacht Harbour

2015 Victorian Junior and Youth Championships

From 11 Apr 2015 to 12 Apr 2015

Australia ----
Australia
Mornington Yacht Club

2015 Championnats Swiss Points - Capman Cup

From 11 Apr 2015 to 12 Apr 2015

Switzerland ----
Switzerland
Regattaclub Oberhofen

2015 Majthenyi Zsombor Memorial Competition

From 17 Apr 2015 to 19 Apr 2015

Hungary ----
Hungary
Lake Velence

12th SAFYC Changi Regatta 2015

From 18 Apr 2015 to 19 Apr 2015

Singapore ----
Singapore
SAF Yacht Club

2015 Championnats Swiss Points - Lugano

From 18 Apr 2015 to 19 Apr 2015

Switzerland ----
Switzerland
Circolo Velico Lago di Lugano

2015 Hua Hin Regatta

From 19 Apr 2015 to 25 Apr 2015

Thailand ----
Thailand
Regent Cha am Beach Resort
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 < '2015-5-1' AND puntual_date >= '2015-4-1') AND (published = 'YES') ORDER BY puntual_date,R.id