Template:Items by bits: Difference between revisions

re-include grenades in bit tables
(Update to use new Cargo table)
(re-include grenades in bit tables)
 
Line 2: Line 2:
{{#cargo_query:tables = ArtifactData
{{#cargo_query:tables = ArtifactData
| fields = CONCAT("{{favilink id{{!}}", ObjectID, "}}")=Item, CONCAT("{{Bits{{!}}", Bits, "}}")= Bits
| fields = CONCAT("{{favilink id{{!}}", ObjectID, "}}")=Item, CONCAT("{{Bits{{!}}", Bits, "}}")= Bits
| where = Bits LIKE "%{{{1|0}}}%" AND _pageNamespace="0"
| where = Bits LIKE "%{{{1|0}}}%" AND (_pageNamespace="0" OR UnidentifiedAltNameStripped = 'grenade')
| order by = Bits, _pageName
| order by = Bits, _pageName
| limit = 20
| limit = 20
Line 10: Line 10:
{{#cargo_query:tables = ArtifactData
{{#cargo_query:tables = ArtifactData
| fields = CONCAT("{{favilink id{{!}}", ObjectID, "}}")=Item, CONCAT("{{Bits{{!}}", Bits, "}}")= Bits
| fields = CONCAT("{{favilink id{{!}}", ObjectID, "}}")=Item, CONCAT("{{Bits{{!}}", Bits, "}}")= Bits
| where = Bits LIKE "%{{{1|0}}}%" AND _pageNamespace="0"
| where = Bits LIKE "%{{{1|0}}}%" AND (_pageNamespace="0" OR UnidentifiedAltNameStripped = 'grenade')
| order by = Bits, _pageName
| order by = Bits, _pageName
| offset = 20
| offset = 20