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)=Month,YEAR(pathCast.date)=Year,COUNT(pathCast._pageName)=Count
 
|group by=YEAR(pathCast.date)
 
|group by=YEAR(pathCast.date)
 
|}}
 
|}}

Revision as of 20:29, 8 September 2020

Goodbye!