8,290
edits
mNo edit summary |
(tweak query to include black mote) |
||
Line 14: | Line 14: | ||
| join on = IT.ObjectID=GD.ObjectID | | join on = IT.ObjectID=GD.ObjectID | ||
| fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page | | fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page | ||
| where = COALESCE(GD.Tier,1)=1 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0 | | where = COALESCE(GD.Tier,1)=1 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0' AND Skill <> 'Shield' | ||
| format = list | | format = list | ||
| order by = GD.PlainName | | order by = GD.PlainName | ||
Line 28: | Line 28: | ||
| join on = IT.ObjectID=GD.ObjectID | | join on = IT.ObjectID=GD.ObjectID | ||
| fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page | | fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page | ||
| where = COALESCE(GD.Tier,1)=2 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0 | | where = COALESCE(GD.Tier,1)=2 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0' AND Skill <> 'Shield' | ||
| format = list | | format = list | ||
| order by = GD.PlainName | | order by = GD.PlainName | ||
Line 42: | Line 42: | ||
| join on = IT.ObjectID=GD.ObjectID | | join on = IT.ObjectID=GD.ObjectID | ||
| fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page | | fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page | ||
| where = COALESCE(GD.Tier,1)=3 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0 | | where = COALESCE(GD.Tier,1)=3 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0' AND Skill <> 'Shield' | ||
| format = list | | format = list | ||
| order by = GD.PlainName | | order by = GD.PlainName | ||
Line 56: | Line 56: | ||
| join on = IT.ObjectID=GD.ObjectID | | join on = IT.ObjectID=GD.ObjectID | ||
| fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page | | fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page | ||
| where = COALESCE(GD.Tier,1)=4 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0 | | where = COALESCE(GD.Tier,1)=4 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0' AND Skill <> 'Shield' | ||
| format = list | | format = list | ||
| order by = GD.PlainName | | order by = GD.PlainName | ||
Line 70: | Line 70: | ||
| join on = IT.ObjectID=GD.ObjectID | | join on = IT.ObjectID=GD.ObjectID | ||
| fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page | | fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page | ||
| where = COALESCE(GD.Tier,1)=5 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0 | | where = COALESCE(GD.Tier,1)=5 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0' AND Skill <> 'Shield' | ||
| format = list | | format = list | ||
| order by = GD.PlainName | | order by = GD.PlainName | ||
Line 84: | Line 84: | ||
| join on = IT.ObjectID=GD.ObjectID | | join on = IT.ObjectID=GD.ObjectID | ||
| fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page | | fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page | ||
| where = COALESCE(GD.Tier,1)=6 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0 | | where = COALESCE(GD.Tier,1)=6 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0' AND Skill <> 'Shield' | ||
| format = list | | format = list | ||
| order by = GD.PlainName | | order by = GD.PlainName | ||
Line 98: | Line 98: | ||
| join on = IT.ObjectID=GD.ObjectID | | join on = IT.ObjectID=GD.ObjectID | ||
| fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page | | fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page | ||
| where = COALESCE(GD.Tier,1)=7 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0 | | where = COALESCE(GD.Tier,1)=7 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0' AND Skill <> 'Shield' | ||
| format = list | | format = list | ||
| order by = GD.PlainName | | order by = GD.PlainName | ||
Line 112: | Line 112: | ||
| join on = IT.ObjectID=GD.ObjectID | | join on = IT.ObjectID=GD.ObjectID | ||
| fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page | | fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page | ||
| where = COALESCE(GD.Tier,1)>=8 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0 | | where = COALESCE(GD.Tier,1)>=8 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0' AND Skill <> 'Shield' | ||
| format = list | | format = list | ||
| order by = GD.PlainName | | order by = GD.PlainName |