Difference between revisions of "Template:pathCastPage"
Line 28: | Line 28: | ||
<div class="desktop"> | <div class="desktop"> | ||
<hr> | <hr> | ||
− | {{#cargo_query: tables=pathCast,pathCastFiles |join on=pathCast._pageName=pathCastFiles.pathCast|fields=pathCastFiles._pageTitle|where=pathCastFiles.filetype='pdf'|format=template|template=pdf|}} | + | {{#cargo_query: tables=pathCast,pathCastFiles |join on=pathCast._pageName=pathCastFiles.pathCast|fields=pathCastFiles._pageTitle|where=pathCastFiles.filetype='pdf' AND pathCastFiles.pathCast='{{CURRENTPAGE}}'|format=template|template=pdf|}} |
− | {{#cargo_query: tables=pathCast,pathCastFiles |join on=pathCast._pageName=pathCastFiles.pathCast|fields=pathCastFiles._pageTitle|where=pathCastFiles.filetype='pdf'|}} | + | {{#cargo_query: tables=pathCast,pathCastFiles |join on=pathCast._pageName=pathCastFiles.pathCast|fields=pathCastFiles._pageTitle|where=pathCastFiles.filetype='pdf' AND |}} |
<br><br> | <br><br> | ||
{{#if: {{#cargo_query: tables=pathCast,faculty,subspecialty |join on=pathCast.presenter1=faculty.namefirstlast,pathCast.subspecialty=subspecialty.subspecialty |fields= ,CONCAT('{{tabledate{{#urldecode:%7C}}',pathCast.date,'}}')=Date|where=subspecialty.subspecialty='{{{11}}}' AND DATEDIFF(pathCast.date,NOW()) <= -0 AND hide=0 AND NOT pathCast._pageName='{{PAGENAME}}'|default=|}} | {{#if: {{#cargo_query: tables=pathCast,faculty,subspecialty |join on=pathCast.presenter1=faculty.namefirstlast,pathCast.subspecialty=subspecialty.subspecialty |fields= ,CONCAT('{{tabledate{{#urldecode:%7C}}',pathCast.date,'}}')=Date|where=subspecialty.subspecialty='{{{11}}}' AND DATEDIFF(pathCast.date,NOW()) <= -0 AND hide=0 AND NOT pathCast._pageName='{{PAGENAME}}'|default=|}} |
Revision as of 20:02, 9 September 2020
{{{1}}}
[[{{{13}}}|{{{2}}}]]
Presented by [[{{{14}}}|{{{3}}}, {{{8}}}]]1 and No results2
1{{{9}}}, {{{10}}}
2No results
Part of the [[{{{6}}}]] series
Error: Invalid time. (ET, NYC)
Watch this lecture by clicking on the video above. You can also watch it on our Facebook page or YouTube channel.
No results
Query: SELECT `cargo__pathCastFiles`.`_pageTitle` AS `_pageTitle` FROM `cargo__pathCast` LEFT OUTER JOIN `cargo__pathCastFiles` ON ((`cargo__pathCast`.`_pageName`=`cargo__pathCastFiles`.`pathCast`)) WHERE `cargo__pathCastFiles`.`filetype`='pdf' AND ORDER BY `cargo__pathCastFiles`.`_pageTitle` LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY `cargo__pathCastFiles`.`_pageTitle` LIMIT 100' at line 1 (localhost)