Difference between revisions of "stats"
From pathCast
stats
Line 30: | Line 30: | ||
|}} | |}} | ||
<br><br> | <br><br> | ||
− | <center>{{text|By | + | <center>{{text|By year: 2020|||6|}}</center><br> |
{{#cargo_query: | {{#cargo_query: | ||
|tables=pathCast,subspecialty | |tables=pathCast,subspecialty | ||
|join on=pathCast.subspecialty=subspecialty.subspecialty | |join on=pathCast.subspecialty=subspecialty.subspecialty | ||
|fields=pathCast.date,COUNT(pathCast._pageName) | |fields=pathCast.date,COUNT(pathCast._pageName) | ||
− | |where=YEAR(pathCast.date)='2020' | + | |where=YEAR(pathCast.date)='2020' |
+ | |group by=MONTH(pathCast.date) | ||
+ | |}} | ||
+ | <br><br> | ||
+ | <center>{{text|By year: 2019|||6|}}</center><br> | ||
+ | {{#cargo_query: | ||
+ | |tables=pathCast,subspecialty | ||
+ | |join on=pathCast.subspecialty=subspecialty.subspecialty | ||
+ | |fields=pathCast.date,COUNT(pathCast._pageName) | ||
+ | |where=YEAR(pathCast.date)='2019' | ||
+ | |group by=MONTH(pathCast.date) | ||
+ | |}} | ||
+ | <br><br> | ||
+ | <center>{{text|By year: 2018|||6|}}</center><br> | ||
+ | {{#cargo_query: | ||
+ | |tables=pathCast,subspecialty | ||
+ | |join on=pathCast.subspecialty=subspecialty.subspecialty | ||
+ | |fields=pathCast.date,COUNT(pathCast._pageName) | ||
+ | |where=YEAR(pathCast.date)='2018' | ||
+ | |group by=MONTH(pathCast.date) | ||
+ | |}} | ||
+ | <br><br> | ||
+ | <center>{{text|By year: 2017|||6|}}</center><br> | ||
+ | {{#cargo_query: | ||
+ | |tables=pathCast,subspecialty | ||
+ | |join on=pathCast.subspecialty=subspecialty.subspecialty | ||
+ | |fields=pathCast.date,COUNT(pathCast._pageName) | ||
+ | |where=YEAR(pathCast.date)='2017' | ||
|group by=MONTH(pathCast.date) | |group by=MONTH(pathCast.date) | ||
|}} | |}} | ||
|Goodbye!}} | |Goodbye!}} |
Revision as of 18:36, 7 September 2020
Goodbye!