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	BLACK	BENCHMADE KNIVES	Benchmade Knives	CUTLERY	Cutlery>Autos	BLACK\|NULL\|NULL	0	239.99	0	239.99	[empty string]	239.99	[empty string]	PRESIDIO II AXIS FULLY AUTOMATIC	N	9 BILL	[empty string]	[empty string]	[empty string]	A	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2017	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	1	200-to-250	0.00	[empty string]	Presidio Ii Axis Fully Automatic	[empty string]	[empty string]	N	239.99	239.99	AUTO	[empty string]	[empty string]	1000	5700SBK	290034	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	benchmade-knives/presidio-ii-axis-fully-automatic-290034	1
2	[empty string]	BENCHMADE KNIVES	Benchmade Knives	CUTLERY	Cutlery>Autos	[empty string]	0	199.99	0	199.99	[empty string]	199.99	[empty string]	CLA FULLY AUTOMATIC	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]	2017	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	Cla Fully Automatic	[empty string]	[empty string]	N	199.99	199.99	AUTO	[empty string]	[empty string]	1000	4300	290050	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	benchmade-knives/cla-fully-automatic-290050	1
3	[empty string]	BENCHMADE KNIVES	Benchmade Knives	CUTLERY	Cutlery>Autos	[empty string]	0	209.99	0	209.99	[empty string]	209.99	[empty string]	CLA FULLY AUTOMATIC BLACK BLADE	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]	2017	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	1	200-to-250	0.00	[empty string]	Cla Fully Automatic Black Blade	[empty string]	[empty string]	N	209.99	209.99	AUTO	[empty string]	[empty string]	1000	4300BK	290051	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	benchmade-knives/cla-fully-automatic-black-blade-290051	1
4	GREEN/BLACK	BENCHMADE KNIVES	Benchmade Knives	CUTLERY	Cutlery>Autos	GREEN/BLACK\|NULL\|NULL	0	199.99	0	199.99	[empty string]	199.99	[empty string]	CLA FULLY AUTOMATIC	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]	2017	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	2	150-to-200	0.00	[empty string]	Cla Fully Automatic	[empty string]	[empty string]	N	199.99	199.99	AUTO	[empty string]	[empty string]	1000	4300-1	290052	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	benchmade-knives/cla-fully-automatic-290052	1
5	[empty string]	BUCK KNIVES	Buck Knives	CUTLERY	Cutlery>Autos	[empty string]	0	189.99	0	189.99	[empty string]	189.99	[empty string]	110 FOLDING HUNTER FULLY AUTOMATIC	N	9 BILL	[empty string]	[empty string]	[empty string]	A	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2017	1 TIME BUY	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	7	150-to-200	0.00	[empty string]	110 Folding Hunter Fully Automatic	[empty string]	[empty string]	N	189.99	189.99	AUTO	[empty string]	[empty string]	1000	0110BRSA	290074	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	buck-knives/110-folding-hunter-fully-automatic-290074	1
6	AUTOMATIC	GERBER	Gerber	CUTLERY	Cutlery>Autos	AUTOMATIC\|NULL\|NULL	0	139.99	0	139.99	[empty string]	139.99	[empty string]	MINI COVERT AUTO FOLDER TACTICAL BLACK	N	9 BILL	[empty string]	[empty string]	[empty string]	A	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2017	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	5	100-to-150	0.00	[empty string]	Covert F.a.s.t. - Serrated Edge	The Covert FAST combines Forward Action Spring Technology with the classic Applegate-Fairbairn design. Featuring one-hand opening for quick deployment, titanium-coated blade, and G-10 handle to give you a tacky grip. Full-sized handle for a sturdy grip.<br/> <br> <br> <br> <i><font size=1> Note: While every effort is made to include accurate and correct images, descriptions, specifications and pricing for each product, they are shown for example only and do not necessarily represent the product in its entirety. Inadvertent errors may occur. Jay`s Sporting Goods reserves the right to modify or change product information and pricing without notice. If you have a question about an item, please call or email us for more information before ordering.</font></i>	[empty string]	N	139.99	139.99	[empty string]	[empty string]	[empty string]	1000	30-001394	290792	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	gerber/mini-covert-auto-folder-tactical-black-290792	1
7	AUTOMATIC	GERBER	Gerber	CUTLERY	Cutlery>Autos	AUTOMATIC\|NULL\|NULL	0	139.99	0	139.99	[empty string]	139.99	[empty string]	PROPEL DOWN RANGE AUTO TAN G10	N	9 BILL	[empty string]	[empty string]	[empty string]	A	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2017	[empty string]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Propel Down Range Auto Tan G10	[empty string]	[empty string]	N	139.99	139.99	[empty string]	[empty string]	[empty string]	1000	30-000717	293964	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	gerber/propel-down-range-auto-tan-g10-293964	1
8	AUTOMATIC	GERBER	Gerber	CUTLERY	Cutlery>Autos	AUTOMATIC\|NULL\|NULL	0	139.99	0	139.99	[empty string]	139.99	[empty string]	PROPEL AUTO OD GREEN G10 POLISHED BLADE	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]	2017	[empty string]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	4	100-to-150	0.00	[empty string]	Propel Auto Od Green G10 Polished Blade	[empty string]	[empty string]	N	139.99	139.99	[empty string]	[empty string]	[empty string]	1000	30-001308	293965	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	gerber/propel-auto-od-green-g10-polished-blade-293965	1
9	AUTOMATIC	SOG SPECIALTY KNIVES	Sog Specialty Knives	CUTLERY	Cutlery>Autos	AUTOMATIC\|NULL\|NULL	0	129.99	0	129.99	[empty string]	129.99	[empty string]	SPEC-ELITE I AUTO BLACKTINI 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]	2018	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Spec-elite I Auto Blacktini Knife	[empty string]	[empty string]	N	129.99	129.99	[empty string]	[empty string]	[empty string]	1000	SE-52	299722	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	sog-specialty-knives/spec-elite-i-auto-blacktini-knife-299722	1
10	[empty string]	BUCK KNIVES	Buck Knives	CUTLERY	Cutlery>Autos	[empty string]	0	249.99	0	249.99	[empty string]	249.99	[empty string]	AUTO ELITE110 HUNTER FULLY AUTOMATIC	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]	2018	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	3	200-to-250	0.00	[empty string]	Auto Elite110 Hunter Fully Automatic	[empty string]	[empty string]	N	249.99	249.99	AUTO	[empty string]	[empty string]	1000	0110BKSA	303064	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	buck-knives/auto-elite110-hunter-fully-automatic-303064	1
11	BLACK	BENCHMADE KNIVES	Benchmade Knives	CUTLERY	Cutlery>Autos	BLACK\|NULL\|NULL	0	389.99	0	389.99	[empty string]	389.99	[empty string]	MINI-INFIDEL BLACK OTF FULL AUTO KNIFE	N	9 BILL	[empty string]	[empty string]	[empty string]	A	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	1	350-to-400	0.00	[empty string]	Mini-infidel Black Otf Full Auto Knife	[empty string]	[empty string]	N	389.99	389.99	AUTO	[empty string]	[empty string]	1000	3350BK	304657	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	benchmade-knives/mini-infidel-black-otf-full-auto-knife-304657	1
12	PURPLE,BLACK,ODGREEN,TIFFBLUE,CARFI,NYPDBLUE,STONEWASH,PINK,PLUM,RED	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	PURPLE\|NULL\|NULL,BLACK\|NULL\|NULL,ODGREEN\|NULL\|NULL,TIFFBLUE\|NULL\|NULL,CARFI\|NULL\|NULL,NYPDBLUE\|NULL\|NULL,STONEWASH\|NULL\|NULL,PINK\|NULL\|NULL,PLUM\|NULL\|NULL,RED\|NULL\|NULL	1	129.99	1	109.99	85637-DEFAULT-l.jpg	129.99	85637-DEFAULT-m.jpg	CTK-1 OTF AUTO KNIFE D2 STEEL	N	9 BILL	[empty string]	[empty string]	[empty string]	A	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	94	100-to-150	0.00	[empty string]	Ctk-1 Otf Auto Knife D2 Steel	[empty string]	[empty string]	N	109.99	129.99	MEDIUM,SMALL,LARGE	85637-DEFAULT-s.jpg	[empty string]	1000	CTK-1 D2	307025	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	cobratec-knives/ctk-1-otf-auto-knife-d2-steel-307025	1
13	GREY/FE	GERBER	Gerber	CUTLERY	Cutlery>Autos	GREY/FE\|NULL\|NULL	0	149.99	0	149.99	[empty string]	149.99	[empty string]	COVERT AUTO FOLDER GRAY FE	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]	2018	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	6	100-to-150	0.00	[empty string]	Covert F.a.s.t. - Serrated Edge	The Covert FAST combines Forward Action Spring Technology with the classic Applegate-Fairbairn design. Featuring one-hand opening for quick deployment, titanium-coated blade, and G-10 handle to give you a tacky grip. Full-sized handle for a sturdy grip.<br/> <br> <br> <br> <i><font size=1> Note: While every effort is made to include accurate and correct images, descriptions, specifications and pricing for each product, they are shown for example only and do not necessarily represent the product in its entirety. Inadvertent errors may occur. Jay`s Sporting Goods reserves the right to modify or change product information and pricing without notice. If you have a question about an item, please call or email us for more information before ordering.</font></i>	[empty string]	N	149.99	149.99	[empty string]	[empty string]	[empty string]	1000	30-001306	307398	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	gerber/covert-auto-folder-gray-fe-307398	1
14	[empty string]	KERSHAW KNIVES	Kershaw Knives	CUTLERY	Cutlery>Autos	[empty string]	0	159.99	0	159.99	[empty string]	159.99	[empty string]	AUTO LAUNCH 1 BLACKWASH	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]	2018	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	7	150-to-200	0.00	[empty string]	Auto Launch 1 Blackwash	[empty string]	[empty string]	N	159.99	159.99	[empty string]	[empty string]	[empty string]	1000	7100BW	308019	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	kershaw-knives/auto-launch-1-blackwash-308019	1
15	BLACK	KERSHAW KNIVES	Kershaw Knives	CUTLERY	Cutlery>Autos	BLACK\|NULL\|NULL	0	99.99	0	99.99	[empty string]	99.99	[empty string]	AUTO LAUNCH 4 BLACK	N	9 BILL	[empty string]	[empty string]	[empty string]	A	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	9	50-to-100	0.00	[empty string]	Auto Launch 4 Black	[empty string]	[empty string]	N	99.99	99.99	[empty string]	[empty string]	[empty string]	1000	7500BLK	308023	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	kershaw-knives/auto-launch-4-black-308023	1
16	BLACK	KERSHAW KNIVES	Kershaw Knives	CUTLERY	Cutlery>Autos	BLACK\|NULL\|NULL	0	179.99	0	179.99	[empty string]	179.99	[empty string]	AUTO LAUNCH 6 BLACK	N	9 BILL	[empty string]	[empty string]	[empty string]	A	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	6	150-to-200	0.00	[empty string]	Auto Launch 6 Black	[empty string]	[empty string]	N	179.99	179.99	[empty string]	[empty string]	[empty string]	1000	7800BLK	308024	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	kershaw-knives/auto-launch-6-black-308024	1
17	[empty string]	BUCK KNIVES	Buck Knives	CUTLERY	Cutlery>Autos	[empty string]	0	179.99	0	179.99	[empty string]	179.99	[empty string]	112 FOLDING HUNTER AUTOMATIC	N	9 BILL	[empty string]	[empty string]	[empty string]	A	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	4	150-to-200	0.00	[empty string]	112 Folding Hunter Automatic	[empty string]	[empty string]	N	179.99	179.99	AUTO	[empty string]	[empty string]	1000	0112BRSA-B	308401	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	buck-knives/112-folding-hunter-automatic-308401	1
18	[empty string]	BUCK KNIVES	Buck Knives	CUTLERY	Cutlery>Autos	[empty string]	0	229.99	0	229.99	[empty string]	229.99	[empty string]	112AUTO ELITE FOLDING HUNTER AUTOMATIC	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]	2018	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	6	200-to-250	0.00	[empty string]	112auto Elite Folding Hunter Automatic	[empty string]	[empty string]	N	229.99	229.99	AUTO	[empty string]	[empty string]	1000	0112BKSA	308402	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	buck-knives/112auto-elite-folding-hunter-automatic-308402	1
19	CARFI,BLACK,ODGREEN,GREY	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	CARFI\|NULL\|NULL,BLACK\|NULL\|NULL,ODGREEN\|NULL\|NULL,GREY\|NULL\|NULL	1	109.99	0	109.99	85639-DEFAULT-l.jpg	109.99	85639-DEFAULT-m.jpg	FANG FS-3 OTF AUTO KNIFE D2 STEEL	N	9 BILL	[empty string]	[empty string]	[empty string]	A	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	27	100-to-150	0.00	[empty string]	Fang Fs-3 Otf Auto Knife D2 Steel	[empty string]	[empty string]	N	109.99	109.99	SMALL,LARGE	85639-DEFAULT-s.jpg	[empty string]	1000	FS-3D2	312853	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	cobratec-knives/fang-fs-3-otf-auto-knife-d2-steel-312853	1
20	BLACK	BUCK KNIVES	Buck Knives	CUTLERY	Cutlery>Autos	BLACK\|NULL\|NULL	0	199.99	0	199.99	[empty string]	199.99	[empty string]	12335 IMPACT TACTICAL AUTO ARMOR BLACK	N	9 BILL	[empty string]	[empty string]	[empty string]	A	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	4	150-to-200	0.00	[empty string]	12335 Impact Tactical Auto Armor Black	[empty string]	[empty string]	N	199.99	199.99	[empty string]	[empty string]	[empty string]	1000	0898BKS1	313252	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	buck-knives/12335-impact-tactical-auto-armor-black-313252	1
21	COYOTETAN	BUCK KNIVES	Buck Knives	CUTLERY	Cutlery>Autos	COYOTETAN\|NULL\|NULL	0	199.99	0	199.99	[empty string]	199.99	[empty string]	12336 IMPACT TACTICAL AUTO COYOTE TAN	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]	2019	[empty string]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	3	150-to-200	0.00	[empty string]	12336 Impact Tactical Auto Coyote Tan	[empty string]	[empty string]	N	199.99	199.99	[empty string]	[empty string]	[empty string]	1000	0898BRS1	313253	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	buck-knives/12336-impact-tactical-auto-coyote-tan-313253	1
22	ODGREEN	BUCK KNIVES	Buck Knives	CUTLERY	Cutlery>Autos	ODGREEN\|NULL\|NULL	0	199.99	0	199.99	[empty string]	199.99	[empty string]	122337 IMPACT TACTICAL AUTO O.D.GREEN	N	9 BILL	[empty string]	[empty string]	[empty string]	A	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	4	150-to-200	0.00	[empty string]	122337 Impact Tactical Auto O.d.green	[empty string]	[empty string]	N	199.99	199.99	[empty string]	[empty string]	[empty string]	1000	0898GRS1-B	313254	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	buck-knives/122337-impact-tactical-auto-o-d-green-313254	1
23	AUTOMATIC	GERBER	Gerber	CUTLERY	Cutlery>Autos	AUTOMATIC\|NULL\|NULL	0	139.99	0	139.99	[empty string]	139.99	[empty string]	EMPOWER AUTO BLACK/BLACK FINE EDGE	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]	2019	PROMO	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	100-to-150	0.00	[empty string]	Empower Auto Black/black Fine Edge	[empty string]	[empty string]	N	139.99	139.99	[empty string]	[empty string]	[empty string]	1000	30-001321	314792	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	gerber/empower-auto-black-black-fine-edge-314792	1
24	[empty string]	KERSHAW KNIVES	Kershaw Knives	CUTLERY	Cutlery>Autos	[empty string]	0	129.99	0	129.99	[empty string]	129.99	[empty string]	LAUNCH 8 STILETTO AUTO 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]	2019	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	100-to-150	0.00	[empty string]	Launch 8 Stiletto Auto Knife	[empty string]	[empty string]	N	129.99	129.99	[empty string]	[empty string]	[empty string]	1000	7150	316899	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	kershaw-knives/launch-8-stiletto-auto-knife-316899	1
25	[empty string]	KERSHAW KNIVES	Kershaw Knives	CUTLERY	Cutlery>Autos	[empty string]	0	109.99	0	109.99	[empty string]	109.99	[empty string]	LAUNCH 9 AUTO 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]	2019	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	100-to-150	0.00	[empty string]	Launch 9 Auto Knife	[empty string]	[empty string]	N	109.99	109.99	[empty string]	[empty string]	[empty string]	1000	7250	316900	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	kershaw-knives/launch-9-auto-knife-316900	1
26	[empty string]	KERSHAW KNIVES	Kershaw Knives	CUTLERY	Cutlery>Autos	[empty string]	0	179.99	0	179.99	[empty string]	179.99	[empty string]	LAUNCH 7 AUTO 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]	2019	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	9	150-to-200	0.00	[empty string]	Launch 7 Auto Knife	[empty string]	[empty string]	N	179.99	179.99	[empty string]	[empty string]	[empty string]	1000	7900GRYBLK	316901	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	kershaw-knives/launch-7-auto-knife-316901	1
27	[empty string]	SOG SPECIALTY KNIVES	Sog Specialty Knives	CUTLERY	Cutlery>Autos	[empty string]	0	189.99	0	189.99	[empty string]	189.99	[empty string]	STRAT OPS AUTO USA MADE 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]	2019	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	Strat Ops Auto Usa Made Knife	[empty string]	[empty string]	N	189.99	189.99	[empty string]	[empty string]	[empty string]	1000	SO1001-BX	318789	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	sog-specialty-knives/strat-ops-auto-usa-made-knife-318789	1
28	[empty string]	SOG SPECIALTY KNIVES	Sog Specialty Knives	CUTLERY	Cutlery>Autos	[empty string]	0	199.99	0	199.99	[empty string]	199.99	[empty string]	TAC OPS AUTO USA MADE 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]	2019	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	150-to-200	0.00	[empty string]	Tac Ops Auto Usa Made Knife	[empty string]	[empty string]	N	199.99	199.99	[empty string]	[empty string]	[empty string]	1000	TO1011-BX	318792	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	sog-specialty-knives/tac-ops-auto-usa-made-knife-318792	1
29	COYOTE	BOKER USA	Boker Usa	CUTLERY	Cutlery>Autos	COYOTE\|NULL\|NULL	0	299.99	0	299.99	[empty string]	299.99	[empty string]	USA OTF AUTO COYOTE	N	9 BILL	[empty string]	[empty string]	[empty string]	A	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	PROMO	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	250-to-300	0.00	[empty string]	Usa Otf Auto Coyote	[empty string]	[empty string]	N	299.99	299.99	[empty string]	[empty string]	[empty string]	1000	06EX262	319302	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	boker-usa/usa-otf-auto-coyote-319302	1
30	RFP,BFP,LRFDP	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	RFP\|NULL\|NULL,BFP\|NULL\|NULL,LRFDP\|NULL\|NULL	1	169.99	0	169.99	85628-DEFAULT-l.jpg	169.99	85628-DEFAULT-m.jpg	FANG FS-3 OTF AUTO KNIFE CERAKOTED2 STEEL	N	9 BILL	[empty string]	[empty string]	[empty string]	A	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	11	150-to-200	0.00	[empty string]	Fang Fs-3 Otf Auto Knife Cerakoted2 Steel	[empty string]	[empty string]	N	169.99	169.99	LARGE	85628-DEFAULT-s.jpg	[empty string]	1000	FS-3 CERAKOTE	323542	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	cobratec-knives/fang-fs-3-otf-auto-knife-cerakoted2-steel-323542	1
31	SAND,COBRASKIN,BRONZE,AFLAG,RED	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	SAND\|NULL\|NULL,COBRASKIN\|NULL\|NULL,BRONZE\|NULL\|NULL,AFLAG\|NULL\|NULL,RED\|NULL\|NULL	1	169.99	1	149.99	86443-DEFAULT-l.jpg	169.99	86443-DEFAULT-m.jpg	CTK-1 OTF AUTO KNIFE CERAKOTE D2 STEEL	N	9 BILL	[empty string]	[empty string]	[empty string]	A	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	29	100-to-150	0.00	[empty string]	Ctk-1 Otf Auto Knife Cerakote D2 Steel	[empty string]	[empty string]	N	149.99	169.99	MEDIUM,SMALL,LARGE	86443-DEFAULT-s.jpg	[empty string]	1000	CTK-1 CERAKOTE	323543	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	cobratec-knives/ctk-1-otf-auto-knife-cerakote-d2-steel-323543	1
32	ZOMBIEGREEN,TIFFBLUE,ODGREEN,BLACK,NYPDBLUE,PURPLE	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	ZOMBIEGREEN\|NULL\|NULL,TIFFBLUE\|NULL\|NULL,ODGREEN\|NULL\|NULL,BLACK\|NULL\|NULL,NYPDBLUE\|NULL\|NULL,PURPLE\|NULL\|NULL	1	79.99	0	79.99	85638-DEFAULT-l.jpg	79.99	85638-DEFAULT-m.jpg	LIGHTWEIGHT OTF D2 STEEL 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]	2019	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	13	50-to-100	0.00	[empty string]	Lightweight Otf D2 Steel Knife	[empty string]	[empty string]	N	79.99	79.99	[empty string]	85638-DEFAULT-s.jpg	[empty string]	1000	LIGHTWEIGHT	323544	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	cobratec-knives/lightweight-otf-d2-steel-knife-323544	1
33	BLACK,TIFFBLUE,PURPLE	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	BLACK\|NULL\|NULL,TIFFBLUE\|NULL\|NULL,PURPLE\|NULL\|NULL	0	179.99	1	139.99	[empty string]	179.99	[empty string]	SIDEWINDER OTF D2 STEEL 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]	2019	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	20	100-to-150	0.00	[empty string]	Sidewinder Otf D2 Steel Knife	[empty string]	[empty string]	N	139.99	179.99	SMALL,LARGE	[empty string]	[empty string]	1000	SIDEWINDER	323545	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	cobratec-knives/sidewinder-otf-d2-steel-knife-323545	1
34	BLACK	SOG SPECIALTY KNIVES	Sog Specialty Knives	CUTLERY	Cutlery>Autos	BLACK\|NULL\|NULL	0	99.99	0	99.99	[empty string]	99.99	[empty string]	SOG-TAC CA SPECIAL BLACKOUT	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	50-to-100	0.00	[empty string]	Sog-tac Ca Special Blackout	[empty string]	[empty string]	N	99.99	99.99	[empty string]	[empty string]	[empty string]	1000	ST-14	333633	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	sog-specialty-knives/sog-tac-ca-special-blackout-333633	1
35	[empty string]	SPYDERCO	Spyderco	CUTLERY	Cutlery>Autos	[empty string]	0	229.99	0	229.99	[empty string]	229.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]	5	200-to-250	0.00	[empty string]	Autonomy 2 Plain Edge G10 Black Folding Knife	[empty string]	[empty string]	N	229.99	229.99	[empty string]	[empty string]	[empty string]	1000	C165GP2	343498	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	spyderco/autonomy-2-plain-edge-g10-black-folding-knife-343498	1
36	BLACKOUT	SOG SPECIALTY KNIVES	Sog Specialty Knives	CUTLERY	Cutlery>Autos	BLACKOUT\|NULL\|NULL	0	349.99	0	349.99	[empty string]	349.99	[empty string]	PENTAGON OTF BLACKOUT	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	300-to-350	0.00	[empty string]	Pentagon Otf Blackout	[empty string]	[empty string]	N	349.99	349.99	[empty string]	[empty string]	[empty string]	1000	15-61-01-57	346461	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	sog-specialty-knives/pentagon-otf-blackout-346461	1
37	FDE	SOG SPECIALTY KNIVES	Sog Specialty Knives	CUTLERY	Cutlery>Autos	FDE\|NULL\|NULL	0	349.99	0	349.99	[empty string]	349.99	[empty string]	PENTAGON OTF FDE	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	300-to-350	0.00	[empty string]	Pentagon Otf Fde	[empty string]	[empty string]	N	349.99	349.99	[empty string]	[empty string]	[empty string]	1000	15-61-02-57	346462	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	sog-specialty-knives/pentagon-otf-fde-346462	1
38	[empty string]	BUCK KNIVES	Buck Knives	CUTLERY	Cutlery>Autos	[empty string]	0	209.99	0	209.99	[empty string]	209.99	[empty string]	PARADIGM SHIFT AUTO BLACK G10 S35VN	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	NOT ONLINE	[empty string]	[empty string]	3	200-to-250	0.00	[empty string]	Woodsman Knife - Fixed Blade - Black	The Buck Woodsman is a classic, fine point. This smaller knife has a fine point blade perfect for fish and small game.<br/> <br> <br> <br> <i><font size=1> Note: While every effort is made to include accurate and correct images, descriptions, specifications and pricing for each product, they are shown for example only and do not necessarily represent the product in its entirety. Inadvertent errors may occur. Jay`s Sporting Goods reserves the right to modify or change product information and pricing without notice. If you have a question about an item, please call or email us for more information before ordering.</font></i>	[empty string]	N	209.99	209.99	[empty string]	[empty string]	[empty string]	1000	0591BKS	348646	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	buck-knives/paradigm-shift-auto-black-g10-s35vn-348646	1
39	[empty string]	BUCK KNIVES	Buck Knives	CUTLERY	Cutlery>Autos	[empty string]	0	209.99	0	209.99	[empty string]	209.99	[empty string]	PARADIGM SHIFT AUTO BROWN G10 S35VN	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	NOT ONLINE	[empty string]	[empty string]	3	200-to-250	0.00	[empty string]	Woodsman Knife - Fixed Blade - Black	The Buck Woodsman is a classic, fine point. This smaller knife has a fine point blade perfect for fish and small game.<br/> <br> <br> <br> <i><font size=1> Note: While every effort is made to include accurate and correct images, descriptions, specifications and pricing for each product, they are shown for example only and do not necessarily represent the product in its entirety. Inadvertent errors may occur. Jay`s Sporting Goods reserves the right to modify or change product information and pricing without notice. If you have a question about an item, please call or email us for more information before ordering.</font></i>	[empty string]	N	209.99	209.99	[empty string]	[empty string]	[empty string]	1000	0591BRS	348647	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	buck-knives/paradigm-shift-auto-brown-g10-s35vn-348647	1
40	[empty string]	BENCHMADE KNIVES	Benchmade Knives	CUTLERY	Cutlery>Autos	[empty string]	0	329.99	0	329.99	[empty string]	329.99	[empty string]	FACT AUTO AXS	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	300-to-350	0.00	[empty string]	Fact Auto Axs	[empty string]	[empty string]	N	329.99	329.99	[empty string]	[empty string]	[empty string]	1000	4170BK	349269	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	benchmade-knives/fact-auto-axs-349269	1
41	[empty string]	BENCHMADE KNIVES	Benchmade Knives	CUTLERY	Cutlery>Autos	[empty string]	0	209.99	0	209.99	[empty string]	209.99	[empty string]	CLAYMORE AUTO	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	200-to-250	0.00	[empty string]	Claymore Auto	[empty string]	[empty string]	N	209.99	209.99	[empty string]	[empty string]	[empty string]	1000	9070SBK	349274	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	benchmade-knives/claymore-auto-349274	1
42	[empty string]	BENCHMADE KNIVES	Benchmade Knives	CUTLERY	Cutlery>Autos	[empty string]	0	209.99	0	209.99	[empty string]	209.99	[empty string]	CLAYMORE AUTO	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	200-to-250	0.00	[empty string]	Claymore Auto	[empty string]	[empty string]	N	209.99	209.99	[empty string]	[empty string]	[empty string]	1000	9070SBK-1	349277	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	benchmade-knives/claymore-auto-349277	1
43	BLACK	BENCHMADE KNIVES	Benchmade Knives	CUTLERY	Cutlery>Autos	BLACK\|NULL\|NULL	0	269.99	0	269.99	[empty string]	269.99	[empty string]	PRESIDIO II AXIS FULLY AUTOMATIC	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]	2021	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	2	250-to-300	0.00	[empty string]	Presidio Ii Axis Fully Automatic	[empty string]	[empty string]	N	269.99	269.99	AUTO	[empty string]	[empty string]	1000	5700SGY-1	349279	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	benchmade-knives/presidio-ii-axis-fully-automatic-349279	1

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM GetALLProducts439 ORDER BY sortposition asc

Cutlery

Sort By:

Items per page:

2 1

Filter

2 1

Filter By

Price

Brand

Size

Presidio Ii Axis Fully Automatic

Cla Fully Automatic

Cla Fully Automatic Black Blade

Cla Fully Automatic

110 Folding Hunter Fully Automatic

Covert F.A.S.T.- Serrated Edge

Propel Down Range Auto Tan G10

Propel Auto Od Green G10 Polished Blade

Spec- Elite I Auto Blacktini Knife

Auto Elite110 Hunter Fully Automatic

Mini- Infidel Black Otf Full Auto Knife

Ctk- 1 Otf Auto Knife D2 Steel

Covert F.A.S.T.- Serrated Edge

Auto Launch 1 Blackwash

Auto Launch 4 Black

Auto Launch 6 Black

112 Folding Hunter Automatic

112auto Elite Folding Hunter Automatic

Fang Fs- 3 Otf Auto Knife D2 Steel

12335 Impact Tactical Auto Armor Black

12336 Impact Tactical Auto Coyote Tan

122337 Impact Tactical Auto O.D.Green

Empower Auto Black/Black Fine Edge

Launch 8 Stiletto Auto Knife