Vorlage:Character/Siblings: Unterschied zwischen den Versionen

Aus Notebook
Zur Navigation springen Zur Suche springen
 
(24 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt)
Zeile 1: Zeile 1:
 
{{#cargo_query:
 
{{#cargo_query:
tables=characters=probant,characters=character
+
tables=characters
|join on=probant.Father=character.Father
+
|fields=_pageName=Page,IF(Father= '{{{2}}}' AND Mother= '{{{3}}}','','half-')=Full,CONCAT(CASE Sex WHEN 'Male' THEN 'brother' WHEN 'Female' THEN 'sister' ELSE 'sibling' END)=Genderedname
|fields=CONCAT('[[', character._pageName, '|', character.Birthname, ']]')=Page
+
|where=(Father='{{{2}}}' OR Mother='{{{3}}}') AND NOT _pageName='{{{1}}}'
|where=probant.Birthname <> character.Birtname
 
 
|intro=<tr><td>Siblings</td><td>
 
|intro=<tr><td>Siblings</td><td>
 
|outro=</td></tr>
 
|outro=</td></tr>
 
|default=
 
|default=
|format=list
+
|format=template
|delimiter=<br />
+
|named args=yes
 +
|template=Character/Siblings/Template
 
}}
 
}}

Aktuelle Version vom 14. Mai 2020, 18:28 Uhr