 |
Zeilnummers |
|
|
Wens je een aanpassing of ken je nog andere nummers,
stuur ze gerust op in een mailtje.
Sorteren op zeilnummer of club door op de desbetreffende kolom titel te klikken
<$IF order = NULL><$SET order sail><$/IF>
<$IF order = club>
<$SQL q> select if(club="", "Andere",club), nbr, name, boat from sails
order by if(club="SYCOD","AA",if(club="", "ZZZZZ",club)),
if (substring(nbr,1,3) = "BEL",substring(nbr,4,99),
if (substring(nbr,1,3) = "AUS",3000000+ substring(nbr,4,99),
if (substring(nbr,1,3) = "FRA",1000000+ substring(nbr,4,99),
if (substring(nbr,1,3) = "ITA",4000000+ substring(nbr,4,99),
if (substring(nbr,1,3) = "NED",2000000+ substring(nbr,4,99),
if(nbr+1-1=0,9000000+substring(nbr,4,99),
nbr))))))+1 <$/SQL>
| Zeil |
Bemanning |
Boot |
|---|
<$ROW q>
<$IF q.1 != $current>
<$SET current $q.1>
| <$VAL q.1> |
|---|
<$/IF>
| <$VAL q.2> | <$VAL q.3> | <$VAL q.4> |
<$/ROW>
<$ELSE><$IF order = sail>
<$SQL q> select club, nbr, name, boat from sails order by
if (substring(nbr,1,3) = "BEL",substring(nbr,4,99),
if (substring(nbr,1,3) = "AUS",3000000+ substring(nbr,4,99),
if (substring(nbr,1,3) = "FRA",1000000+ substring(nbr,4,99),
if (substring(nbr,1,3) = "ITA",4000000+ substring(nbr,4,99),
if (substring(nbr,1,3) = "NED",2000000+ substring(nbr,4,99),
if(nbr+1-1=0,9000000+substring(nbr,4,99),
nbr))))))+1 <$/SQL>
| Zeil |
Bemanning |
Club |
Boot |
|---|
<$ROW q>
| <$VAL q.2> | <$VAL q.3> | <$VAL q.1> | <$VAL q.4> |
<$/ROW>
<$ELSE><$IF order = name>
<$SQL q> select club, nbr, name, boat from sails order by if(name="","ZZZZZZ",name) <$/SQL>
| Zeil |
Bemanning |
Club |
Boot |
|---|
<$ROW q>
| <$VAL q.2> | <$VAL q.3> | <$VAL q.1> | <$VAL q.4> |
<$/ROW>
<$ELSE><$- order = boat -$>
<$SQL q> select club, nbr, name, if (boat="", "Onbekend",boat) from sails
order by if(boat="","ZZZZZ", boat),
if (substring(nbr,1,3) = "BEL",substring(nbr,4,99),
if (substring(nbr,1,3) = "AUS",3000000+ substring(nbr,4,99),
if (substring(nbr,1,3) = "FRA",1000000+ substring(nbr,4,99),
if (substring(nbr,1,3) = "ITA",4000000+ substring(nbr,4,99),
if (substring(nbr,1,3) = "NED",2000000+ substring(nbr,4,99),
if(nbr+1-1=0,9000000+substring(nbr,4,99),
nbr))))))+1 <$/SQL>
| Zeil |
Bemanning |
Club |
|---|
<$ROW q>
<$IF q.4 != $current>
<$SET current $q.4>
| <$VAL q.4> |
|---|
<$/IF>
| <$VAL q.2> | <$VAL q.3> | <$VAL q.1> |
<$/ROW>
<$/IF><$/IF><$/IF>