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=CONCAT('[[',subspecialty._pageName,'|',subspecialty.hashtag,' - ', | + | |fields=CONCAT('[[',subspecialty._pageName,'|',subspecialty.hashtag,' - ',subspecialty.name,']]') |
|group by=subspecialty.subspecialty | |group by=subspecialty.subspecialty | ||
|where=DATEDIFF(pathCast.date,NOW()) <= -0 AND hide=0 | |where=DATEDIFF(pathCast.date,NOW()) <= -0 AND hide=0 |