Difference between revisions of "testpage"

Latest revision as of 11:36, 31 December 2020

No results

@@ Line 1: / Line 1: @@
-{{text|{{#cargo_query:
+{{#cargo_query:
-tables=pathCast,faculty
+tables=pathCast,pathCastFiles
-|join on=pathCast.presenter1=faculty.namefirstlast
+|join on=pathCast._pageName=pathCastFiles.pathCast
 |fields=
-,CONCAT('{{tablelink{{#urldecode:%7C}}',pathCast._pageName,'{{#urldecode:%7C}}',pathCast.title,'{{#urldecode:%7C}}',pathCast.urlyt,'}}')=Title
+,pathCast._pageName
-,CONCAT('[[',pathCast.presenter1,']] ',faculty.degree)=Presenter
+,pathCast.title
-,pathCast.subspecialty=Subspecialty
+,pathCastFiles._pageTitle
-,pathCast.date=Date
+|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=
+|}}