Difference between revisions of "stats"
From pathCast
stats
(4 intermediate revisions by the same user not shown) | |||
Line 13: | Line 13: | ||
,uid=UID | ,uid=UID | ||
,user=User | ,user=User | ||
+ | ,CONCAT('{{pathCastedit{{#urldecode:%7C}}',pathCast._pageName,'}}')=Edit | ||
|order by=pathCast.date DESC | |order by=pathCast.date DESC | ||
|limit=500 | |limit=500 | ||
Line 49: | Line 50: | ||
|fields=MONTH(pathCast.date)=Month,COUNT(pathCast._pageName)=Count | |fields=MONTH(pathCast.date)=Month,COUNT(pathCast._pageName)=Count | ||
|group by=MONTH(pathCast.date) | |group by=MONTH(pathCast.date) | ||
− | |where=YEAR(pathCast.date)='2019' | + | |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> | ||
<td> | <td> | ||
+ | 2020 | ||
{{#cargo_query: | {{#cargo_query: | ||
|tables=pathCast,subspecialty | |tables=pathCast,subspecialty | ||
Line 60: | Line 94: | ||
|fields=MONTH(pathCast.date)=Month,COUNT(pathCast._pageName)=Count | |fields=MONTH(pathCast.date)=Month,COUNT(pathCast._pageName)=Count | ||
|group by=MONTH(pathCast.date) | |group by=MONTH(pathCast.date) | ||
− | | | + | |where=YEAR(pathCast.date)='2020' |
− | + | |}} | |
</td> | </td> | ||
Latest revision as of 17:46, 3 November 2020
If you are an admin, log in.