Difference between revisions of "stats"
From pathCast
stats
| Line 50: | Line 50: | ||
|group by=MONTH(pathCast.date) | |group by=MONTH(pathCast.date) | ||
|where=YEAR(pathCast.date)='2019' OR YEAR(pathCast.date)='2018' OR YEAR(pathCast.date)='2017' | |where=YEAR(pathCast.date)='2019' OR YEAR(pathCast.date)='2018' OR YEAR(pathCast.date)='2017' | ||
| + | |}} | ||
| + | </td> | ||
| + | |||
| + | <td> | ||
| + | 2017 | ||
| + | {{#cargo_query: | ||
| + | |tables=pathCast,subspecialty | ||
| + | |join on=pathCast.subspecialty=subspecialty.subspecialty | ||
| + | |fields=MONTH(pathCast.date)=Month,COUNT(pathCast._pageName)=Count | ||
| + | |group by=MONTH(pathCast.date) | ||
| + | |where=YEAR(pathCast.date)='2017' | ||
| + | |}} | ||
| + | </td> | ||
| + | |||
| + | <td> | ||
| + | 2018 | ||
| + | {{#cargo_query: | ||
| + | |tables=pathCast,subspecialty | ||
| + | |join on=pathCast.subspecialty=subspecialty.subspecialty | ||
| + | |fields=MONTH(pathCast.date)=Month,COUNT(pathCast._pageName)=Count | ||
| + | |group by=MONTH(pathCast.date) | ||
| + | |where=YEAR(pathCast.date)='2018' | ||
| + | |}} | ||
| + | </td> | ||
| + | |||
| + | <td> | ||
| + | 2019 | ||
| + | {{#cargo_query: | ||
| + | |tables=pathCast,subspecialty | ||
| + | |join on=pathCast.subspecialty=subspecialty.subspecialty | ||
| + | |fields=MONTH(pathCast.date)=Month,COUNT(pathCast._pageName)=Count | ||
| + | |group by=MONTH(pathCast.date) | ||
| + | |where=YEAR(pathCast.date)='2019' | ||
|}} | |}} | ||
</td> | </td> | ||
Revision as of 12:05, 16 September 2020
If you are an admin, log in.