Difference between revisions of "Template:subspecialtyPage"
Line 16: | Line 16: | ||
|order by=Date DESC | |order by=Date DESC | ||
|limit=500 | |limit=500 | ||
− | |where=subspecialty.subspecialty='{{{3}}}' AND CURRENT_DATE(pathCast.date) <= '{{#time: | + | |where=subspecialty.subspecialty='{{{3}}}' AND CURRENT_DATE(pathCast.date) <= '{{#expr: {{#time: W|{{Timezone}}}} - 1 }}' |
|format=dynamic table|}}|||3|}} | |format=dynamic table|}}|||3|}} | ||
|||3|}} | |||3|}} |
Revision as of 18:42, 6 September 2020
Template:subspecialtyPage [1]
{{{1}}}
{{{2}}}
Query: SELECT `cargo__pathCast`.`date` AS `Date`,CONCAT('',`cargo__pathCast`.`presenter1`,', ',`cargo__faculty`.`degree`) AS `Presenter`,`cargo__faculty`.`institution` AS `Institution`,CONCAT('{{tablelink|',`cargo__pathCast`.`_pageName`,'|',`cargo__pathCast`.`title`,'|',`cargo__pathCast`.`urlyt`,'}}') AS `Lecture`,`cargo__pathCast`.`date__precision` AS `Date__precision` FROM `cargo__pathCast` LEFT OUTER JOIN `cargo__faculty` ON ((`cargo__pathCast`.`presenter1`=`cargo__faculty`.`namefirstlast`)) LEFT OUTER JOIN `cargo__subspecialty` ON ((`cargo__pathCast`.`subspecialty`=`cargo__subspecialty`.`subspecialty`)) WHERE `cargo__subspecialty`.`subspecialty`='{{{3}}}' AND CURRENT_DATE(`cargo__pathCast`.`date`) <= '<strong class="error">Expression error: Unexpected < operator.</strong>' ORDER BY `Date` DESC LIMIT 500 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 '`cargo__pathCast`.`date`) <= '<strong class="error">Expression error: Unexpected' at line 1 (localhost)