CSDMS miscellaneous by numbers: Difference between revisions

From CSDMS
Line 116: Line 116:
|join on=BibEntryCargo._pageName = _pageData._pageName
|join on=BibEntryCargo._pageName = _pageData._pageName
|fields=BibEntryCargo._pageName= _pageData._creationDate,COUNT(*)
|fields=BibEntryCargo._pageName= _pageData._creationDate,COUNT(*)
|where=  _pageData._creationDate LIKE '%2014%'
|where=  _pageData._creationDate < '%2014%'
|format=template|template=CountingCARGO}}
|format=template|template=CountingCARGO}}
|-
|-

Revision as of 19:31, 10 June 2020

Miscellaneous services for the community

Job advertisements per calendar year

Year Job advertisements per year
2020 224
2019 267
2018 231
2017 194
2016 158
2015 132
2014 122
2013 28

Note: This service was not provided before 2013

Meeting announcements per calendar year

Year Meeting announcements per year
2020 21
2019 60
2018 55
2017 50
2016 38
2015 43
2014 35
2013 46

Note: This service was not provided before 2013

Added references for models per calendar year

Year References added per year
2020 10966
2019 575
2018 50
2017 232
2016 157
2015 26
2014
Error 1525: Incorrect DATETIME value: '%2014%' (localhost)

Function: CargoSQLQuery::run Query: SELECT `mw_cargo__BibEntryCargo`.`_pageID` AS `cargo_backlink_page_id_BibEntryCargo`,`mw_cargo__BibEntryCargo`.`_pageName` AS `_pageData._creationDate`,COUNT(*) FROM `mw_cargo__BibEntryCargo` LEFT OUTER JOIN `mw_cargo___pageData` ON ((`mw_cargo__BibEntryCargo`.`_pageName`=`mw_cargo___pageData`.`_pageName`)) WHERE `mw_cargo___pageData`.`_creationDate` < '%2014%' ORDER BY `mw_cargo__BibEntryCargo`.`_pageID`,`mw_cargo__BibEntryCargo`.`_pageName`,COUNT(*) LIMIT 50000

2013 512

Note: This service was not provided before 2013