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

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

CCI 5200 Blazer 9mm Luger 115 GR Full Metal Jacket Round Nose 50 Bx/ 20 Cs $14.69

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 $14.95

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 $27.27

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 $44.46

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 $27.20

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