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]	BUCK KNIVES	Buck Knives	CUTLERY	Cutlery>Autos	[empty string]	0	139.99	0	139.99	[empty string]	139.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]	3	100-to-150	0.00	[empty string]	110 Folding Hunter Fully Automatic	[empty string]	[empty string]	N	139.99	139.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
2	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]	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	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
3	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]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2017	[empty string]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	2	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
4	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]	1	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
5	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
6	AUTOMATIC	SOG SPECIALTY KNIVES	Sog Specialty Knives	CUTLERY	Cutlery>Autos	AUTOMATIC\|NULL\|NULL	0	139.99	0	139.99	[empty string]	139.99	[empty string]	SOG-TAC AUTO TACTICAL DROP POINT BLACKTINI	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]	SELL THRU	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Sog-tac Auto Tactical Drop Point Blacktini	[empty string]	[empty string]	N	139.99	139.99	[empty string]	[empty string]	[empty string]	1000	ST-06	299724	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	sog-specialty-knives/sog-tac-auto-tactical-drop-point-blacktini-299724	1
7	[empty string]	BUCK KNIVES	Buck Knives	CUTLERY	Cutlery>Autos	[empty string]	0	199.99	0	199.99	[empty string]	199.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]	6	150-to-200	0.00	[empty string]	Auto Elite110 Hunter Fully Automatic	[empty string]	[empty string]	N	199.99	199.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
8	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]	2	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
9	SPIDERWEB,WINTER	PROTECH KNIVES	Protech Knives	CUTLERY	Cutlery>Autos	SPIDERWEB\|NULL\|NULL,WINTER\|NULL\|NULL	0	249.99	0	249.99	[empty string]	249.99	[empty string]	TR-5 AUTO FOLDING 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]	2021	[empty string]	[empty string]	SELL THRU	[empty string]	[empty string]	[empty string]	3	200-to-250	0.00	[empty string]	Tr-5 Auto Folding Knife	[empty string]	[empty string]	N	249.99	249.99	3.75IN	[empty string]	[empty string]	1000	TR-503	306051	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	protech-knives/tr-5-auto-folding-knife-306051	1
10	TIFFBLUE,BLACK,PURPLE,NYPDBLUE,CARFI,ODGREEN,PINK,PLUM	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	TIFFBLUE\|NULL\|NULL,BLACK\|NULL\|NULL,PURPLE\|NULL\|NULL,NYPDBLUE\|NULL\|NULL,CARFI\|NULL\|NULL,ODGREEN\|NULL\|NULL,PINK\|NULL\|NULL,PLUM\|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]	66	100-to-150	0.00	[empty string]	Ctk-1 Otf Auto Knife D2 Steel	[empty string]	[empty string]	N	109.99	129.99	SMALL,MEDIUM,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
11	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]	1	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
12	[empty string]	KERSHAW KNIVES	Kershaw Knives	CUTLERY	Cutlery>Autos	[empty string]	0	129.99	0	129.99	[empty string]	129.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]	9	100-to-150	0.00	[empty string]	Auto Launch 1 Blackwash	[empty string]	[empty string]	N	129.99	129.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
13	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]	14	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
14	BLACK	KERSHAW KNIVES	Kershaw Knives	CUTLERY	Cutlery>Autos	BLACK\|NULL\|NULL	0	139.99	0	139.99	[empty string]	139.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]	5	100-to-150	0.00	[empty string]	Auto Launch 6 Black	[empty string]	[empty string]	N	139.99	139.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
15	BLACKWASH	KERSHAW KNIVES	Kershaw Knives	CUTLERY	Cutlery>Autos	BLACKWASH\|NULL\|NULL	1	59.99	0	59.99	91156-DEFAULT-l.jpg	59.99	91156-DEFAULT-m.jpg	LINK GRAY ALUMINUM BLACKWASH	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]	1	50-to-100	0.00	[empty string]	Link Gray Aluminum Blackwash	[empty string]	[empty string]	N	59.99	59.99	[empty string]	91156-DEFAULT-s.jpg	[empty string]	1000	1776GRYBW	308025	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	kershaw-knives/link-gray-aluminum-blackwash-308025	1
16	[empty string]	BUCK KNIVES	Buck Knives	CUTLERY	Cutlery>Autos	[empty string]	0	139.99	0	139.99	[empty string]	139.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]	2	100-to-150	0.00	[empty string]	112 Folding Hunter Automatic	[empty string]	[empty string]	N	139.99	139.99	AUTO	[empty string]	[empty string]	1000	0112BRSA	308401	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	buck-knives/112-folding-hunter-automatic-308401	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]	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]	1	150-to-200	0.00	[empty string]	112auto Elite Folding Hunter Automatic	[empty string]	[empty string]	N	179.99	179.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
18	ODGREEN	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	ODGREEN\|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]	8	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	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
19	ODGREEN	BUCK KNIVES	Buck Knives	CUTLERY	Cutlery>Autos	ODGREEN\|NULL\|NULL	0	174.99	0	174.99	[empty string]	174.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]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	122337 Impact Tactical Auto O.d.green	[empty string]	[empty string]	N	174.99	174.99	[empty string]	[empty string]	[empty string]	1000	0898GRS1	313254	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	buck-knives/122337-impact-tactical-auto-o-d-green-313254	1
20	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]	1	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
21	[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]	2	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
22	[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]	1	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
23	[empty string]	KERSHAW KNIVES	Kershaw Knives	CUTLERY	Cutlery>Autos	[empty string]	0	159.99	0	159.99	[empty string]	159.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]	8	150-to-200	0.00	[empty string]	Launch 7 Auto Knife	[empty string]	[empty string]	N	159.99	159.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
24	[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
25	[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
26	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
27	RFP,BFP	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	RFP\|NULL\|NULL,BFP\|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]	12	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
28	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]	20	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	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
29	NYPDBLUE,ZOMBIEGREEN,PURPLE	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	NYPDBLUE\|NULL\|NULL,ZOMBIEGREEN\|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]	3	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
30	BLACK,PURPLE,TIFFBLUE	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	BLACK\|NULL\|NULL,PURPLE\|NULL\|NULL,TIFFBLUE\|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]	13	100-to-150	0.00	[empty string]	Sidewinder Otf D2 Steel Knife	[empty string]	[empty string]	N	139.99	179.99	LARGE,SMALL	[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
31	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]	3	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
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	AUTOS	[empty string]	spyderco/autonomy-2-plain-edge-g10-black-folding-knife-343498	1
33	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]	3	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
34	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]	4	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
35	[empty string]	BUCK KNIVES	Buck Knives	CUTLERY	Cutlery>Autos	[empty string]	0	199.99	0	199.99	[empty string]	199.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]	1	150-to-200	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	199.99	199.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
36	[empty string]	BUCK KNIVES	Buck Knives	CUTLERY	Cutlery>Autos	[empty string]	0	199.99	0	199.99	[empty string]	199.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	150-to-200	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	199.99	199.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
37	BLACK/BLACK	PROTECH KNIVES	Protech Knives	CUTLERY	Cutlery>Autos	BLACK/BLACK\|NULL\|NULL	0	259.99	0	259.99	[empty string]	259.99	[empty string]	TR-4 AUTO FOLDING KNIFE BON B D2	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]	SELL THRU	[empty string]	[empty string]	[empty string]	2	250-to-300	0.00	[empty string]	Tr-4 Auto Folding Knife Bon B D2	[empty string]	[empty string]	N	259.99	259.99	4IN	[empty string]	[empty string]	1000	TR-4.3 D2	355341	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	protech-knives/tr-4-auto-folding-knife-bon-b-d2-355341	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

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

Sog- Tac Auto Tactical Drop Point Blacktini

Auto Elite110 Hunter Fully Automatic

Mini- Infidel Black Otf Full Auto Knife

Tr- 5 Auto Folding 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

Link Gray Aluminum Blackwash

112 Folding Hunter Automatic

112auto Elite Folding Hunter Automatic

Fang Fs- 3 Otf Auto Knife D2 Steel

122337 Impact Tactical Auto O.D.Green

Empower Auto Black/Black Fine Edge

Launch 8 Stiletto Auto Knife

Launch 9 Auto Knife

Launch 7 Auto Knife

Strat Ops Auto Usa Made Knife