Cargo query

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
}}

Table(s):
Field(s):
Where:	DATEDIFF(pathCast.date,NOW()) <= -0 AND hide=0
Join on:	pathCast.presenter1=faculty.namefirstlast
Group by:
Having:
Order by:
Limit:
Offset:
Format: