8,290
edits
No edit summary |
(Add Commerce value) |
||
Line 14: | Line 14: | ||
CONCAT('{{((}}favilink page{{!}}',WAD._pageName,'{{)}}')=Identified Object, | CONCAT('{{((}}favilink page{{!}}',WAD._pageName,'{{)}}')=Identified Object, | ||
GD.Tier, | GD.Tier, | ||
IT.Complexity | IT.Complexity, | ||
GD.Commerce=Trade Value | |||
|where=WAD.UnknownImage IS NOT NULL AND (WAD.UnknownNameStripped = 'strange tubes' OR WAD.UnknownAltNameStripped = 'strange tubes') | |where=WAD.UnknownImage IS NOT NULL AND (WAD.UnknownNameStripped = 'strange tubes' OR WAD.UnknownAltNameStripped = 'strange tubes') | ||
|order by=Colors ASC, Identified Object ASC | |order by=Colors ASC, Identified Object ASC | ||
Line 31: | Line 32: | ||
CONCAT('{{((}}favilink page{{!}}',WAD._pageName,'{{)}}')=Identified Object, | CONCAT('{{((}}favilink page{{!}}',WAD._pageName,'{{)}}')=Identified Object, | ||
COALESCE(GD.Tier,'-')=Tier, | COALESCE(GD.Tier,'-')=Tier, | ||
IT.Complexity | IT.Complexity, | ||
GD.Commerce=Trade Value | |||
|where=WAD.UnknownImage IS NOT NULL AND (WAD.UnknownNameStripped = 'strange plant' OR WAD.UnknownAltNameStripped = 'strange plant') | |where=WAD.UnknownImage IS NOT NULL AND (WAD.UnknownNameStripped = 'strange plant' OR WAD.UnknownAltNameStripped = 'strange plant') | ||
|order by=Colors ASC, Identified Object ASC | |order by=Colors ASC, Identified Object ASC | ||
Line 48: | Line 50: | ||
CONCAT('{{((}}favilink page{{!}}',WAD._pageName,'{{)}}')=Identified Object, | CONCAT('{{((}}favilink page{{!}}',WAD._pageName,'{{)}}')=Identified Object, | ||
COALESCE(GD.Tier,'-')=Tier, | COALESCE(GD.Tier,'-')=Tier, | ||
IT.Complexity | IT.Complexity, | ||
GD.Commerce=Trade Value | |||
|where=WAD.UnknownImage IS NOT NULL AND (WAD.UnknownNameStripped = 'small box' OR WAD.UnknownNameStripped = 'small metal box') | |where=WAD.UnknownImage IS NOT NULL AND (WAD.UnknownNameStripped = 'small box' OR WAD.UnknownNameStripped = 'small metal box') | ||
|order by=Colors ASC, Identified Object ASC | |order by=Colors ASC, Identified Object ASC | ||
Line 65: | Line 68: | ||
CONCAT('{{((}}favilink page{{!}}',WAD._pageName,'{{)}}')=Identified Object, | CONCAT('{{((}}favilink page{{!}}',WAD._pageName,'{{)}}')=Identified Object, | ||
COALESCE(GD.Tier,'-')=Tier, | COALESCE(GD.Tier,'-')=Tier, | ||
IT.Complexity | IT.Complexity, | ||
GD.Commerce=Trade Value | |||
|where=WAD.UnknownImage IS NOT NULL AND WAD.UnknownNameStripped = 'small trinket' | |where=WAD.UnknownImage IS NOT NULL AND WAD.UnknownNameStripped = 'small trinket' | ||
|order by=Colors ASC, Identified Object ASC | |order by=Colors ASC, Identified Object ASC | ||
Line 82: | Line 86: | ||
CONCAT('{{((}}favilink page{{!}}',WAD._pageName,'{{)}}')=Identified Object, | CONCAT('{{((}}favilink page{{!}}',WAD._pageName,'{{)}}')=Identified Object, | ||
COALESCE(GD.Tier,'-')=Tier, | COALESCE(GD.Tier,'-')=Tier, | ||
IT.Complexity | IT.Complexity, | ||
GD.Commerce=Trade Value | |||
|where=WAD.UnknownImage IS NOT NULL AND WAD.UnknownNameStripped = 'small stone' | |where=WAD.UnknownImage IS NOT NULL AND WAD.UnknownNameStripped = 'small stone' | ||
|order by=Colors ASC, Identified Object ASC | |order by=Colors ASC, Identified Object ASC | ||
Line 103: | Line 108: | ||
CONCAT('{{((}}favilink page{{!}}',WAD._pageName,'{{)}}')=Identified Object, | CONCAT('{{((}}favilink page{{!}}',WAD._pageName,'{{)}}')=Identified Object, | ||
COALESCE(GD.Tier,'-')=Tier, | COALESCE(GD.Tier,'-')=Tier, | ||
IT.Complexity | IT.Complexity, | ||
GD.Commerce=Trade Value | |||
|where=WAD.UnknownImage IS NOT NULL AND WAD.UnknownNameStripped <> 'strange tubes' AND WAD.UnknownAltNameStripped <> 'strange tubes' AND WAD.UnknownNameStripped <> 'strange plant' AND WAD.UnknownAltNameStripped <> 'strange plant' AND WAD.UnknownNameStripped <> 'small trinket' AND WAD.UnknownNameStripped <> 'small stone' AND WAD.UnknownNameStripped <> 'small box' AND WAD.UnknownNameStripped <> 'small metal box' | |where=WAD.UnknownImage IS NOT NULL AND WAD.UnknownNameStripped <> 'strange tubes' AND WAD.UnknownAltNameStripped <> 'strange tubes' AND WAD.UnknownNameStripped <> 'strange plant' AND WAD.UnknownAltNameStripped <> 'strange plant' AND WAD.UnknownNameStripped <> 'small trinket' AND WAD.UnknownNameStripped <> 'small stone' AND WAD.UnknownNameStripped <> 'small box' AND WAD.UnknownNameStripped <> 'small metal box' | ||
|order by=Colors ASC, Identified Object ASC | |order by=Colors ASC, Identified Object ASC |