Test cargo: Difference between revisions

Latest revision as of 10:42, 24 October 2021

2705

@@ Line 1: / Line 1: @@
+{{#count:
+{{
+#cargo_query:tables=BibEntryCargo,_pageData
-{| style="width:65%;
-| '''Year'''
-|align="left"| '''Total references in database & ''(added per calendar year)'''''
-|-
-| 2021
-|{{#cargo_query:tables=BibEntryCargo,_pageData
 |join on=BibEntryCargo._pageName = _pageData._pageName
 |fields=BibEntryCargo._pageName= _pageData._creationDate,COUNT(*)
-|where=  _pageData._creationDate LIKE '%2021%' OR _pageData._creationDate LIKE '%2020%' OR _pageData._creationDate LIKE '%2019%' OR _pageData._creationDate LIKE '%2018%' OR _pageData._creationDate LIKE '%2017%' OR _pageData._creationDate LIKE '%2016%' OR _pageData._creationDate LIKE '%2015%' OR _pageData._creationDate LIKE'%2014%' OR _pageData._creationDate LIKE'%2013%'
-|format=template|template=CountingCARGO}}
+|limit=5000
-|-
-|}</small>
+|where=  _pageData._creationDate LIKE '%2021%'  GROUP BY BibEntryCargo._pageName
+|format=template|template=CountingCARGO
+}}
+|1}}