Difference between revisions of "Template:subspecialtyPage"
From pathCast
| (10 intermediate revisions by the same user not shown) | |||
| Line 11: | Line 11: | ||
|fields= | |fields= | ||
,CONCAT('{{tabledate{{#urldecode:%7C}}',pathCast.date,'}}')=Date | ,CONCAT('{{tabledate{{#urldecode:%7C}}',pathCast.date,'}}')=Date | ||
| − | ,CONCAT(' | + | ,CONCAT('{{tableFacultyPhoto{{#urldecode:%7C}}',faculty.namefirst,'{{#urldecode:%7C}}',faculty.namelast,'{{#urldecode:%7C}}',faculty._pageName,'{{#urldecode:%7C}}',faculty.degree,'}}')=Presenter |
,faculty.institution=Institution | ,faculty.institution=Institution | ||
,CONCAT('{{tablelink{{#urldecode:%7C}}',pathCast._pageName,'{{#urldecode:%7C}}',pathCast.title,'{{#urldecode:%7C}}',pathCast.urlyt,'}}')=Lecture | ,CONCAT('{{tablelink{{#urldecode:%7C}}',pathCast._pageName,'{{#urldecode:%7C}}',pathCast.title,'{{#urldecode:%7C}}',pathCast.urlyt,'}}')=Lecture | ||
|order by=Date DESC | |order by=Date DESC | ||
| − | |limit=500 | + | |limit=500|default={{text|''No on-demand videos available at this time''||red|3|}} |
|where=subspecialty.subspecialty='{{{3}}}' AND DATEDIFF(pathCast.date,NOW()) <= -0 AND hide=0 | |where=subspecialty.subspecialty='{{{3}}}' AND DATEDIFF(pathCast.date,NOW()) <= -0 AND hide=0 | ||
|format=dynamic table|}}|||3|}} | |format=dynamic table|}}|||3|}} | ||
| Line 24: | Line 24: | ||
|join on=pathCast.presenter1=faculty.namefirstlast,pathCast.subspecialty=subspecialty.subspecialty | |join on=pathCast.presenter1=faculty.namefirstlast,pathCast.subspecialty=subspecialty.subspecialty | ||
|fields= | |fields= | ||
| − | + | ,pathCast._pageName | |
| − | + | ,pathCast.title | |
| − | |||
| − | |||
|order by=Date DESC | |order by=Date DESC | ||
| − | |limit=500 | + | |limit=500|default={{text|''No on-demand videos available at this time''||red|3|}} |
|where=subspecialty.subspecialty='{{{3}}}' AND DATEDIFF(pathCast.date,NOW()) <= -0 AND hide=0 | |where=subspecialty.subspecialty='{{{3}}}' AND DATEDIFF(pathCast.date,NOW()) <= -0 AND hide=0 | ||
| − | |format= | + | |format=template|template=linkbullet|}}|||3|}} |
</div> | </div> | ||
| − | |||
{{IfGroup|sysop| | {{IfGroup|sysop| | ||
| − | [[https://pathologycast.com/index.php?title={{FULLPAGENAME}}&action=edit]] | + | [[https://pathologycast.com/index.php?title={{FULLPAGENAME}}&action=edit Edit]] |
|}} | |}} | ||
Latest revision as of 20:20, 16 September 2020
{{{1}}}
{{{2}}}
No on-demand videos available at this time
No on-demand videos available at this time