Template:Block literature highlight

From CSDMS
Revision as of 11:51, 30 October 2025 by WikiSysop (talk | contribs)
{{{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