<?xml version="1.0" encoding="utf-8"?>
<metadata>
        <layout title="COM_CLM_TURNIER_PAARUNGSLISTE_VIEW_DEFAULT_TITLE">
                <message>
                        <![CDATA[COM_CLM_TURNIER_PAARUNGSLISTE_VIEW_DEFAULT_DESC]]>
                </message>
        </layout>
        <fields name="request">
			<fieldset name="request" >
				<field name="turnier" type="sql" default="1" label="Turnier auswählen" query="
						SELECT a.id AS value, concat(  s.name, ' -- ', a.name ) AS tname 
						FROM #__clm_turniere AS a LEFT JOIN #__clm_saison as s ON s.id = a.sid " value_field="tname" >
                </field>
            </fieldset>
        </fields>
</metadata>