pathCast
Log in

Difference between revisions of "Template:subspecialtyPage"

From pathCast
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=
,CONCAT('{{tabledate{{#urldecode:%7C}}',pathCast.date,'}}')=Date
+
,pathCast._pageName
,CONCAT('[[',faculty._pageName,'|',pathCast.presenter1,']], ',faculty.degree)=Presenter
+
,pathCast.title
,faculty.institution=Institution
 
,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=subspecialty.subspecialty='{{{3}}}' AND DATEDIFF(pathCast.date,NOW()) <= -0 AND hide=0
|format=dynamic table|}}|||3|}}
+
|format=template|template=linkbullet|}}|||3|}}
 
     </div>
 
     </div>
  

Revision as of 13:51, 7 September 2020



{{{1}}}
{{{2}}}

No results

No results