Cargo query

Showing below up to 100 results in range #1 to #100.

View (previous 100 | next 100) (20 | 50 | 100 | 250 | 500)

{{#cargo_query:
limit=100
|offset=0
|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
|format=ul
}}

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: