Template:Block literature highlight: Difference between revisions

Revision as of 09:34, 5 November 2025

{{{title}}}

{{ {{{buttons}}} }}

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 '.) AS `Reference(s)`,DATE_FORMAT(_modificationDate,"%M %Y") AS `Highlighted`,CON' at line 1

Function: CargoSQLQuery::run Query: SELECT CONCAT_WS(,'', Firstname, '', ' ', DATE_FORMAT(Year,"%Y"),'. ',Title,'. <i>', Journal,'</i>, ', Volume, Pages,'. ', CONCAT_WS(,'',DOI,'').) AS `Reference(s)`,DATE_FORMAT(_modificationDate,"%M %Y") AS `Highlighted`,CONCAT('',PublicationCitationsNr,'') AS `Cited` FROM `mw_cargo__BibEntryCargo` `BibEntryCargo` LEFT OUTER JOIN `mw_cargo__RefsInt2` `RefsInt2` ON ((`BibEntryCargo`.`_pageName`=`RefsInt2`.`_pageName`)) LEFT OUTER JOIN `mw_cargo__RefsInt1` `RefsInt1` ON ((`BibEntryCargo`.`_pageName`=`RefsInt1`.`_pageName`)) LEFT OUTER JOIN `mw_cargo___pageData` `_pageData` ON ((`BibEntryCargo`.`_pageName`=`_pageData`.`_pageName`)) WHERE CSDMSGroups LIKE "%{{{CSDMS_Group}}}%" && (`BibEntryCargo`.`BibType` = "journalArticle" OR `BibEntryCargo`.`BibType` = "book" OR `BibEntryCargo`.`BibType` = "bookSection") GROUP BY `BibEntryCargo`.`_pageName` ORDER BY `_modificationDate` DESC LIMIT 1000

@@ Line 6: / Line 6: @@
 |join on=BibEntryCargo._pageName=RefsInt2._pageName,BibEntryCargo._pageName=RefsInt1._pageName,BibEntryCargo._pageName=_pageData._pageName
 |where = CSDMSGroups LIKE "%{{{CSDMS_Group}}}%" && (BibEntryCargo.BibType = "journalArticle" OR BibEntryCargo.BibType = "book" OR BibEntryCargo.BibType = "bookSection")
-|fields=CONCAT_WS('','[[', BibEntryCargo._pageName, '|', Firstname, ']]', ' ', DATE_FORMAT(Year,"%Y"),'. ',Title,'. <i>', Journal,'</i>, ', Volume, Pages,'. ', CONCAT_WS('','[http://dx.doi.org/',DOI,' ',DOI,']')) =
+|fields=CONCAT_WS('','[[', BibEntryCargo._pageName, '|', Firstname, ']]', ' ', DATE_FORMAT(Year,"%Y"),'. ',Title,'. <i>', Journal,'</i>, ', Volume, Pages,'. ', CONCAT_WS('','[http://dx.doi.org/',DOI,' ',DOI,']').) =
 Reference(s), DATE_FORMAT(_modificationDate,"%M %Y")=Highlighted, CONCAT('[https://api.semanticscholar.org/graph/v1/paper/',Semantic_ID,' ',PublicationCitationsNr,']')=Cited
 |group by = BibEntryCargo._pageName