Class info Puerto Rico National 420 Class Association

Back
Puerto Rico ----
Puerto Rico National 420 Class Association
PUR
No events found

2015 Caribbean Dinghy Championships

From 16 Oct 2015 to 18 Oct 2015

Puerto Rico
Club Náutico de San Juan
Raul Rios
Position: President
+787 403 2625
Photo
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 left JOIN gerelations GER ON R.id_genericelement = GER.id_ge_1 left JOIN geclub C ON C.id_genericelement = GER.id_ge_2 WHERE (C.id IN (429)) AND (published = 'YES') AND (end_date >= '2018-05-20T21:58:56+02:00' OR puntual_date >= '2018-05-20T21:58:56+02:00') ORDER BY puntual_date ASC,R.id
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 left JOIN gerelations GER ON R.id_genericelement = GER.id_ge_1 left JOIN geclub C ON C.id_genericelement = GER.id_ge_2 WHERE (C.id IN (429)) AND (published = 'YES') AND (end_date <= '2018-05-20T21:58:56+02:00' ) ORDER BY puntual_date DESC,R.id