Vorlage:Character/Siblings: Unterschied zwischen den Versionen
| Zeile 1: | Zeile 1: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=characters | tables=characters | ||
| − | |fields=CONCAT('[[', _pageName, '|', Birthname, ']]')=Page,IF(Father= '{{{2}}}' AND Mother= '{{{3}}}','','half-')=Full,CASE Sex WHEN 'Male' THEN 'brother' WHEN 'Female' THEN 'sister' ELSE 'sibling'=Genderedname | + | |fields=CONCAT('[[', _pageName, '|', Birthname, ']]')=Page,IF(Father= '{{{2}}}' AND Mother= '{{{3}}}','','half-')=Full,CONCAT(CASE Sex WHEN 'Male' THEN 'brother' WHEN 'Female' THEN 'sister' ELSE 'sibling')=Genderedname |
|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, 09:16 Uhr
Query: SELECT CONCAT('', Birthname, '') AS `Page`,IF(Father= '{{{2}}}' AND Mother= '{{{3}}}',,'half-') AS `Full`,CONCAT(CASE Sex WHEN 'Male' THEN 'brother' WHEN 'Female' THEN 'sister' ELSE 'sibling') AS `Genderedname` FROM `cargo__characters` WHERE (Father= '{{{2}}}' OR Mother= '{{{3}}}') AND NOT Birthname = '{{{1}}}' ORDER BY CONCAT('', Birthname, ''),IF(Father= '{{{2}}}' AND Mother= '{{{3}}}',,'half-'),CONCAT(CASE Sex WHEN 'Male' THEN 'brother' WHEN 'Female' THEN 'sister' ELSE 'sibling') LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AS `Genderedname` FROM `cargo__characters` WHERE (Father= '{{{2}}}' OR Mot' at line 1 (localhost)
