8,290
edits
Refraction: Difference between revisions
add Iopinax's refract stats
mNo edit summary Tag: Manual revert |
(add Iopinax's refract stats) |
||
| Line 13: | Line 13: | ||
WHEN EI.ObjectID = 'Quartziferous Mirror' THEN '100%' | WHEN EI.ObjectID = 'Quartziferous Mirror' THEN '100%' | ||
WHEN EI.ObjectID = 'Mirror Bug' THEN '100%' | WHEN EI.ObjectID = 'Mirror Bug' THEN '100%' | ||
WHEN EI.ObjectID = 'Iopinax' THEN '100%' | |||
END)=Chance to Refract, | END)=Chance to Refract, | ||
CONCAT(CASE | CONCAT(CASE | ||
| Line 18: | Line 19: | ||
WHEN EI.ObjectID = 'Quartziferous Mirror' THEN 'random' | WHEN EI.ObjectID = 'Quartziferous Mirror' THEN 'random' | ||
WHEN EI.ObjectID = 'Mirror Bug' THEN 'random' | WHEN EI.ObjectID = 'Mirror Bug' THEN 'random' | ||
WHEN EI.ObjectID = 'Iopinax' THEN 'random' | |||
END)=Refract Angle | END)=Refract Angle | ||
| where = EI.Info IS NOT NULL AND EI.Info LIKE '%Refractive,,,%' AND C.Demeanor IS NOT NULL | | where = EI.Info IS NOT NULL AND EI.Info LIKE '%Refractive,,,%' AND C.Demeanor IS NOT NULL | ||