Template:Block literature highlight: Difference between revisions

Revision as of 11:51, 30 October 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 'HOLDS "{{{CSDMS_Group}}}" && (`BibEntryCargo`.`BibType` = "journalArticle" OR `B' 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 `Peer reviewed 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 HOLDS "{{{CSDMS_Group}}}" && (`BibEntryCargo`.`BibType` = "journalArticle" OR `BibEntryCargo`.`BibType` = "book" OR `BibEntryCargo`.`BibType` = "bookSection") GROUP BY `BibEntryCargo`.`_pageName` ORDER BY `_modificationDate` DESC LIMIT 1000

@@ Line 5: / Line 5: @@
 tables=BibEntryCargo,RefsInt2,RefsInt1,_pageData
 |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")
+|where = CSDMSGroups HOLDS "{{{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,']')) =
 Peer reviewed reference(s), DATE_FORMAT(_modificationDate,"%M %Y")=Highlighted, CONCAT('[https://api.semanticscholar.org/graph/v1/paper/',Semantic_ID,' ',PublicationCitationsNr,']')=Cited