pathCast
Log in

Difference between revisions of "stats"

From pathCast
stats
Line 47: Line 47:
 
|tables=pathCast,subspecialty
 
|tables=pathCast,subspecialty
 
|join on=pathCast.subspecialty=subspecialty.subspecialty
 
|join on=pathCast.subspecialty=subspecialty.subspecialty
|fields=MONTH(pathCast.date),COUNT(pathCast._pageName)
+
|fields=MONTH(pathCast.date),YEAR(pathCast.date),COUNT(pathCast._pageName)
 
|group by=MONTH(pathCast.date)
 
|group by=MONTH(pathCast.date)
 
|}}
 
|}}

Revision as of 20:27, 8 September 2020

Goodbye!