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 | |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