pathCast
Log in

Difference between revisions of "pathCast-subspecialty"

From pathCast
 
(One intermediate revision by the same user not shown)
Line 5: Line 5:
 
tables=pathCast,subspecialty
 
tables=pathCast,subspecialty
 
|join on=pathCast.subspecialty=subspecialty.subspecialty
 
|join on=pathCast.subspecialty=subspecialty.subspecialty
|fields=CONCAT('[[',subspecialty._pageName,'|',subspecialty.hashtag,' - ',subspecialty.name,']]')
+
|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

Latest revision as of 13:46, 7 September 2020