Jay's Sporting Goods

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	FAMLIST	HASIMAGE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SOLD	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	UPC	URL	VENDOR_INTEGRATE_ID
1	[empty string]	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	[empty string]	0	89.99	0	89.99	[empty string]	89.99	[empty string]	ENDURA LIGHTWEIGHT PLAIN EDGE FOLDING KNIFE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	Endura Lightweight Plain Edge Folding Knife	[empty string]	[empty string]	N	89.99	89.99	[empty string]	[empty string]	[empty string]	1000	C10PBK	342584	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/endura-lightweight-plain-edge-folding-knife-342584	1
2	[empty string]	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	[empty string]	0	109.99	0	109.99	[empty string]	109.99	[empty string]	ENDURA STAINLESS COMBO EDGE FOLDING KNIFE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Endura Stainless Combo Edge Folding Knife	[empty string]	[empty string]	N	109.99	109.99	[empty string]	[empty string]	[empty string]	1000	C10PS	342585	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/endura-stainless-combo-edge-folding-knife-342585	1
3	[empty string]	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	[empty string]	0	99.99	0	99.99	[empty string]	99.99	[empty string]	ENDURA LIGHTWEIGHT COMBO EDGE BLACK BLADE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	50-to-100	0.00	[empty string]	Endura Lightweight Combo Edge Black Blade	[empty string]	[empty string]	N	99.99	99.99	[empty string]	[empty string]	[empty string]	1000	C10PSBBK	342587	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/endura-lightweight-combo-edge-black-blade-342587	1
4	[empty string]	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	[empty string]	0	109.99	0	109.99	[empty string]	109.99	[empty string]	ENDURA STAINLESS SPYDER EDGE FOLDING KNIFE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Endura Stainless Spyder Edge Folding Knife	[empty string]	[empty string]	N	109.99	109.99	[empty string]	[empty string]	[empty string]	1000	C10S	342591	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/endura-stainless-spyder-edge-folding-knife-342591	1
5	[empty string]	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	[empty string]	0	89.99	0	89.99	[empty string]	89.99	[empty string]	ENDURA LIGHTWEIGHT SPYDER EDGE BLACK BLADE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	Endura Lightweight Spyder Edge Black Blade	[empty string]	[empty string]	N	89.99	89.99	[empty string]	[empty string]	[empty string]	1000	C10SBK	342592	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/endura-lightweight-spyder-edge-black-blade-342592	1
6	[empty string]	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	[empty string]	0	109.99	0	109.99	[empty string]	109.99	[empty string]	ENDURA STAINLESS PLAIN EDGE FOLDING KNIFE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	100-to-150	0.00	[empty string]	Endura Stainless Plain Edge Folding Knife	[empty string]	[empty string]	N	109.99	109.99	[empty string]	[empty string]	[empty string]	1000	C10P	342593	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/endura-stainless-plain-edge-folding-knife-342593	1
7	[empty string]	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	[empty string]	0	99.99	0	99.99	[empty string]	99.99	[empty string]	DELICA LIGHTWEIGHT COMBO EDGE BLACK BLADE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	50-to-100	0.00	[empty string]	Delica Lightweight Combo Edge Black Blade	[empty string]	[empty string]	N	99.99	99.99	[empty string]	[empty string]	[empty string]	1000	C11PSBBK	342594	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/delica-lightweight-combo-edge-black-blade-342594	1
8	[empty string]	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	[empty string]	0	89.99	0	89.99	[empty string]	89.99	[empty string]	ENDURA LIGHTWEIGHT ORANGE PLAIN EDGE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	50-to-100	0.00	[empty string]	Endura Lightweight Orange Plain Edge	[empty string]	[empty string]	N	89.99	89.99	[empty string]	[empty string]	[empty string]	1000	C10FPOR	342596	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/endura-lightweight-orange-plain-edge-342596	1
9	[empty string]	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	[empty string]	0	139.99	0	139.99	[empty string]	139.99	[empty string]	ENDURA LIGHTWEIGHT BRITISH RACING GREEN ZDP-189	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	100-to-150	0.00	[empty string]	Endura Lightweight British Racing Green Zdp-189	[empty string]	[empty string]	N	139.99	139.99	[empty string]	[empty string]	[empty string]	1000	C10PGRE	342597	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/endura-lightweight-british-racing-green-zdp-189-342597	1
10	[empty string]	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	[empty string]	0	89.99	0	89.99	[empty string]	89.99	[empty string]	DELICA LIGHTWEIGHT ORANGE PLAINE EDGE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	Delica Lightweight Orange Plaine Edge	[empty string]	[empty string]	N	89.99	89.99	[empty string]	[empty string]	[empty string]	1000	C11FPOR	342598	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/delica-lightweight-orange-plaine-edge-342598	1
11	[empty string]	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	[empty string]	0	109.99	0	109.99	[empty string]	109.99	[empty string]	DELICA STAINLESS PLAINE EDGE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	100-to-150	0.00	[empty string]	Delica Stainless Plaine Edge	[empty string]	[empty string]	N	109.99	109.99	[empty string]	[empty string]	[empty string]	1000	C11P	342599	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/delica-stainless-plaine-edge-342599	1
12	[empty string]	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	[empty string]	0	89.99	0	89.99	[empty string]	89.99	[empty string]	DELICA LIGHTWEIGHT PLAIN EDGE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Delica Lightweight Plain Edge	[empty string]	[empty string]	N	89.99	89.99	[empty string]	[empty string]	[empty string]	1000	C11PBK	342600	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/delica-lightweight-plain-edge-342600	1
13	[empty string]	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	[empty string]	0	109.99	0	109.99	[empty string]	109.99	[empty string]	DELICA STAINLESS SPYDER EDGE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Delica Stainless Spyder Edge	[empty string]	[empty string]	N	109.99	109.99	[empty string]	[empty string]	[empty string]	1000	C11S	342602	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/delica-stainless-spyder-edge-342602	1
14	[empty string]	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	[empty string]	0	149.99	0	149.99	[empty string]	149.99	[empty string]	IKUCHI CARBON FIBER CPM S30V PLAIN EDGE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	100-to-150	0.00	[empty string]	Ikuchi Carbon Fiber Cpm S30v Plain Edge	[empty string]	[empty string]	N	149.99	149.99	[empty string]	[empty string]	[empty string]	1000	C242CFP	342604	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/ikuchi-carbon-fiber-cpm-s30v-plain-edge-342604	1
15	[empty string]	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	[empty string]	0	219.99	0	219.99	[empty string]	219.99	[empty string]	KAPARA CARBON FIBER CPM S30V PLAIN EDGE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	200-to-250	0.00	[empty string]	Kapara Carbon Fiber Cpm S30v Plain Edge	[empty string]	[empty string]	N	219.99	219.99	[empty string]	[empty string]	[empty string]	1000	C241CFP	342605	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/kapara-carbon-fiber-cpm-s30v-plain-edge-342605	1
16	[empty string]	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	[empty string]	0	129.99	0	129.99	[empty string]	129.99	[empty string]	MANIX 2 G-10 PLAIN EDGE SPM S30V	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Manix 2 G-10 Plain Edge Spm S30v	[empty string]	[empty string]	N	129.99	129.99	[empty string]	[empty string]	[empty string]	1000	C101GP2	342606	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/manix-2-g-10-plain-edge-spm-s30v-342606	1
17	[empty string]	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	[empty string]	0	159.99	0	159.99	[empty string]	159.99	[empty string]	MANIX 2 G-10 PLAIN EDGE BLACK BLADE CPM S30V	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	5	150-to-200	0.00	[empty string]	Manix 2 G-10 Plain Edge Black Blade Cpm S30v	[empty string]	[empty string]	N	159.99	159.99	[empty string]	[empty string]	[empty string]	1000	C101GPBBK2	342607	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/manix-2-g-10-plain-edge-black-blade-cpm-s30v-342607	1
18	[empty string]	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	[empty string]	0	129.99	0	129.99	[empty string]	129.99	[empty string]	MANIX 2 G-10 COMBO EDGE SPM S30V	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	100-to-150	0.00	[empty string]	Manix 2 G-10 Combo Edge Spm S30v	[empty string]	[empty string]	N	129.99	129.99	[empty string]	[empty string]	[empty string]	1000	C101GPS2	342608	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/manix-2-g-10-combo-edge-spm-s30v-342608	1
19	[empty string]	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	[empty string]	0	219.99	0	219.99	[empty string]	219.99	[empty string]	MILITARY G-10 PLAIN EDGE BLACK BLADE CPM S30V	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	200-to-250	0.00	[empty string]	Military G-10 Plain Edge Black Blade Cpm S30v	[empty string]	[empty string]	N	219.99	219.99	[empty string]	[empty string]	[empty string]	1000	C36GPBK	342609	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/military-g-10-plain-edge-black-blade-cpm-s30v-342609	1
20	[empty string]	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	[empty string]	0	199.99	0	199.99	[empty string]	199.99	[empty string]	MILITARY G-10 PLAIN EDGE CPM S30V	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	150-to-200	0.00	[empty string]	Military G-10 Plain Edge Cpm S30v	[empty string]	[empty string]	N	199.99	199.99	[empty string]	[empty string]	[empty string]	1000	C36GPE	342610	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/military-g-10-plain-edge-cpm-s30v-342610	1
21	[empty string]	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	[empty string]	0	109.99	0	109.99	[empty string]	109.99	[empty string]	PACIFIC SALT LIGHTWEIGHT SPYDER EDGE BLACK H1	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Pacific Salt Lightweight Spyder Edge Black H1	[empty string]	[empty string]	N	109.99	109.99	[empty string]	[empty string]	[empty string]	1000	C91BBK2	342611	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/pacific-salt-lightweight-spyder-edge-black-h1-342611	1
22	[empty string]	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	[empty string]	0	159.99	0	159.99	[empty string]	159.99	[empty string]	PARA MILITARY 2G-10 SPYDER EDGE CPM S30V	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	7	150-to-200	0.00	[empty string]	Para Military 2g-10 Spyder Edge Cpm S30v	[empty string]	[empty string]	N	159.99	159.99	[empty string]	[empty string]	[empty string]	1000	C81GS2	342614	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/para-military-2g-10-spyder-edge-cpm-s30v-342614	1
23	[empty string]	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	[empty string]	0	59.99	0	59.99	[empty string]	59.99	[empty string]	TENACIOUS PLAIN EDGE G10 BLACK FOLDING KNIFE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Tenacious Plain Edge G10 Black Folding Knife	[empty string]	[empty string]	N	59.99	59.99	[empty string]	[empty string]	[empty string]	1000	C122GP	343479	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/tenacious-plain-edge-g10-black-folding-knife-343479	1
24	[empty string]	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	[empty string]	0	169.99	0	169.99	[empty string]	169.99	[empty string]	NATIVE 5 PLAIN EDGE G10 BLACK FOLDING KNIFE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	150-to-200	0.00	[empty string]	Native 5 Plain Edge G10 Black Folding Knife	[empty string]	[empty string]	N	169.99	169.99	[empty string]	[empty string]	[empty string]	1000	C41GP5	343483	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/native-5-plain-edge-g10-black-folding-knife-343483	1
25	[empty string]	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	[empty string]	0	129.99	0	129.99	[empty string]	129.99	[empty string]	NATIVE 5 LIGHTWEIGHT BLACK BLADE PART SERR	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	100-to-150	0.00	[empty string]	Native 5 Lightweight Black Blade Part Serr	[empty string]	[empty string]	N	129.99	129.99	[empty string]	[empty string]	[empty string]	1000	C41PSBBK5	343484	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/native-5-lightweight-black-blade-part-serr-343484	1
26	[empty string]	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	[empty string]	0	179.99	0	179.99	[empty string]	179.99	[empty string]	NATIVE CHIEF PLAIN EDGE G10 BLACK FOLDING KNIFE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	150-to-200	0.00	[empty string]	Native Chief Plain Edge G10 Black Folding Knife	[empty string]	[empty string]	N	179.99	179.99	[empty string]	[empty string]	[empty string]	1000	C244GP	343487	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/native-chief-plain-edge-g10-black-folding-knife-343487	1
27	[empty string]	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	[empty string]	0	229.99	0	229.99	[empty string]	229.99	[empty string]	SHAMAN PLAIN EDGE G10 BLACK BLADE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	200-to-250	0.00	[empty string]	Shaman Plain Edge G10 Black Blade	[empty string]	[empty string]	N	229.99	229.99	[empty string]	[empty string]	[empty string]	1000	C229GPBK	343491	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/shaman-plain-edge-g10-black-blade-343491	1
28	[empty string]	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	[empty string]	0	149.99	0	149.99	[empty string]	149.99	[empty string]	POLICE MODEL STAINLESS PLAIN EDGE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Police Model Stainless Plain Edge	[empty string]	[empty string]	N	149.99	149.99	[empty string]	[empty string]	[empty string]	1000	C07P	343492	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/police-model-stainless-plain-edge-343492	1
29	[empty string]	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	[empty string]	0	149.99	0	149.99	[empty string]	149.99	[empty string]	POLICE MODEL STAINLESSPARTIAL SERRATEDEDGE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Police Model Stainlesspartial Serratededge	[empty string]	[empty string]	N	149.99	149.99	[empty string]	[empty string]	[empty string]	1000	C07PS	343493	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/police-model-stainlesspartial-serratededge-343493	1
30	[empty string]	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	[empty string]	0	119.99	0	119.99	[empty string]	119.99	[empty string]	POLICE MODEL 4 LIGHTWEIGHT BLACKPLAIN EDGE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	100-to-150	0.00	[empty string]	Police Model 4 Lightweight Blackplain Edge	[empty string]	[empty string]	N	119.99	119.99	[empty string]	[empty string]	[empty string]	1000	C07PBK4	343495	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/police-model-4-lightweight-blackplain-edge-343495	1
31	[empty string]	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	[empty string]	0	119.99	0	119.99	[empty string]	119.99	[empty string]	HARPY STAINLESS FULL SERRATED	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	100-to-150	0.00	[empty string]	Harpy Stainless Full Serrated	[empty string]	[empty string]	N	119.99	119.99	[empty string]	[empty string]	[empty string]	1000	C08S	343496	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/harpy-stainless-full-serrated-343496	1
32	[empty string]	SPYDERCO	Spyderco	CUTLERY	Cutlery>Autos	[empty string]	0	219.99	0	219.99	[empty string]	219.99	[empty string]	AUTONOMY 2 PLAIN EDGE G10 BLACK FOLDING KNIFE	N	9 BILL	[empty string]	[empty string]	[empty string]	A	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	200-to-250	0.00	[empty string]	Autonomy 2 Plain Edge G10 Black Folding Knife	[empty string]	[empty string]	N	219.99	219.99	[empty string]	[empty string]	[empty string]	1000	C165GP2	343498	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	spyderco/autonomy-2-plain-edge-g10-black-folding-knife-343498	1
33	BLACK/BLACK	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	BLACK/BLACK\|NULL\|NULL	0	54.99	0	54.99	[empty string]	54.99	[empty string]	TENACIOUS PE PS G10 BLACK FKNIFE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	Tenacious Pe Ps G10 Black Fknife	[empty string]	[empty string]	N	54.99	54.99	[empty string]	[empty string]	[empty string]	1000	C122GPS	355565	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/tenacious-pe-ps-g10-black-fknife-355565	1
34	BLUE	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	BLUE\|NULL\|NULL	0	99.99	0	99.99	[empty string]	99.99	[empty string]	TENACIOUS LIGHTWEIGHT BLUE S35VNFKNIFE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	Tenacious Lightweight Blue S35vnfknife	[empty string]	[empty string]	N	99.99	99.99	3.39IN	[empty string]	[empty string]	1000	C122PBL	355568	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/tenacious-lightweight-blue-s35vnfknife-355568	1
35	STAINLESS	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	STAINLESS\|NULL\|NULL	0	34.99	0	34.99	[empty string]	34.99	[empty string]	CLIP TOOL STAINLESS W SCISSORS	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Clip Tool Stainless W Scissors	[empty string]	[empty string]	N	34.99	34.99	2IN	[empty string]	[empty string]	1000	C169P	355578	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/clip-tool-stainless-w-scissors-355578	1
36	STAINLESS	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	STAINLESS\|NULL\|NULL	0	34.99	0	34.99	[empty string]	34.99	[empty string]	CLIP TOOL STAINLESS W PLAIN AND SERRATES	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Clip Tool Stainless W Plain And Serrates	[empty string]	[empty string]	N	34.99	34.99	2IN	[empty string]	[empty string]	1000	C176PANDS	355582	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/clip-tool-stainless-w-plain-and-serrates-355582	1
37	BLUE	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	BLUE\|NULL\|NULL	0	139.99	0	139.99	[empty string]	139.99	[empty string]	ENDURA 4 LIGHTWEIGHT BLUE K390 MICRO CLEAN	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Endura 4 Lightweight Blue K390 Micro Clean	[empty string]	[empty string]	N	139.99	139.99	3.8IN	[empty string]	[empty string]	1000	C10FPK390	355584	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/endura-4-lightweight-blue-k390-micro-clean-355584	1
38	BLUE	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	BLUE\|NULL\|NULL	0	129.99	0	129.99	[empty string]	129.99	[empty string]	ENDELA LIGHTWEIGHT BLUE K390 MICRO CLEAN	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Endela Lightweight Blue K390 Micro Clean	[empty string]	[empty string]	N	129.99	129.99	3.4IN	[empty string]	[empty string]	1000	C243FPK390	355587	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/endela-lightweight-blue-k390-micro-clean-355587	1
39	BLACK	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	BLACK\|NULL\|NULL	0	69.99	0	69.99	[empty string]	69.99	[empty string]	DRAGON FLY 2 LIGHTWEIGHT BLACK	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	50-to-100	0.00	[empty string]	Dragon Fly 2 Lightweight Black	[empty string]	[empty string]	N	69.99	69.99	2.29IN	[empty string]	[empty string]	1000	C28PBK2	355591	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/dragon-fly-2-lightweight-black-355591	1
40	STAINLESS	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	STAINLESS\|NULL\|NULL	0	79.99	0	79.99	[empty string]	79.99	[empty string]	DRAGON FLY 2 STAINLESS	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Dragon Fly 2 Stainless	[empty string]	[empty string]	N	79.99	79.99	2.29IN	[empty string]	[empty string]	1000	C28P	355592	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/dragon-fly-2-stainless-355592	1
41	BLUE	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	BLUE\|NULL\|NULL	0	139.99	0	139.99	[empty string]	139.99	[empty string]	PARA 3 LIGHTWEIGHT BLUE CPMSPY27	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	100-to-150	0.00	[empty string]	Para 3 Lightweight Blue Cpmspy27	[empty string]	[empty string]	N	139.99	139.99	2.95IN	[empty string]	[empty string]	1000	C223PCBL	355598	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/para-3-lightweight-blue-cpmspy27-355598	1
42	BLACK	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	BLACK\|NULL\|NULL	0	109.99	0	109.99	[empty string]	109.99	[empty string]	PARA 3 LIGHTWEIGHT BLACK	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	100-to-150	0.00	[empty string]	Para 3 Lightweight Black	[empty string]	[empty string]	N	109.99	109.99	2.95IN	[empty string]	[empty string]	1000	C223PBK	355601	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/para-3-lightweight-black-355601	1
43	BLACK	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	BLACK\|NULL\|NULL	0	119.99	0	119.99	[empty string]	119.99	[empty string]	PARA 3 LIGHTWEIGHT BLACK/BLACK	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	100-to-150	0.00	[empty string]	Para 3 Lightweight Black/black	[empty string]	[empty string]	N	119.99	119.99	2.95IN	[empty string]	[empty string]	1000	C223PBBK	355602	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/para-3-lightweight-black-black-355602	1
44	BLACK	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	BLACK\|NULL\|NULL	0	149.99	0	149.99	[empty string]	149.99	[empty string]	PARA 3 G10 BLACK	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	100-to-150	0.00	[empty string]	Para 3 G10 Black	[empty string]	[empty string]	N	149.99	149.99	2.95IN	[empty string]	[empty string]	1000	C223GP	355603	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/para-3-g10-black-355603	1
45	BLACK/BLACK	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	BLACK/BLACK\|NULL\|NULL	0	159.99	0	159.99	[empty string]	159.99	[empty string]	PARA 3 G10 BLACK/BLACK	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	Para 3 G10 Black/black	[empty string]	[empty string]	N	159.99	159.99	2.95IN	[empty string]	[empty string]	1000	C223GPBK	355604	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/para-3-g10-black-black-355604	1
46	DARKBLUEG10	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	DARKBLUEG10\|NULL\|NULL	0	189.99	0	189.99	[empty string]	189.99	[empty string]	PARA 3 G10 DARK BLUE CPMS110V	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	150-to-200	0.00	[empty string]	Para 3 G10 Dark Blue Cpms110v	[empty string]	[empty string]	N	189.99	189.99	2.95IN	[empty string]	[empty string]	1000	C223GPDBL	355607	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/para-3-g10-dark-blue-cpms110v-355607	1
47	BLACK	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	BLACK\|NULL\|NULL	0	159.99	0	159.99	[empty string]	159.99	[empty string]	PARA MILITARY 2G-10 PLAIN EDGE BLACK	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	150-to-200	0.00	[empty string]	Para Military 2g-10 Plain Edge Black	[empty string]	[empty string]	N	159.99	159.99	3.42IN	[empty string]	[empty string]	1000	C81GP2	355613	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/para-military-2g-10-plain-edge-black-355613	1
48	DARKBLUEG10	SPYDERCO	Spyderco	CUTLERY	Cutlery>Folding	DARKBLUEG10\|NULL\|NULL	0	199.99	0	199.99	[empty string]	199.99	[empty string]	PARA MILITARY 2 G-10 DARK BLUE CPMS110V	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	150-to-200	0.00	[empty string]	Para Military 2 G-10 Dark Blue Cpms110v	[empty string]	[empty string]	N	199.99	199.99	3.42IN	[empty string]	[empty string]	1000	C81GPDBL2	355614	EMPTY	EMPTY	EMPTY	0	0	0	FOLDING	[empty string]	spyderco/para-military-2-g-10-dark-blue-cpms110v-355614	1

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

2 1

Filter

2 1

Filter By

Price

Categories

Brand

Size

Endura Lightweight Plain Edge Folding Knife

Endura Stainless Combo Edge Folding Knife

Endura Lightweight Combo Edge Black Blade

Endura Stainless Spyder Edge Folding Knife

Endura Lightweight Spyder Edge Black Blade

Endura Stainless Plain Edge Folding Knife

Delica Lightweight Combo Edge Black Blade

Endura Lightweight Orange Plain Edge

Endura Lightweight British Racing Green Zdp- 189

Delica Lightweight Orange Plaine Edge

Delica Stainless Plaine Edge

Delica Lightweight Plain Edge

Delica Stainless Spyder Edge

Ikuchi Carbon Fiber Cpm S30v Plain Edge

Kapara Carbon Fiber Cpm S30v Plain Edge

Manix 2 G- 10 Plain Edge Spm S30v

Manix 2 G- 10 Plain Edge Black Blade Cpm S30v

Manix 2 G- 10 Combo Edge Spm S30v

Military G- 10 Plain Edge Black Blade Cpm S30v

Military G- 10 Plain Edge Cpm S30v

Pacific Salt Lightweight Spyder Edge Black H1

Para Military 2g- 10 Spyder Edge Cpm S30v

Tenacious Plain Edge G10 Black Folding Knife

Native 5 Plain Edge G10 Black Folding Knife