Vorlage:Character/Siblings: Unterschied zwischen den Versionen

Aus Notebook
Zur Navigation springen Zur Suche springen
 
(9 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt)
Zeile 1: Zeile 1:
 
{{#cargo_query:
 
{{#cargo_query:
 
tables=characters
 
tables=characters
|fields=CONCAT('[[', _pageName, '|', Birthname, ']]')=Page,IF(Father= '{{{2}}}' AND Mother= '{{{3}}}',CONCAT('full',CHAR(0x80)),'half-')=Full
+
|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
|where=(Father= '{{{2}}}' OR Mother= '{{{3}}}') AND NOT Birthname = '{{{1}}}'
+
|where=(Father='{{{2}}}' OR Mother='{{{3}}}') AND NOT _pageName='{{{1}}}'
 
|intro=<tr><td>Siblings</td><td>
 
|intro=<tr><td>Siblings</td><td>
 
|outro=</td></tr>
 
|outro=</td></tr>

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