HydroTrend-Rest-Publications: Difference between revisions
No edit summary |
No edit summary |
||
Line 57: | Line 57: | ||
tables=BibEntryCargo,RefsInt2,RefsInt1 | tables=BibEntryCargo,RefsInt2,RefsInt1 | ||
|join on=BibEntryCargo._pageName=RefsInt2._pageName,BibEntryCargo._pageName=RefsInt1._pageName | |join on=BibEntryCargo._pageName=RefsInt2._pageName,BibEntryCargo._pageName=RefsInt1._pageName | ||
|where = PublicationMultipleModelsCargo LIKE "{{#replace:{{PAGENAME}}|-Rest-Publications}}" AND BibEntryCargo.BibType != ("journalArticle", " | |where = PublicationMultipleModelsCargo LIKE "{{#replace:{{PAGENAME}}|-Rest-Publications}}" AND BibEntryCargo.BibType != ("journalArticle", "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,']')) = | ||
Journal Article(s), DATE_FORMAT(Year,"%Y")=Year, CONCAT('[https://api.semanticscholar.org/graph/v1/paper/',Semantic_ID,' ',PublicationCitationsNr,']')=Cited | Journal Article(s), DATE_FORMAT(Year,"%Y")=Year, CONCAT('[https://api.semanticscholar.org/graph/v1/paper/',Semantic_ID,' ',PublicationCitationsNr,']')=Cited |
Revision as of 10:50, 25 September 2024
Total peer and non-peer reviewed publications |
61 |
Journal Articles |
50 |
Books |
1 |
Book sections |
2 |
Reports |
2 |
Thesis |
2 |
Abstracts |
2 |
Code |
1 |
Blogs |
0 |
Miscellaneous |
1 |
Web |
0 |
Preprints |
0 |
Function: CargoSQLQuery::run Query: SELECT CONCAT_WS(,'', Firstname, '', ' ', DATE_FORMAT(Year,"%Y"),'. ',Title,'. <i>', Journal,'</i>, ', Volume, Pages,'. ', CONCAT_WS(,'',DOI,'')) AS `Journal Article(s)`,DATE_FORMAT(Year,"%Y") AS `Year`,CONCAT('',PublicationCitationsNr,'') AS `Cited` FROM `mw_cargo__BibEntryCargo` LEFT OUTER JOIN `mw_cargo__RefsInt2` ON ((`mw_cargo__BibEntryCargo`.`_pageName`=`mw_cargo__RefsInt2`.`_pageName`)) LEFT OUTER JOIN `mw_cargo__RefsInt1` ON ((`mw_cargo__BibEntryCargo`.`_pageName`=`mw_cargo__RefsInt1`.`_pageName`)) WHERE PublicationMultipleModelsCargo LIKE "HydroTrend" AND `mw_cargo__BibEntryCargo`.`BibType` != ("journalArticle", "bookSection") GROUP BY `mw_cargo__BibEntryCargo`.`_pageName` ORDER BY `Year` DESC LIMIT 10000
Nr. of publications: | 56 |
Total citations: | 2278 |
h-index: | 28 |
m-quotient: | 0.9 |