8,290
edits
(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, |