Difference between revisions of "Template:subspecialtyPage"
| Line 4: | Line 4: | ||
{{text|{{{2}}}|||4|}} | {{text|{{{2}}}|||4|}} | ||
<br><br> | <br><br> | ||
| + | {{text| | ||
| + | {{#css: td { vertical-align: top;} }} | ||
{{text|{{#cargo_query: | {{text|{{#cargo_query: | ||
| − | tables=pathCast | + | tables=pathCast,faculty,subspecialty |
| + | |join on=pathCast.presenter1=faculty.namefirstlast,pathCast.subspecialty=subspecialty.subspecialty | ||
|fields= | |fields= | ||
| − | ,CONCAT(' | + | ,pathCast.date=Date |
| − | ,CONCAT('{{tablelink{{#urldecode:%7C}}',_pageName,'{{#urldecode:%7C}}',title,'}}')=Title | + | ,CONCAT('[[',pathCast.presenter1,']], ',faculty.degree)=Presenter |
| − | + | ,CONCAT('{{tablelink{{#urldecode:%7C}}',pathCast._pageName,'{{#urldecode:%7C}}',pathCast.title,'{{#urldecode:%7C}}',pathCast.urlyt,'}}')=Title | |
| − | + | |order by=Date DESC | |
| + | |limit=500 | ||
|where=subspecialty='{{{3}}}' | |where=subspecialty='{{{3}}}' | ||
|format=dynamic table|}}|||3|}} | |format=dynamic table|}}|||3|}} | ||
| + | |||3|}} | ||
Revision as of 16:51, 6 September 2020
Template:subspecialtyPage [1]
{{{1}}}
{{{2}}}
Query: SELECT `cargo__pathCast`.`date` AS `Date`,CONCAT('',`cargo__pathCast`.`presenter1`,', ',`cargo__faculty`.`degree`) AS `Presenter`,CONCAT('{{tablelink|',`cargo__pathCast`.`_pageName`,'|',`cargo__pathCast`.`title`,'|',`cargo__pathCast`.`urlyt`,'}}') AS `Title`,`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 subspecialty='{{{3}}}' ORDER BY `Date` DESC LIMIT 500 Function: CargoSQLQuery::run Error: 1052 Column 'subspecialty' in where clause is ambiguous (localhost)