Cargo query

Showing below up to 3 results in range #121 to #123.

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

{{#cargo_query:
limit=20
|offset=120
|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=ol
}}

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: