Bullets --- SELECT cal, qty, gr, type, diameter, imageID FROM inventory order by diameter
Caliber: 22
grains: 45
Type: Hornet
Dia: .223
QTY: 100		 Caliber: 30
grains: 175
Type: HPBT
Dia: .308
QTY: 90		 Caliber: 30
grains: 168
Type: HPBT
Dia: .308
QTY: 840		 Caliber: 30
grains: 178
Type: HPBT
Dia: .308
QTY: 90
Caliber: 30
grains: 168
Type: HPBT
Dia: .308
QTY: 140		 Caliber: 30
grains: 150
Type: HPBT
Dia: .308
QTY: 90		 Caliber: 30
grains: 150
Type: FP
Dia: .308
QTY: 20		 Caliber: 30
grains: 150
Type: BT-Spitzer
Dia: .308
QTY: 190
Caliber: 32
grains: 80
Type: RN
Dia: .313
QTY: 400		 Caliber: 32
grains: 118
Type: FP
Dia: .313
QTY: 175		 Caliber: 36
grains: 65
Type: RoundBall
Dia: .350
QTY: 352		 Caliber: 9
grains: 124
Type: RN
Dia: .355
QTY: 7,200
Caliber: 38
grains: 158
Type: FP/XTP
Dia: .357
QTY: 220		 Caliber: 38
grains: 158
Type: SWC
Dia: .357
QTY: 1,000		 Caliber: 38
grains: 148
Type: DEW
Dia: .358
QTY: 30		 Caliber: 38
grains: 125
Type: FP
Dia: .358
QTY: 1,600
Caliber: 38
grains: 148
Type: HBasedW
Dia: .358
QTY: 175		 Caliber: 36
grains: 75
Type: ROUNDBALL
Dia: .375
QTY: 500		 Caliber: 44
grains: 138
Type: RoundBall
Dia: .451
QTY: 21		 Caliber: 45
grains: 200
Type: RNFP
Dia: .452
QTY: 3,500
Caliber: 45
grains: 250
Type: LRN
Dia: .452
QTY: 200		 Caliber: 45
grains: 200
Type: RNFP
Dia: .452
QTY: 3,000		 Caliber: 45
grains: 255
Type: RNFP
Dia: .452
QTY: 30		 Caliber: 45
grains: 250
Type: RNFP
Dia: .452
QTY: 500
Caliber: 45
grains: 140
Type: RoundBall
Dia: .454
QTY: 80		 Caliber: 45
grains: 255
Type: FP
Dia: .454
QTY: 100		 Caliber: 45
grains: 215
Type: conical
Dia: .456
QTY: 18		 Caliber: 45
grains: 143
Type: RoundBall
Dia: .457
QTY: 530
Caliber: 50
grains: 177
Type: RoundBall
Dia: .490
QTY: 270		 Caliber: 50
grains: 182
Type: RoundBall
Dia: .495
QTY: 95		 Caliber: 50
grains: 370
Type: MaxiBall
Dia: .500
QTY: 28
Powders --- SELECT name, brand, qty, imageID FROM powders
Brand: HODGON
trailboss
QTY: 11.5lbs.		 Brand: HODGON
hp38
QTY: 8.5lbs.		 Brand: IMR
4064
QTY: 2.5lbs.		 Brand: HODGDON
Triple Seven
QTY: 1.6lbs.
Brand: Winchester
Win231
QTY: 8.0lbs.		 Brand: Goex
FFFg
QTY: 4.0lbs.		 Brand: Goex
FFg
QTY: 3.0lbs.		 Brand: Goex
FFFFg
QTY: 1.0lbs.
Primers --- SELECT name, brand, qty, imageID FROM primers
Brand: Winchester
Large Rifle
QTY: 2,600		 Brand: Winchester
Large Pistol
QTY: 17,300		 Brand: Winchester
Small Pistol Magnum
QTY: 4,000		 Brand: Remington
No. 11 Percussion
QTY: 1,650
Brand: Winchester
Small Pistol
QTY: 15,600