Template:TeamPastPerformances: Difference between revisions

Content added Content deleted
m (add doc)
(Add no_rank parameter)
Line 2: Line 2:
tables=Leaderboard=lb,HuntData=hd
tables=Leaderboard=lb,HuntData=hd
|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:{{{no_rank|}}}||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|{{PAGENAME}}}}}' OR lb.alias='{{{team|{{PAGENAME}}}}}') 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

Revision as of 01:44, 21 September 2022

No results