Difference between revisions of "Template:subspecialtyPage"
From pathCast
| (13 intermediate revisions by the same user not shown) | |||
| Line 4: | Line 4: | ||
{{text|{{{2}}}|||4|}} | {{text|{{{2}}}|||4|}} | ||
<br><br> | <br><br> | ||
| − | + | <div class="desktop"> | |
{{#css: td { vertical-align: top;} }} | {{#css: td { vertical-align: top;} }} | ||
{{text|{{#cargo_query: | {{text|{{#cargo_query: | ||
| 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|}} | ||
| − | |||3|}} | + | </div> |
| + | <div class="mobile_device_480px"> | ||
| + | {{text|{{#cargo_query: | ||
| + | tables=pathCast,faculty,subspecialty | ||
| + | |join on=pathCast.presenter1=faculty.namefirstlast,pathCast.subspecialty=subspecialty.subspecialty | ||
| + | |fields= | ||
| + | ,pathCast._pageName | ||
| + | ,pathCast.title | ||
| + | |order by=Date DESC | ||
| + | |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 | ||
| + | |format=template|template=linkbullet|}}|||3|}} | ||
| + | </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