Difference between revisions of "stats"
From pathCast
stats
| Line 1: | Line 1: | ||
{{DISPLAYTITLE:pathCast: Analytics}} | {{DISPLAYTITLE:pathCast: Analytics}} | ||
{{IfGroup|sysop| | {{IfGroup|sysop| | ||
| + | {{text|{{#cargo_query: | ||
| + | tables=pathCast,faculty,subspecialty | ||
| + | |join on=pathCast.presenter1=faculty.namefirstlast,pathCast.subspecialty=subspecialty.subspecialty | ||
| + | |fields= | ||
| + | ,CONCAT('{{tabledate{{#urldecode:%7C}}',pathCast.date,'}}')=Date | ||
| + | ,CONCAT('[[',faculty._pageName,'|',pathCast.presenter1,']], ',faculty.degree)=Presenter | ||
| + | ,faculty.institution=Institution | ||
| + | ,CONCAT('{{tablelink{{#urldecode:%7C}}',pathCast._pageName,'{{#urldecode:%7C}}',pathCast.title,'{{#urldecode:%7C}}',pathCast.urlyt,'}}')=Lecture | ||
| + | ,CONCAT('[[',subspecialty._pageName,'|',subspecialty.name,']]')=Subspecialty | ||
| + | |where=DATEDIFF(pathCast.date,NOW()) | ||
| + | |order by=pathCast.date DESC | ||
| + | |limit=500 | ||
| + | |rows per page=5 | ||
| + | |format=dynamic table|}}|||2|}} | ||
| + | <br><br> | ||
<center>{{text|Lectures|||6|}}</center><br> | <center>{{text|Lectures|||6|}}</center><br> | ||
{{#cargo_query: | {{#cargo_query: | ||
| Line 65: | Line 80: | ||
|group by=MONTH(pathCast.date) | |group by=MONTH(pathCast.date) | ||
|}} | |}} | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|Goodbye!}} | |Goodbye!}} | ||
Revision as of 21:25, 7 September 2020
Goodbye!