Kontakt: Adrian Kolb
Teamrider
{arijtablesorter defaultSorting="1:ASC" zebra=1 notSortableCols="0,3"} {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_fispunkteliste" alias="FIS"} {/arisqltablecolumn} {/arisqltablecolumns} {arisqltablequery} SELECT cb_profil AS Profil, concat (lastname, ' ', firstname) AS Name, cb_wohnort AS Wohnort, cb_fispunkteliste AS Resultate FROM jos_comprofiler WHERE cb_funktionen LIKE 'Teamrider/in Alpin%' ORDER BY lastname {/arisqltablequery} {/arisqltable} {/arijtablesorter}
