Cargo query

Showing below up to 50 results in range #11 to #60.

View (previous 50 | next 50) (20 | 50 | 100 | 250 | 500)

Item	Reputation Cost	Categories
antimatter cell	31	Energy Cells
ape fur cloak	25	Cloaks
ape fur gloves	23	Gloves
ape fur hat	23	Hats
arc cannon	75	Heavy Weapons
arc winder	187	Pistols
Ari	23	Axes
arsplice seed	87	Food
ash-stained robes	5	Armor
baboon corpse	5	Corpses
banner of the Holy Rhombus	5	Banners
bark armor	5	Armor
barkbiter corpse	5	Corpses
bat corpse	5	Corpses
beaded bracelet	20	Trade Goods
bear corpse	5	Corpses
beetle corpse	5	Corpses
bent metal sheet	5	Scrap
bent surgical stent	5	Scrap
Bethesda Susa recoiler	13	Recoilers
bio-scanning bracelet	6	Bracelets
biodynamic cell	25	Liquid Fueled Energy Cells
bizarre carnage	25	Corpses
black mote	416	Floating Nearby
black puma haunch	62	Corpses
black robes	5	Armor
blast cannon	500	Heavy Weapons
blaze injector	10	Tonics
bloated leech corpse	5	Corpses
bloated pearlfrog corpse	12	Corpses
blood-gradient hand vacuum	166	Pistols
bloody patch of fur	5	Quest Items
blunt scalpel	5	Scrap
boar corpse	5	Corpses
boar-skin gloves	5	Gloves
bone worm corpse	5	Corpses
booster gun	37	Pistols
bounding boots	25	Footwear
box of crayons	5	Trade Goods
breathbeard corpse	5
dreambeard corpse	5
elder dreambeard corpse	5
elder flamebeard corpse	5
elder gallbeard corpse	5
elder mazebeard corpse	5
elder nullbeard corpse	5
elder sleetbeard corpse	5
elder stillbeard corpse	5
elder tartbeard corpse	5
flamebeard corpse	5

View (previous 50 | next 50) (20 | 50 | 100 | 250 | 500)

Modify query

View wikitext

{{#cargo_query:
limit=50
|offset=10
|tables=GeneralData=GD
|fields=CONCAT('[[',_pageName,'|',PlainName,']]')=Item,
CONCAT(CASE
WHEN FLOOR(Commerce/4)<5
THEN 5
ELSE FLOOR(Commerce/4)
END)=Reputation Cost,Categories
|where=Commerce >0 AND Tier >=0
|order by=CONCAT('[[',_pageName,'|',PlainName,']]') , CONCAT(CASE
WHEN FLOOR(Commerce/4)<5
THEN 5
ELSE FLOOR(Commerce/4)
END) , `Categories` 
|format=auto
}}

Table(s):
Field(s):
Where:	Commerce >0 AND Tier >=0
Join on:
Group by:
Having:
Order by:


Limit:
Offset:
Format: