Difference between revisions of "pathCast"
Line 37: | Line 37: | ||
tables=pathCast,subspecialty | tables=pathCast,subspecialty | ||
|join on=pathCast.subspecialty=subspecialty.subspecialty | |join on=pathCast.subspecialty=subspecialty.subspecialty | ||
− | |fields=CONCAT('[[',subspecialty._pageName,'|',subspecialty.hashtag,']]') | + | |fields=CONCAT('[[',subspecialty._pageName,'|',subspecialty.hashtag,',' - ','subspecialty.name,']]') |
|group by=subspecialty.subspecialty | |group by=subspecialty.subspecialty | ||
|where=DATEDIFF(pathCast.date,NOW()) <= -0 AND hide=0 | |where=DATEDIFF(pathCast.date,NOW()) <= -0 AND hide=0 |
Revision as of 12:23, 7 September 2020
Upcoming lecture No results |
|
Ongoing pathCase series | |
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT CONCAT('',`cargo__subspecialty`.`hashtag`,',' - ','`cargo__subspecialty`.`name`,'') AS `_pageName,'|',subspecialty.hashtag,',' - ','subspecialty.name,']]')` FROM `cargo__pathCast` LEFT OUTER JOIN `cargo__subspecialty` ON ((`cargo__pathCast`.`subspecialty`=`cargo__subspecialty`.`subspecialty`)) WHERE DATEDIFF(`cargo__pathCast`.`date`,NOW()) <= -0 AND hide=0 GROUP BY `cargo__subspecialty`.`subspecialty` ORDER BY CONCAT('',`cargo__subspecialty`.`hashtag`,',' - ','`cargo__subspecialty`.`name`,'') 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 '.`name`,']]') AS `_pageName,'|',subspecialty.hashtag,',' - ','subspecialty.name,' at line 1 (localhost) |
|
|