Arch dervish of the Sightless Way: Difference between revisions

adjust previous fix (to match queries on dervish page rather than psionic page)
(fix duplicate cargo query results)
(adjust previous fix (to match queries on dervish page rather than psionic page))
Line 105: Line 105:
   | where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseAxe' AND DO.DynamicTbl IS NOT NULL AND GD.Tier = 8
   | where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseAxe' AND DO.DynamicTbl IS NOT NULL AND GD.Tier = 8
   | order by = GD.PlainName
   | order by = GD.PlainName
   | group by = M.JoinKey
   | group by = GD.ObjectID
   | format = table
   | format = table
}}
}}
Line 119: Line 119:
   | where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseCudgel' AND DO.DynamicTbl IS NOT NULL AND GD.Tier = 8
   | where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseCudgel' AND DO.DynamicTbl IS NOT NULL AND GD.Tier = 8
   | order by = GD.PlainName
   | order by = GD.PlainName
   | group by = M.JoinKey
   | group by = GD.ObjectID
   | format = table
   | format = table
}}
}}
Line 133: Line 133:
   | where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseLongBlade' AND DO.DynamicTbl IS NOT NULL AND GD.Tier = 8
   | where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseLongBlade' AND DO.DynamicTbl IS NOT NULL AND GD.Tier = 8
   | order by = GD.PlainName
   | order by = GD.PlainName
   | group by = M.JoinKey
   | group by = GD.ObjectID
   | format = table
   | format = table
}}
}}
Line 147: Line 147:
   | where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseDagger' AND DO.DynamicTbl IS NOT NULL AND GD.Tier = 8
   | where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseDagger' AND DO.DynamicTbl IS NOT NULL AND GD.Tier = 8
   | order by = GD.PlainName
   | order by = GD.PlainName
   | group by = M.JoinKey
   | group by = GD.ObjectID
   | format = table
   | format = table
}}
}}
312

edits