Cargo query
From pathCast
Showing below up to 23 results in range #101 to #123.
View (previous 100 | next 100) (20 | 50 | 100 | 250 | 500)
{{#cargo_query: tables=pathCast,faculty |fields=CONCAT('[[',faculty._pageName,'|',faculty.namefirstlast,', ',faculty.degree,']]') |where=DATEDIFF(pathCast.date,NOW()) <= -0 AND hide=0 |join on=pathCast.presenter1=faculty.namefirstlast |group by=faculty.namefirstlast |order by=CONCAT('[[',`cargo__faculty`.`_pageName`,'|',`cargo__faculty`.`namefirstlast`,', ',`cargo__faculty`.`degree`,']]') |format=ol |offset=100 |limit=100 }}