Difference between revisions of "Template:subspecialtyPage"
From pathCast
(16 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 10: | Line 10: | ||
|join on=pathCast.presenter1=faculty.namefirstlast,pathCast.subspecialty=subspecialty.subspecialty | |join on=pathCast.presenter1=faculty.namefirstlast,pathCast.subspecialty=subspecialty.subspecialty | ||
|fields= | |fields= | ||
− | ,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