Template:Include references models cargo: Difference between revisions
No edit summary |
No edit summary |
||
| Line 7: | Line 7: | ||
* {{ | * {{ | ||
#arraydefine: val | {{#arrayindex:refs | {{#var:i}} }} | ; | #arraydefine: val | {{#arrayindex:refs | {{#var:i}} }} | ; | ||
}} {{#cargo_query:tables=RefsExt|where = _pageName = '{{#arrayindex: val | 0}}'|default=|fields= Lastname, Firstname|format=template|template=Test4a}} | }} {{#cargo_query:tables=RefsExt|where = _pageName = '{{#arrayindex: val | 0}}'|default=|fields= Lastname, Firstname|format=template|template=Test4a}}{{#cargo_query:tables=RefsExt2|where = _pageName = '{{#arrayindex: val | 0}}'|default=|fields= Publicationdate, Title, PublicationTitle |format=template|template=Test5a}} | ||
}} | }} | ||
Revision as of 10:49, 5 May 2017
- 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 'PublicationMultipleModelsCargo' in 'where clause'\x0AFunction: CargoSQLQuery::ru' at line 1
Function: CargoSQLQuery::run Query: SELECT `RefsExt`.`_pageID` AS `cargo_backlink_page_id_RefsExt`,`Lastname` AS `Lastname`,`Firstname` AS `Firstname` FROM `mw_cargo__RefsExt` `RefsExt` WHERE _pageName = '<div class="error">Error 1054: Unknown column 'PublicationMultipleModelsCargo' in 'where clause' Function: CargoSQLQuery::run Query: SELECT `RefsInt1`.`_pageID` AS `cargo_backlink_page_id_RefsInt1`' ORDER BY `RefsExt`.`_pageID`,`Lastname`,`Firstname` LIMIT 1000
Function: CargoSQLQuery::run Query: SELECT `RefsExt2`.`_pageID` AS `cargo_backlink_page_id_RefsExt2`,`Publicationdate` AS `Publicationdate`,`Title` AS `Title`,`PublicationTitle` AS `PublicationTitle` FROM `mw_cargo__RefsExt2` `RefsExt2` WHERE _pageName = '<div class="error">Error 1054: Unknown column 'PublicationMultipleModelsCargo' in 'where clause' Function: CargoSQLQuery::run Query: SELECT `RefsInt1`.`_pageID` AS `cargo_backlink_page_id_RefsInt1`' ORDER BY `RefsExt2`.`_pageID`,`Publicationdate`,`Title`,`PublicationTitle` LIMIT 1000
- 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 'Include references models cargo' ORDER BY `RefsInt1`.`_pageID`' ORDER BY `Refs' at line 1
Function: CargoSQLQuery::run Query: SELECT `RefsExt`.`_pageID` AS `cargo_backlink_page_id_RefsExt`,`Lastname` AS `Lastname`,`Firstname` AS `Firstname` FROM `mw_cargo__RefsExt` `RefsExt` WHERE _pageName = '`_pageName` AS `_pageName` FROM `mw_cargo__RefsInt1` `RefsInt1` WHERE PublicationMultipleModelsCargo = 'Include references models cargo' ORDER BY `RefsInt1`.`_pageID`' ORDER BY `RefsExt`.`_pageID`,`Lastname`,`Firstname` LIMIT 1000
Function: CargoSQLQuery::run Query: SELECT `RefsExt2`.`_pageID` AS `cargo_backlink_page_id_RefsExt2`,`Publicationdate` AS `Publicationdate`,`Title` AS `Title`,`PublicationTitle` AS `PublicationTitle` FROM `mw_cargo__RefsExt2` `RefsExt2` WHERE _pageName = '`_pageName` AS `_pageName` FROM `mw_cargo__RefsInt1` `RefsInt1` WHERE PublicationMultipleModelsCargo = 'Include references models cargo' ORDER BY `RefsInt1`.`_pageID`' ORDER BY `RefsExt2`.`_pageID`,`Publicationdate`,`Title`,`PublicationTitle` LIMIT 1000
