Personen aus dem 15.Jahrhundert: Unterschied zwischen den Versionen
ER>ERadmin Keine Bearbeitungszusammenfassung |
ER>ERadmin Keine Bearbeitungszusammenfassung |
||
| Zeile 16: | Zeile 16: | ||
|join on=b.person__full=p._pageName | |join on=b.person__full=p._pageName | ||
|fields=p._pageName=Name (norm.), p.mention=Nennung, IF(p.type>"",p.type,p.job__full)=Funktion/Job, | |fields=p._pageName=Name (norm.), p.mention=Nennung, IF(p.type>"",p.type,p.job__full)=Funktion/Job, | ||
CONCAT(MIN(b.year))=seit,CONCAT( | CONCAT(MIN(b.year))=seit,CONCAT([[p._pagename|F]])=, | ||
|group by=p._pageName | |group by=p._pageName | ||
|where=p._pageName IS NOT NULL | |where=p._pageName IS NOT NULL | ||
Version vom 4. September 2024, 15:24 Uhr
Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'F) AS `Blank value 1` FROM `cargo__bookings` `b` LEFT OUTER' at line 1
Function: CargoSQLQuery::run Query: SELECT `p`.`_pageName` AS `Name (norm.)`,`mention__full` AS `Nennung`,IF(`p`.`type`>"",`p`.`type`,`p`.`job__full`) AS `Funktion/Job`,CONCAT(MIN(`b`.`year`)) AS `seit`,CONCAT(F) AS `Blank value 1` FROM `cargo__bookings` `b` LEFT OUTER JOIN `cargo__persons` `p` ON ((`b`.`person__full`=`p`.`_pageName`)) WHERE `p`.`_pageName` IS NOT NULL GROUP BY `p`.`_pageName` ORDER BY `p`.`_pageName`,`p`.`mention__full` ,IF(`p`.`type`>"",`p`.`type`,`p`.`job__full`),CONCAT(MIN(`b`.`year`)),CONCAT(F) LIMIT 100
83 Einträge