pathCast
Log in

Difference between revisions of "stats"

From pathCast
stats
Line 79: Line 79:
 
|where=YEAR(pathCast.date)='2017'
 
|where=YEAR(pathCast.date)='2017'
 
|group by=MONTH(pathCast.date)
 
|group by=MONTH(pathCast.date)
 +
|}}
 
<br><br>
 
<br><br>
<center>{{text|By year: 2017 ({{text|{{#cargo_query: |tables=pathCast,subspecialty |join on=pathCast.subspecialty=subspecialty.subspecialty |fields=COUNT(pathCast._pageName) |where=YEAR(pathCast.date)='2017' |}}||red|}})|||6|}}</center><br>
+
<center>{{text|By year: 2016 ({{text|{{#cargo_query: |tables=pathCast,subspecialty |join on=pathCast.subspecialty=subspecialty.subspecialty |fields=COUNT(pathCast._pageName) |where=YEAR(pathCast.date)='2016' |}}||red|}})|||6|}}</center><br>
 
{{#cargo_query:
 
{{#cargo_query:
 
|tables=pathCast,subspecialty
 
|tables=pathCast,subspecialty

Revision as of 20:11, 8 September 2020

Goodbye!