Fitted with filters: Difference between revisions

Jump to navigation Jump to search
m
no edit summary
(Add eligible items list)
mNo edit summary
Line 39: Line 39:
   | join on = M.JoinKey=GD.JoinKey,M.JoinKey=EI.JoinKey
   | join on = M.JoinKey=GD.JoinKey,M.JoinKey=EI.JoinKey
   | fields = CONCAT('{{(}}favilink id{{!}}',M.ObjectID,'{{)}}')=Item,
   | fields = CONCAT('{{(}}favilink id{{!}}',M.ObjectID,'{{)}}')=Item,
            COALESCE(GD.Tier,1)=Tier,
             CONCAT(CEIL(COALESCE(GD.Tier,1) + 2) * 5,'%')=Effective<br>Density Reduction,
             CONCAT(CEIL(COALESCE(GD.Tier,1) + 2) * 5,'%')=Effective<br>Density Reduction,
             CONCAT('+',CEIL(COALESCE(GD.Tier,1) + 2))=Save Bonus,
             CONCAT('+',CEIL(COALESCE(GD.Tier,1) + 2))=Save Bonus,

Navigation menu