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
@@ Line 6: / Line 7: @@
 |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%' GROUP BY BibEntryCargo._pageName
+|limit=5000
+|where=  _pageData._creationDate LIKE '%2021%'  GROUP BY BibEntryCargo._pageName
 |format=template|template=CountingCARGO
 }}
-<!--
+|1}}
-SELECT id, password, COUNT(id) AS count FROM users WHERE email = :email GROUP BY id, password LIMIT 1
--->