pathCast
Log in

Difference between revisions of "testpage"

From pathCast
 
(16 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{text|{{#cargo_query:
+
{{#cargo_query:
tables=pathCast,faculty,subspecialty
+
tables=pathCast,pathCastFiles
|join on=pathCast.presenter1=faculty.namefirstlast,pathCast.subspecialty=subspecialty.subspecialty
+
|join on=pathCast._pageName=pathCastFiles.pathCast
 
|fields=
 
|fields=
,pathCast.date=Date
+
,pathCast._pageName
,CONCAT('{{tablelink{{#urldecode:%7C}}',pathCast._pageName,'{{#urldecode:%7C}}',pathCast.title,'{{#urldecode:%7C}}',pathCast.urlyt,'}}')=Title
+
,pathCast.title
,CONCAT('[[',pathCast.presenter1,']] ',faculty.degree)=Presenter
+
,pathCastFiles._pageTitle
,CONCAT('[[',subspecialty._pageName,'|',subspecialty.name,']]')=Subspecialty
+
|where=DATEDIFF(pathCast.date,NOW()) >= +1 AND hide=0 AND pathCastFiles.filetype='banner'  
|order by=Date DESC
+
|order by=pathCast.date ASC
|limit=500
+
|limit=1
|format=dynamic table|}}|||3|}}
+
|more results text=
 +
|}}

Latest revision as of 11:36, 31 December 2020

No results