Personen aus dem 15.Jahrhundert: Unterschied zwischen den Versionen

Version vom 4. September 2024, 15:12 Uhr

 Neue Person

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 'year)) AS `seit` FROM `cargo__bookings` `b` LEFT OUTER JOIN `cargo__persons` `p' 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` 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)) LIMIT 100

83 Einträge

@@ Zeile 6: / Zeile 6: @@
    [[Spezial:Mit Formular bearbeiten/Person|Neue Person]]
 </div>
-{{#cargo_query:
+<!--{{#cargo_query:
    tables=persons,bookings
    |join on = bookings.person__full=persons._pagename
    |fields=bookings._pageName,persons._pageName=Name,  persons.type=Funktion, persons.job=Tätigkeit,
    |where=bookings.person__full > "!"
+}}-->
+{{#cargo_query:
+  tables=bookings=b, persons=p
+  |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, CONCAT(MIN(b.  year))=seit
+  |group by=p._pageName
+  |where=p._pageName IS NOT NULL
 }}
 {{#cargo_query:
    tables=persons
    |fields=COUNT(*)
 }}  Einträge