Template:Block literature highlight
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
