pathCast
Log in

Difference between revisions of "pathCast"

From pathCast
Line 3: Line 3:
 
<table style="width:100%"><tr><td style="background-color:#ffffff; width:49%">{{text|'''Upcoming lecture'''|||6|}}<br><br>
 
<table style="width:100%"><tr><td style="background-color:#ffffff; width:49%">{{text|'''Upcoming lecture'''|||6|}}<br><br>
 
{{#cargo_query:
 
{{#cargo_query:
tables=pathCast,faculty,subspecialty
+
tables=pathCast,pathCastBanners
|join on=pathCast.presenter1=faculty.namefirstlast,pathCast.subspecialty=subspecialty.subspecialty
+
|join on=pathCast._pageName=pathCastBanners._pageName
 
|fields=
 
|fields=
 
,pathCast._pageName
 
,pathCast._pageName
 
,pathCast.title
 
,pathCast.title
,pathCast.presenter2
+
,pathCastBanners._pageTitle
,faculty._pageTitle
 
,faculty.namefirstlast
 
,faculty.degree
 
,faculty.position
 
,faculty.institution
 
,pathCast.urlyt
 
,pathCast.series
 
,pathCast.date
 
,subspecialty.hashtag
 
,pathCast.uid
 
 
|where=DATEDIFF(pathCast.date,NOW()) >= +1 AND hide=0  
 
|where=DATEDIFF(pathCast.date,NOW()) >= +1 AND hide=0  
 
|order by=pathCast.date ASC
 
|order by=pathCast.date ASC

Revision as of 17:35, 8 September 2020