Template:subspecialtyPage
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`) < '2024-05-02' 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`) < '2024-05-02' ORDER BY `Date` DESC LIMIT 500' at line 1 (localhost)