Difference between revisions of "pathCast"
From pathCast
Line 37: | Line 37: | ||
tables=pathCast,subspecialty | tables=pathCast,subspecialty | ||
|join on=pathCast.subspecialty=subspecialty.subspecialty | |join on=pathCast.subspecialty=subspecialty.subspecialty | ||
− | |fields=subspecialty.subspecialty | + | |fields=CONCAT('[[',subspecialty._pageName,'|',subspecialty.hashtag,']]') |
|group by=subspecialty.subspecialty | |group by=subspecialty.subspecialty | ||
+ | |where=DATEDIFF(pathCast.date,NOW()) <= -0 AND hide=0 | ||
|format=ul | |format=ul | ||
|}} | |}} |