Trainer 
Alle unsere Trainer der BABE / Snowboardregion Nordwest sind hier aufgelistet - entweder nach Teamzuteilung, oder in einer Gesamtübersicht:
{arijtablesorter defaultSorting="1:ASC" zebra=1 notSortableCols="0,4"} {arisqltable} {arisqltablecolumns} {arisqltablecolumn id="cb_profil" alias="Profil" width="10%"} {arisqltablecolumn id="lastname" alias="Nachname"} {arisqltablecolumn id="firstname" alias="Vorname"} {arisqltablecolumn id="cb_wohnort" alias="Ort"} {arisqltablecolumn id="cb_team02" alias="Teamzuteilung"} {/arisqltablecolumn} {/arisqltablecolumns} {arisqltablequery} SELECT cb_profil AS Profil, concat (lastname, ' ', firstname) AS Name, cb_wohnort AS Wohnort, cb_team02 AS Teamzuteilung FROM jos_comprofiler WHERE cb_funktionen LIKE '%Trainer/in Snowboardcross%' ORDER BY lastname {/arisqltablequery} {/arisqltable} {/arijtablesorter}
{arijtablesorter defaultSorting="1:ASC" zebra=1 notSortableCols="0,4"} {arisqltable} {arisqltablecolumns} {arisqltablecolumn id="cb_profil" alias="Profil" width="10%"} {arisqltablecolumn id="lastname" alias="Nachname"} {arisqltablecolumn id="firstname" alias="Vorname"} {arisqltablecolumn id="cb_wohnort" alias="Ort"} {arisqltablecolumn id="cb_team02" alias="Teamzuteilung"} {/arisqltablecolumn} {/arisqltablecolumns} {arisqltablequery} SELECT cb_profil AS Profil, concat (lastname, ' ', firstname) AS Name, cb_wohnort AS Wohnort, cb_team02 AS Teamzuteilung FROM jos_comprofiler WHERE cb_funktionen LIKE '%Trainer/in Freestyle%' ORDER BY lastname {/arisqltablequery} {/arisqltable} {/arijtablesorter}
{arijtablesorter defaultSorting="1:ASC" zebra=1 notSortableCols="0,4"} {arisqltable} {arisqltablecolumns} {arisqltablecolumn id="cb_profil" alias="Profil" width="10%"} {arisqltablecolumn id="lastname" alias="Nachname"} {arisqltablecolumn id="firstname" alias="Vorname"} {arisqltablecolumn id="cb_wohnort" alias="Ort"} {arisqltablecolumn id="cb_funktionen" alias="Funktion"} {/arisqltablecolumn} {/arisqltablecolumns} {arisqltablequery} SELECT cb_profil AS Profil, concat (lastname, ' ', firstname) AS Name, cb_wohnort AS Wohnort, cb_funktionen AS Funktion FROM jos_comprofiler WHERE cb_funktionen LIKE '%Trainer/in Alpin%' ORDER BY lastname {/arisqltablequery} {/arisqltable} {/arijtablesorter}
{arijtablesorter defaultSorting="1:ASC" zebra=1 notSortableCols="0"} {arisqltable} {arisqltablecolumns} {arisqltablecolumn id="cb_profil" alias="Profil" width="10%"} {arisqltablecolumn id="lastname" alias="Nachname"} {arisqltablecolumn id="firstname" alias="Vorname"} {arisqltablecolumn id="cb_wohnort" alias="Ort"} {arisqltablecolumn id="cb_funktionen" alias="Funktion"} {arisqltablecolumn id="cb_team02" alias="Teamzuteilung"} {/arisqltablecolumn} {/arisqltablecolumns} {arisqltablequery} SELECT cb_profil AS Profil, concat (lastname, ' ', firstname) AS Name, cb_wohnort AS Wohnort, cb_funktionen AS Funktion, cb_team02 AS Teamzuteilung FROM jos_comprofiler WHERE cb_funktionen LIKE '%trainer%' ORDER BY lastname {/arisqltablequery} {/arisqltable} {/arijtablesorter}
{dropbox}1{/dropbox}
