Difference between revisions of "stats"
From pathCast
stats
| (9 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 41: | Line 42: | ||
{{text|Total: {{text|{{#cargo_query: |tables=pathCast,subspecialty |join on=pathCast.subspecialty=subspecialty.subspecialty |fields=COUNT(pathCast._pageName)|}}||red|}}|||4|}} | {{text|Total: {{text|{{#cargo_query: |tables=pathCast,subspecialty |join on=pathCast.subspecialty=subspecialty.subspecialty |fields=COUNT(pathCast._pageName)|}}||red|}}|||4|}} | ||
</td> | </td> | ||
| + | |||
| + | <td> | ||
| + | 2017-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' 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> | ||
| + | 2020 | ||
| + | {{#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)='2020' | ||
| + | |}} | ||
| + | </td> | ||
| + | |||
</tr> | </tr> | ||
</table> | </table> | ||
| Line 48: | Line 105: | ||
tables=faculty | tables=faculty | ||
|fields= | |fields= | ||
| − | ,_pageName | + | ,CONCAT('{{tableFacultyPhoto{{#urldecode:%7C}}',faculty.namefirst,'{{#urldecode:%7C}}',faculty.namelast,'{{#urldecode:%7C}}',faculty._pageName,'{{#urldecode:%7C}}',faculty.degree,'}}')=Faculty |
| − | , | ||
| − | ,degree= | ||
,institution=Institution | ,institution=Institution | ||
|limit=500 | |limit=500 | ||
| Line 64: | Line 119: | ||
|view=month | |view=month | ||
|}} | |}} | ||
| + | <br> | ||
{{#cargo_query: | {{#cargo_query: | ||
|tables=pathCast,subspecialty | |tables=pathCast,subspecialty | ||
Latest revision as of 17:46, 3 November 2020
If you are an admin, log in.