Template:TeamPastPerformances: Difference between revisions
Content added Content deleted
(should work) |
(default to PAGENAME) |
||
Line 3: | Line 3: | ||
|join on=lb.hunt=hd.hunt |
|join on=lb.hunt=hd.hunt |
||
|fields=hd.start_date=Date,lb.hunt=Hunt,IF(lb.rank < 0, 'Host', lb.rank)=Rank,CONCAT(IF(lb.alias IS NULL, '', CONCAT('as ', lb.team)), ' ', IF(lb.comment IS NULL, '', lb.comment))=Notes |
|fields=hd.start_date=Date,lb.hunt=Hunt,IF(lb.rank < 0, 'Host', lb.rank)=Rank,CONCAT(IF(lb.alias IS NULL, '', CONCAT('as ', lb.team)), ' ', IF(lb.comment IS NULL, '', lb.comment))=Notes |
||
|where=(lb.team='{{{team}}}' OR lb.alias='{{{team}}}') AND lb.rank <= {{{max_rank|30}}} |
|where=(lb.team='{{{team|{{PAGENAME}}}}}' OR lb.alias='{{{team|{{PAGENAME}}}}}') AND lb.rank <= {{{max_rank|30}}} |
||
|order by=hd.start_date DESC |
|order by=hd.start_date DESC |
||
|format=table |
|format=table |
Revision as of 19:40, 19 September 2022
No results