pathCast
Log in

Difference between revisions of "Template:facultyPage"

From pathCast
(Created page with "__NOCACHE__{{#css: td { vertical-align: top;} header#content-heading { display: none !important; } #content-wrapper { padding-left: 2.5em; !important; } }} <br><br> {{text|'''...")
 
Line 1: Line 1:
 
__NOCACHE__{{#css: td { vertical-align: top;} header#content-heading { display: none !important; } #content-wrapper { padding-left: 2.5em; !important; } }}
 
__NOCACHE__{{#css: td { vertical-align: top;} header#content-heading { display: none !important; } #content-wrapper { padding-left: 2.5em; !important; } }}
 
<br><br>
 
<br><br>
{{text|'''{{{1}}}'''|||6|}}<br>
+
{{text|'''{{{1}}}, {{{2}}}'''|||6|}}<br>
{{text|{{{2}}}|||4|}}
+
{{text|{{{3}}}, {{{4}}}|||4|}}
 
<br><br>
 
<br><br>
 
{{text|
 
{{text|
 
{{#css: td { vertical-align: top;} }}
 
{{#css: td { vertical-align: top;} }}
 
{{text|{{#cargo_query:
 
{{text|{{#cargo_query:
tables=pathCast,faculty,subspecialty
+
tables=pathCast,subspecialty
|join on=pathCast.presenter1=faculty.namefirstlast,pathCast.subspecialty=subspecialty.subspecialty
+
|join on=pathCast.subspecialty=subspecialty.subspecialty
 
|fields=
 
|fields=
 
,pathCast.date=Date
 
,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('{{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
|where=subspecialty.subspecialty='{{{3}}}' AND DATEDIFF(pathCast.date,NOW()) <= -0 AND hide=0
+
|where=pathCast.presenter1='{{{1}}}' AND DATEDIFF(pathCast.date,NOW()) <= -0 AND hide=0
 
|format=dynamic table|}}|||3|}}
 
|format=dynamic table|}}|||3|}}
 
|||3|}}
 
|||3|}}

Revision as of 20:02, 6 September 2020



{{{1}}}, {{{2}}}
{{{3}}}, {{{4}}}

No results