pathCast
Log in

Difference between revisions of "pathCast-subspecialty"

From pathCast
 
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
|format=ol
+
|format=ul
 
|}}|||4|}}
 
|}}|||4|}}
 
{{IfGroup|sysop|
 
{{IfGroup|sysop|

Latest revision as of 13:46, 7 September 2020