Template:Block literature highlight

From CSDMS
Revision as of 09:30, 5 November 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 '. HighLightText AS `Reference(s)`,DATE_FORMAT(_modificationDate,"%M %Y") AS `Hig' at line 1

Function: CargoSQLQuery::run Query: SELECT CONCAT_WS(,'', Firstname, '', ' ', DATE_FORMAT(Year,"%Y"),'. ',Title,'. <i>', Journal,'</i>, ', Volume, Pages,'. ', CONCAT_WS(,'',DOI,'')). HighLightText 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