8,290
edits
Psionic: Difference between revisions
Jump to navigation
Jump to search
m
fix duplicate cargo query results
(Tentative fix for duplicate entries in "Possible Items") |
m (fix duplicate cargo query results) |
||
| Line 51: | Line 51: | ||
| fields = CONCAT('{{(}}favilink id{{!}}', M.ObjectID, '{{!}}prefix:&bp&Bs&Ci&co&bn&Bi&Cc{{)}}') = Item, | | fields = CONCAT('{{(}}favilink id{{!}}', M.ObjectID, '{{!}}prefix:&bp&Bs&Ci&co&bn&Bi&Cc{{)}}') = Item, | ||
CASE WHEN COALESCE(GD.Tier,1) < 1 THEN 1 ELSE COALESCE(GD.Tier,1) END = Tier | CASE WHEN COALESCE(GD.Tier,1) < 1 THEN 1 ELSE COALESCE(GD.Tier,1) END = Tier | ||
| where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseAxe' AND DO.DynamicTbl | | where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseAxe' AND DO.DynamicTbl IS NOT NULL | ||
| order by = CASE WHEN COALESCE(GD.Tier,1) < 1 THEN 1 ELSE COALESCE(GD.Tier,1) END DESC,GD.PlainName | | order by = CASE WHEN COALESCE(GD.Tier,1) < 1 THEN 1 ELSE COALESCE(GD.Tier,1) END DESC,GD.PlainName | ||
| group by = M.JoinKey | |||
| format = table | | format = table | ||
}} | }} | ||
| Line 63: | Line 64: | ||
| fields = CONCAT('{{(}}favilink id{{!}}', M.ObjectID, '{{!}}prefix:&bp&Bs&Ci&co&bn&Bi&Cc{{)}}') = Item, | | fields = CONCAT('{{(}}favilink id{{!}}', M.ObjectID, '{{!}}prefix:&bp&Bs&Ci&co&bn&Bi&Cc{{)}}') = Item, | ||
CASE WHEN COALESCE(GD.Tier,1) < 1 THEN 1 ELSE COALESCE(GD.Tier,1) END = Tier | CASE WHEN COALESCE(GD.Tier,1) < 1 THEN 1 ELSE COALESCE(GD.Tier,1) END = Tier | ||
| where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseCudgel' AND DO.DynamicTbl | | where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseCudgel' AND DO.DynamicTbl IS NOT NULL | ||
| order by = CASE WHEN COALESCE(GD.Tier,1) < 1 THEN 1 ELSE COALESCE(GD.Tier,1) END DESC,GD.PlainName | | order by = CASE WHEN COALESCE(GD.Tier,1) < 1 THEN 1 ELSE COALESCE(GD.Tier,1) END DESC,GD.PlainName | ||
| group by = M.JoinKey | |||
| format = table | | format = table | ||
}} | }} | ||
| Line 75: | Line 77: | ||
| fields = CONCAT('{{(}}favilink id{{!}}', M.ObjectID, '{{!}}prefix:&bp&Bs&Ci&co&bn&Bi&Cc{{)}}') = Item, | | fields = CONCAT('{{(}}favilink id{{!}}', M.ObjectID, '{{!}}prefix:&bp&Bs&Ci&co&bn&Bi&Cc{{)}}') = Item, | ||
CASE WHEN COALESCE(GD.Tier,1) < 1 THEN 1 ELSE COALESCE(GD.Tier,1) END = Tier | CASE WHEN COALESCE(GD.Tier,1) < 1 THEN 1 ELSE COALESCE(GD.Tier,1) END = Tier | ||
| where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseLongBlade' AND DO.DynamicTbl | | where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseLongBlade' AND DO.DynamicTbl IS NOT NULL | ||
| order by = CASE WHEN COALESCE(GD.Tier,1) < 1 THEN 1 ELSE COALESCE(GD.Tier,1) END DESC,GD.PlainName | | order by = CASE WHEN COALESCE(GD.Tier,1) < 1 THEN 1 ELSE COALESCE(GD.Tier,1) END DESC,GD.PlainName | ||
| group by = M.JoinKey | |||
| format = table | | format = table | ||
}} | }} | ||
| Line 87: | Line 90: | ||
| fields = CONCAT('{{(}}favilink id{{!}}', M.ObjectID, '{{!}}prefix:&bp&Bs&Ci&co&bn&Bi&Cc{{)}}') = Item, | | fields = CONCAT('{{(}}favilink id{{!}}', M.ObjectID, '{{!}}prefix:&bp&Bs&Ci&co&bn&Bi&Cc{{)}}') = Item, | ||
CASE WHEN COALESCE(GD.Tier,1) < 1 THEN 1 ELSE COALESCE(GD.Tier,1) END = Tier | CASE WHEN COALESCE(GD.Tier,1) < 1 THEN 1 ELSE COALESCE(GD.Tier,1) END = Tier | ||
| where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseDagger' AND DO.DynamicTbl | | where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseDagger' AND DO.DynamicTbl IS NOT NULL | ||
| order by = CASE WHEN COALESCE(GD.Tier,1) < 1 THEN 1 ELSE COALESCE(GD.Tier,1) END DESC,GD.PlainName | | order by = CASE WHEN COALESCE(GD.Tier,1) < 1 THEN 1 ELSE COALESCE(GD.Tier,1) END DESC,GD.PlainName | ||
| group by = M.JoinKey | |||
| format = table | | format = table | ||
}} | }} | ||