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]	BENCHMADE KNIVES	Benchmade Knives	CUTLERY	Cutlery>Autos	[empty string]	0	389.99	0	389.99	[empty string]	389.99	[empty string]	MINI-INFIDEL 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]	2012	[empty string]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	2	350-to-400	0.00	[empty string]	Mini-infidel Otf Full Auto Knife	<p>In addition to the incredibly stable, fast action and the rugged, pure tactical nature of the knife, the Infidel has a cool factor that is hard to describe without physically experiencing it. MOLLE compatible. </p> <p> </p> <p><span style=`color: rgb(255, 0, 0);`><span style=`font-size: small;`><strong>NOTE:  WE WILL NOT SHIP AUTOMATICS OUTSIDE THE STATE OF MICHIGAN </strong></span></span></p> <p> </p> <p> </p> <p> </p> <p><strong>PRODUCT FEATURES:</strong></p> <p>-Blade Edge:  Plain</p> <p> </p> <p>-Blade Finish/Color: Satin</p> <p> </p> <p>-Blade Style/Shape:  Double-Edge Dagger</p> <p> </p> <p>-Clip Type:  Deep-Carry, Malice Clip (MOLLE Compatible)</p> <p> </p> <p>-Clip Position:  Tip-Down</p> <p> </p> <p>-Glass Breaker:  Yes</p> <p> </p> <p>-Handle Material:  6061-T6 Aluminum</p> <p> </p> <p>-Lanyard Hole:  No</p> <p> </p> <p>-MOLLE Compatible:  Yes</p> <p> </p> <p>-Sheath Type:  Cordura</p> <p> </p> <p>-Use:  Tactical</p>	[empty string]	N	389.99	389.99	AUTO	[empty string]	[empty string]	1000	3350	149791	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	benchmade-knives/mini-infidel-otf-full-auto-knife-149791	1
2	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]	3	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
3	[empty string]	BENCHMADE KNIVES	Benchmade Knives	CUTLERY	Cutlery>Autos	[empty string]	0	179.99	0	179.99	[empty string]	179.99	[empty string]	CASBAH 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	150-to-200	0.00	[empty string]	Casbah Fully Automatic	[empty string]	[empty string]	N	179.99	179.99	AUTO	[empty string]	[empty string]	1000	4400BK	290055	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	benchmade-knives/casbah-fully-automatic-290055	1
4	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]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2017	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	7	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
5	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]	4	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
6	SPIDERWEB,WINTER,BLACK/BLACK	PROTECH KNIVES	Protech Knives	CUTLERY	Cutlery>Autos	SPIDERWEB\|NULL\|NULL,WINTER\|NULL\|NULL,BLACK/BLACK\|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]	6	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
7	BLACK,ODGREEN,CARFI	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	BLACK\|NULL\|NULL,ODGREEN\|NULL\|NULL,CARFI\|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]	20	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
8	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]	[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]	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
9	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]	11	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
10	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]	4	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
11	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
12	[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]	1	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
13	BLACK	BUCK KNIVES	Buck Knives	CUTLERY	Cutlery>Autos	BLACK\|NULL\|NULL	0	174.99	0	174.99	[empty string]	174.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]	5	150-to-200	0.00	[empty string]	12335 Impact Tactical Auto Armor Black	[empty string]	[empty string]	N	174.99	174.99	[empty string]	[empty string]	[empty string]	1000	0898BLS1	313252	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	buck-knives/12335-impact-tactical-auto-armor-black-313252	1
14	COYOTETAN	BUCK KNIVES	Buck Knives	CUTLERY	Cutlery>Autos	COYOTETAN\|NULL\|NULL	0	174.99	0	174.99	[empty string]	174.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]	[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]	12336 Impact Tactical Auto Coyote Tan	[empty string]	[empty string]	N	174.99	174.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
15	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]	[empty string]	[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
16	[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]	[empty string]	[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
17	[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]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	7	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
18	[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]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	5	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
19	STONEWASH	BOKER USA	Boker Usa	CUTLERY	Cutlery>Autos	STONEWASH\|NULL\|NULL	0	299.99	0	299.99	[empty string]	299.99	[empty string]	USA OTF STONEWASH	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]	1	250-to-300	0.00	[empty string]	Usa Otf Stonewash	[empty string]	[empty string]	N	299.99	299.99	[empty string]	[empty string]	[empty string]	1000	06EX260	319298	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	boker-usa/usa-otf-stonewash-319298	1
20	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
21	BFP,RFP,LRFDP	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	BFP\|NULL\|NULL,RFP\|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]	4	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
22	SAND,BRONZE,AFLAG,COBRASKIN	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	SAND\|NULL\|NULL,BRONZE\|NULL\|NULL,AFLAG\|NULL\|NULL,COBRASKIN\|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]	7	100-to-150	0.00	[empty string]	Ctk-1 Otf Auto Knife Cerakote D2 Steel	[empty string]	[empty string]	N	149.99	169.99	SMALL,LARGE,MEDIUM	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
23	GREY,BLACK,CARBON,NYPDBLUE	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	GREY\|NULL\|NULL,BLACK\|NULL\|NULL,CARBON\|NULL\|NULL,NYPDBLUE\|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]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	6	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
24	BLACK	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	BLACK\|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]	[empty string]	[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]	Sidewinder Otf D2 Steel Knife	[empty string]	[empty string]	N	139.99	179.99	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
25	TIFFBLUE	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	TIFFBLUE\|NULL\|NULL	1	69.99	0	69.99	86621-DEFAULT-l.jpg	69.99	86621-DEFAULT-m.jpg	OTFTACTICAL PEN/ 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]	2019	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Otftactical Pen/ Knife	[empty string]	[empty string]	N	69.99	69.99	[empty string]	86621-DEFAULT-s.jpg	[empty string]	1000	OTF PEN	323546	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	cobratec-knives/otftactical-pen-knife-323546	1
26	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]	[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]	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
27	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]	[empty string]	[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 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
28	[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]	[empty string]	[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	0591BKS	348646	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	buck-knives/paradigm-shift-auto-black-g10-s35vn-348646	1
29	[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]	[empty string]	[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
30	[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]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	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
31	[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]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	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
32	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]	[empty string]	[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
33	BLACK/BLACK	PROTECH KNIVES	Protech Knives	CUTLERY	Cutlery>Autos	BLACK/BLACK\|NULL\|NULL	0	219.99	0	219.99	[empty string]	219.99	[empty string]	TR-3 AUTO FOLDING KNIFE D2 BLACK ON 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]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	200-to-250	0.00	[empty string]	Tr-3 Auto Folding Knife D2 Black On Black	[empty string]	[empty string]	N	219.99	219.99	3.5IN	[empty string]	[empty string]	1000	TR-3X1D2	355338	EMPTY	EMPTY	EMPTY	0	0	0	AUTOS	[empty string]	protech-knives/tr-3-auto-folding-knife-d2-black-on-black-355338	1
34	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]	[empty string]	[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

Mini- Infidel Otf Full Auto Knife

Presidio Ii Axis Fully Automatic

Casbah Fully Automatic

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

Propel Down Range Auto Tan G10

Tr- 5 Auto Folding Knife

Ctk- 1 Otf Auto Knife D2 Steel

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

Auto Launch 4 Black

Auto Launch 6 Black

Link Gray Aluminum Blackwash

112 Folding Hunter Automatic

12335 Impact Tactical Auto Armor Black

12336 Impact Tactical Auto Coyote Tan

Empower Auto Black/Black Fine Edge

Launch 8 Stiletto Auto Knife

Launch 7 Auto Knife

Tac Ops Auto Usa Made Knife

Usa Otf Stonewash

Usa Otf Auto Coyote

Fang Fs- 3 Otf Auto Knife Cerakoted2 Steel

Ctk- 1 Otf Auto Knife Cerakote D2 Steel

Lightweight Otf D2 Steel Knife

Sidewinder Otf D2 Steel Knife