Difference between revisions of "stats"
From pathCast
stats
| Line 65: | Line 65: | ||
|group by=MONTH(pathCast.date) | |group by=MONTH(pathCast.date) | ||
|}} | |}} | ||
| + | <br><br> | ||
| + | {{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 | ||
| + | |format=dynamic table|}}|||3|}} | ||
|Goodbye!}} | |Goodbye!}} | ||
Revision as of 18:39, 7 September 2020
Goodbye!