Vorlage:Character/Siblings: Unterschied zwischen den Versionen

Aus Notebook
Zur Navigation springen Zur Suche springen
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=CONCAT('[[', _pageName, '|', Birthname, ']]')=Page,IF(Father= '{{{2}}}' AND Mother= '{{{3}}}','','half-')=Full
 
|where=(Father= '{{{2}}}' OR Mother= '{{{3}}}') AND NOT Birthname = '{{{1}}}'
 
|where=(Father= '{{{2}}}' OR Mother= '{{{3}}}') AND NOT Birthname = '{{{1}}}'
 
|intro=<tr><td>Siblings</td><td>
 
|intro=<tr><td>Siblings</td><td>

Version vom 14. Mai 2020, 05:37 Uhr