query

RESULTSET

query
	filter	itemCount
1	300BLKC	1
2	357GCMJ	1
3	3584	1
4	40B	1
5	44S1N	2
6	44SA	1
7	45/230	2
8	5201	1
9	65CREEDMOOR1	1
10	82246	1
11	83180	1
12	86271	1
13	90012	1
14	90080	1
15	90104	1
16	90236	1
17	90244	1
18	90275	2
19	90282	1
20	90311	1
21	90324	1
22	90504	1
23	90904	1
24	9132	1
25	91364	1
26	92790	1
27	956	1
28	962	1
29	9A	1
30	BER338LAPUA3	2
31	E357M120	1
32	E38SP120	1
33	E40SW1	1
34	E40SW220	1
35	E45AP020	1
36	E9MMA120	1
37	F25AP	1
38	F32AP	1
39	HVST12	1
40	HVST1235SF	4
41	HVST123SF	3
42	HVST12M	5
43	HVST12MM	1
44	HVST12SM	3
45	HVST20MM	3
46	HVST20SM	2
47	P458WH	2
48	PF1634	2
49	PMC40D	1
50	PMC40SFA	1
51	PMC9A	1
52	PP3001	2
53	PP3002	2
54	PP3003	2
55	PP30061	2
56	PP30062	2
57	PP30063	2
58	PP3006G	2
59	PP30302	2
60	PP303F	2
61	PP303S1	2
62	PP303S2	2
63	PP3081	2
64	PP3082	2
65	PP3083	2
66	PP338F	2
67	PP338H	2
68	PP375F	2
69	PP375S	2
70	PP68F	2
71	PP68H	2
72	RIPOUT 300AA	3
73	RTP9115	1
74	SB45A	1
75	SB9A	1
76	SS12H	3
77	SS12H1	3
78	SS12L	3
79	SS12L1	3
80	SS12XH	2
81	SS12XH1	3
82	SS28	3
83	VOR-TX	1

CACHED

false

EXECUTIONTIME

1

SQL

SELECT vsn as filter, count(distinct style_id ) as itemCount FROM GETPRODUCTS WHERE vsn > '' GROUP BY vsn ORDER BY vsn

Ammunition

Sort by:

Showing 1 - 9 of 4730 items

1 2 3 4

Barnes 21543 VOR-TX Handgun Hunting 357 Remington Magnum XPB 140 GR 20Box/10Case

Barnes 21543 VOR-TX Handgun Hunting 357 Remington Magnum XPB 140 GR 20Box/10Case $25.33

CCI 3584 Blazer 45 Colt (LC) 200 GR Jacketed Hollow Point 50 Bx/ 20 Cs

CCI 3584 Blazer 45 Colt (LC) 200 GR Jacketed Hollow Point 50 Bx/ 20 Cs $55.54

CCI 5201 Blazer 9mm Luger 124 GR Full Metal Jacket Round Nose 50 Bx/ 20 Cs

CCI 5201 Blazer 9mm Luger 124 GR Full Metal Jacket Round Nose 50 Bx/ 20 Cs $13.33

CCI 956 22 Long Rifle Copper-plated Round Nose 40 GR 300Box/10Case

CCI 956 22 Long Rifle Copper-plated Round Nose 40 GR 300Box/10Case $26.73

CCI 962 22 Long Rifle Mini-Mag Copper-plated Hollow Point 36 GR 300Box/10Case

CCI 962 22 Long Rifle Mini-Mag Copper-plated Hollow Point 36 GR 300Box/10Case $27.26

FED 9MM 115GR FMJ RTP ,

FED 9MM 115GR FMJ RTP , $15.99

Fiocchi 300BLKC Shooting Dynamics 300 AAC BO FMJBT 150 GR 50 Bx/10 Cs

Fiocchi 300BLKC Shooting Dynamics 300 AAC BO FMJBT 150 GR 50 Bx/10 Cs $37.65

Fiocchi 357GCMJ Shooting Dynamics 357 Magnum 158 GR Copper Metal Jacket Flat Point 50 Bx/ 20 Cs

Fiocchi 357GCMJ Shooting Dynamics 357 Magnum 158 GR Copper Metal Jacket Flat Point 50 Bx/ 20 Cs $22.40

Fiocchi 44SA500 Shooting Dynamics 44 Special 200 GR Semi-Jacketed Hollow Point 50 Bx/ 10 Cs

Fiocchi 44SA500 Shooting Dynamics 44 Special 200 GR Semi-Jacketed Hollow Point 50 Bx/ 10 Cs $39.20

33825 plymouth road, livonia MI 48150 |ph: (800) 794-1216|hours: M-F 10a to 8p / sat. & sun: 10a to 6p