Low cost armour analysis: Difference between revisions
From Zed Wiki
| Line 23: | Line 23: | ||
| join on=ScavengeJobItems.Codename=Items.Codename | | join on=ScavengeJobItems.Codename=Items.Codename | ||
| fields=CONCAT('https://www.zed.city/items/', ScavengeJobItems.Codename, '.png')=Image, Items._pageName=Item, Qty=Quantity | | fields=CONCAT('https://www.zed.city/items/', ScavengeJobItems.Codename, '.png')=Image, Items._pageName=Item, Qty=Quantity | ||
| where=JobCodename='job_expert_armour_1' | | where=JobCodename='job_expert_armour_1' and Items.codename is not null | ||
| format=table | | format=table | ||
| order by=ScavengeJobItems.Codename | | order by=ScavengeJobItems.Codename | ||