Jay's Sporting Goods

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	FAMLIST	HASIMAGE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SOLD	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	UPC	URL	VENDOR_INTEGRATE_ID
1	TIFFBLUE,PURPLE,BLACK,CARFI,PINK,NYPDBLUE,PLUM,STONEWASH,ODGREEN,ORANGE,RED	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	TIFFBLUE\|NULL\|NULL,PURPLE\|NULL\|NULL,BLACK\|NULL\|NULL,CARFI\|NULL\|NULL,PINK\|NULL\|NULL,NYPDBLUE\|NULL\|NULL,PLUM\|NULL\|NULL,STONEWASH\|NULL\|NULL,ODGREEN\|NULL\|NULL,ORANGE\|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	ADULT SIGNATURE	[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]	83	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	85637-DEFAULT-s.jpg	[empty string]	1000	CTK-1 D2	307025	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	cobratec-knives/ctk-1-otf-auto-knife-d2-steel-307025	1
2	BLACK,CARFI,GREY,ODGREEN	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	BLACK\|NULL\|NULL,CARFI\|NULL\|NULL,GREY\|NULL\|NULL,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	ADULT SIGNATURE	[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]	40	100-to-150	0.00	[empty string]	Fang Fs-3 Otf Auto Knife D2 Steel	[empty string]	[empty string]	N	109.99	109.99	LARGE,SMALL	85639-DEFAULT-s.jpg	[empty string]	1000	FS-3D2	312853	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	cobratec-knives/fang-fs-3-otf-auto-knife-d2-steel-312853	1
3	BFP,RFP	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	BFP\|NULL\|NULL,RFP\|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	ADULT SIGNATURE	[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]	13	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	EMPTY	[empty string]	cobratec-knives/fang-fs-3-otf-auto-knife-cerakoted2-steel-323542	1
4	BRONZE,COBRASKIN,SAND,BLUE,AFLAG,RED	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	BRONZE\|NULL\|NULL,COBRASKIN\|NULL\|NULL,SAND\|NULL\|NULL,BLUE\|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	ADULT SIGNATURE	[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]	23	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	EMPTY	[empty string]	cobratec-knives/ctk-1-otf-auto-knife-cerakote-d2-steel-323543	1
5	BLACK,CARBON,PURPLE,TIFFBLUE,ZOMBIEGREEN,GREY,NYPDBLUE,ODGREEN	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	BLACK\|NULL\|NULL,CARBON\|NULL\|NULL,PURPLE\|NULL\|NULL,TIFFBLUE\|NULL\|NULL,ZOMBIEGREEN\|NULL\|NULL,GREY\|NULL\|NULL,NYPDBLUE\|NULL\|NULL,ODGREEN\|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	ADULT SIGNATURE	[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]	40	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	EMPTY	[empty string]	cobratec-knives/lightweight-otf-d2-steel-knife-323544	1
6	BLACK,TIFFBLUE,PURPLE,GREEN	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	BLACK\|NULL\|NULL,TIFFBLUE\|NULL\|NULL,PURPLE\|NULL\|NULL,GREEN\|NULL\|NULL	1	179.99	1	139.99	97700-DEFAULT-l.jpg	179.99	97700-DEFAULT-m.jpg	SIDEWINDER OTF D2 STEEL KNIFE	N	9 BILL	[empty string]	[empty string]	[empty string]	A	ADULT SIGNATURE	[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]	27	100-to-150	0.00	[empty string]	Sidewinder Otf D2 Steel Knife	<p>This knife features a pocket clip, a glass breaker for emergencies and includes a nylon sheath. </p> <p>Small:</p> <ul> <li>2.5 ounces</li> <li>Dual Action OTF</li> <li>2.5 inch D2 Steel Blade</li> <li>4 inch Aviation Aluminum Handle</li> <li>7 inches in total length with glass breaker</li> </ul> <p>Large: </p> <ul> <li>4.0 ounces</li> <li>Dual Action OTF</li> <li>3.5 inch D2 Steel Blade</li> <li>4.5 inch T6061 Aircraft Aluminum handle</li> <li>8.875 inches in total length with glass breaker</li> </ul>	[empty string]	N	139.99	179.99	SMALL,LARGE	97700-DEFAULT-s.jpg	[empty string]	1000	SIDEWINDER	323545	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	cobratec-knives/sidewinder-otf-d2-steel-knife-323545	1
7	WETHEPEOPLE,COMETAKE,DONTTREAD	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	WETHEPEOPLE\|NULL\|NULL,COMETAKE\|NULL\|NULL,DONTTREAD\|NULL\|NULL	1	159.99	0	159.99	97816-DEFAULT-l.jpg	159.99	97816-DEFAULT-m.jpg	FANG FS-3 OTF AMERICAN PRIDE SERIES	N	9 BILL	[empty string]	[empty string]	[empty string]	A	ADULT SIGNATURE	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	19	150-to-200	0.00	[empty string]	Fang Fs-3 Otf American Pride Series	[empty string]	[empty string]	N	159.99	159.99	MEDIUM	97816-DEFAULT-s.jpg	[empty string]	1000	FS3AMERPRIDE	366402	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	cobratec-knives/fang-fs-3-otf-american-pride-series-366402	1
8	[empty string]	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	[empty string]	1	49.99	0	49.99	97702-DEFAULT-l.jpg	49.99	97702-DEFAULT-m.jpg	BLACK DIABLO SIDE BUTTON AUTO	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	ADULT SIGNATURE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	25	25-to-50	0.00	[empty string]	BLACK DIABLO	<p>The Diablo is a side button folding automatic. It comes equipped with G-10 scales and a black stonewash D2 steel blade. Has a sliding safety switch to prevent accidental discharge.</p> <ul> <li>Side Switch</li> <li>Safety Switch to prevent accidental discharge</li> <li>Weighs 4 0z</li> <li>Blade 3.5 inches</li> <li>Handle 4.75 inches</li> <li>Overall Length 8.25 inches</li> </ul>	[empty string]	N	49.99	49.99	[empty string]	97702-DEFAULT-s.jpg	[empty string]	1000	BLKDIABLOAUTO	366403	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	cobratec-knives/black-diablo-366403	1
9	[empty string]	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	[empty string]	1	49.99	0	49.99	97703-DEFAULT-l.jpg	49.99	97703-DEFAULT-m.jpg	TAN DIABLO SINDE BUTTON AUTO	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	ADULT SIGNATURE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	21	25-to-50	0.00	[empty string]	TAN DIABLO	<p>The Diablo is a side button folding automatic. It comes equipped with G-10 scales and a black stonewash D2 steel blade. Has a sliding safety switch to prevent accidental discharge.</p> <ul> <li>Side Switch</li> <li>Safety Switch to prevent accidental discharge</li> <li>Weighs 4 0z</li> <li>Blade 3.5 inches</li> <li>Handle 4.75 inches</li> <li>Overall Length 8.25 inches</li> </ul>	[empty string]	N	49.99	49.99	[empty string]	97703-DEFAULT-s.jpg	[empty string]	1000	TANDIABLOAUTO	366404	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	cobratec-knives/tan-diablo-366404	1
10	TAN,BLACK,OD	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	TAN\|NULL\|NULL,BLACK\|NULL\|NULL,OD\|NULL\|NULL	1	59.99	0	59.99	97704-DEFAULT-l.jpg	59.99	97704-DEFAULT-m.jpg	RYKER OTF AUTO KNIFE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	ADULT SIGNATURE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	20	50-to-100	0.00	[empty string]	Ryker Otf Auto Knife	<p>The Ryker is a side button folding automatic. It comes equipped with G-10 scales, a black stonewash D2 steel blade, RH pocket clip and a sliding safety switch to prevent accidental discharge.</p> <p> </p> <ul> <li>Side Switch</li> <li>Safety Switch to prevent accidental discharge</li> <li>Weighs 5.9 0z</li> <li>Blade 3.75 inches</li> <li>Handle 5 inches</li> <li>Overall Length 8.75 inches</li> </ul>	[empty string]	N	59.99	59.99	[empty string]	97704-DEFAULT-s.jpg	[empty string]	1000	BAFRYK	367874	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	cobratec-knives/ryker-otf-auto-knife-367874	1
11	GREY	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	GREY\|NULL\|NULL	1	129.99	0	129.99	97705-DEFAULT-l.jpg	129.99	97705-DEFAULT-m.jpg	STEALTH GREY CM154 AUTO	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	ADULT SIGNATURE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	STEALTH GREY	<ul> <li>Weight: 1.5 OZ</li> <li>Overall Length: 5.75"</li> <li>Blade Length: 2.30"</li> <li>CNC Machined Handle Length: 3.45"</li> <li>Blade Material: 154CM Steel Blade</li> <li>Colors: Black, Grey and Blue</li> </ul>	[empty string]	N	129.99	129.99	[empty string]	97705-DEFAULT-s.jpg	[empty string]	1000	GRYSTCM154DNS	367876	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	cobratec-knives/stealth-grey-367876	1
12	PURPLE,ORANGE,BLUE	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	PURPLE\|NULL\|NULL,ORANGE\|NULL\|NULL,BLUE\|NULL\|NULL	1	69.99	0	69.99	97706-DEFAULT-l.jpg	69.99	97706-DEFAULT-m.jpg	CALI 928 OTF AUTO	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	ADULT SIGNATURE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	14	50-to-100	0.00	[empty string]	Cali 928 Otf Auto	<p>The California OTF comes standard with a stonewashed D2 steel blade, pocket clip and pouch. </p> <p> </p> <ul> <li>Weight: 1.3 oz</li> <li>Blade Length: 1.75"</li> <li>Handle Length: 3"</li> <li>Total Length: 4.75"</li> <li>Anodized Handle</li> <li>Pocket Clip</li> </ul>	[empty string]	N	69.99	69.99	[empty string]	97706-DEFAULT-s.jpg	[empty string]	1000	CALI928	367877	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	cobratec-knives/cali-928-otf-auto-367877	1
13	GREY,BLUE,ORANGE,PURPLE,BLACK	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	GREY\|NULL\|NULL,BLUE\|NULL\|NULL,ORANGE\|NULL\|NULL,PURPLE\|NULL\|NULL,BLACK\|NULL\|NULL	1	69.99	0	69.99	97707-DEFAULT-l.jpg	69.99	97707-DEFAULT-m.jpg	CALI 929 OTF AUTO	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	ADULT SIGNATURE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	14	50-to-100	0.00	[empty string]	Cali 929 Otf Auto	<p>The California OTF comes standard with a stonewashed D2 steel blade, pocket clip and pouch.</p> <p> </p> <ul> <li>Weight: 1.5 oz</li> <li>Blade Length: 1.75"</li> <li>Handle Length: 3"</li> <li>Total Length: 4.75"</li> <li>Anodized Handle</li> <li>Pocket Clip</li> </ul>	[empty string]	N	69.99	69.99	[empty string]	97707-DEFAULT-s.jpg	[empty string]	1000	CALI929	367878	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	cobratec-knives/cali-929-otf-auto-367878	1
14	CF	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	CF\|NULL\|NULL	1	79.99	0	79.99	97815-DEFAULT-l.jpg	79.99	97815-DEFAULT-m.jpg	CALI 952 OTF AUTO CARBON FIBER	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	ADULT SIGNATURE	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	50-to-100	0.00	[empty string]	Cali 952 Otf Auto Carbon Fiber	[empty string]	[empty string]	N	79.99	79.99	[empty string]	97815-DEFAULT-s.jpg	[empty string]	1000	CALIE952	367879	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	cobratec-knives/cali-952-otf-auto-carbon-fiber-367879	1
15	BLACK	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	BLACK\|NULL\|NULL	1	159.99	0	159.99	97708-DEFAULT-l.jpg	159.99	97708-DEFAULT-m.jpg	ENFORCER M390 AUTO	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	ADULT SIGNATURE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	150-to-200	0.00	[empty string]	SMALL ENFORCER BLACK	<ul> <li>Weight: 1.5 oz</li> <li>Blade Length: 2.25"</li> <li>Handle Length: 3.75"</li> <li>Total Length: 6.00" including glass breaker</li> </ul>	[empty string]	N	159.99	159.99	SMALL	97708-DEFAULT-s.jpg	[empty string]	1000	SCTEBLKM390DNS	370588	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	cobratec-knives/small-enforcer-black-370588	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter