Difference between revisions of "Template:pathCastPage"

Revision as of 20:33, 6 September 2020

{{{1}}}
[[{{{13}}}|{{{2}}}]]

Presented by {{{3}}}¹ and {{{15}}}²
¹{{{9}}}, {{{10}}}
²query

EmbedVideo received the bad id "{{{5}}}" for the service "youtube".

Part of the [[{{{6}}}]] series
Error: Invalid time.

{{text|

More {{{7}}} pathCast lectures

No results

More pathCast lectures by {{{3}}}, {{{8}}}

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `title` AS `title` FROM `cargo__pathCast` WHERE presenter='{{{12}}}' ORDER BY `title` LIMIT 100 Function: CargoSQLQuery::run Error: 1054 Unknown column 'presenter' in 'where clause' (localhost)

@@ Line 22: / Line 22: @@
 <br>
 {{text|{{collapsed|<u>More '''{{{7}}}''' pathCast lectures {{#fas:angle-down}}</u>|
-{{#cargo_query:
+{{text|
-tables=pathCast
+{{#css: td { vertical-align: top;} }}
-|fields=title
+{{text|{{#cargo_query:
-|where=subspecialty='{{{11}}}'
+tables=pathCast,faculty,subspecialty
-|format=ul
+|join on=pathCast.presenter1=faculty.namefirstlast,pathCast.subspecialty=subspecialty.subspecialty
-|}}
+|fields=
+,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
+|order by=Date DESC
+|limit=500
+|where=subspecialty.subspecialty='{{{11}}}' AND DATEDIFF(pathCast.date,NOW()) <= -0 AND hide=0
+|format=dynamic table|}}|||3|}}
 |}}|||4}}
 <br>