Jay's Sporting Goods

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	FAMLIST	HASIMAGE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SOLD	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	UPC	URL	VENDOR_INTEGRATE_ID
1	[empty string]	WICKED TREE GEAR	Wicked Tree Gear	HUNTING	Hunting>Treestands>Accessories	[empty string]	1	19.99	0	19.99	78348-DEFAULT-l.jpg	19.99	78348-DEFAULT-m.jpg	WICKED TOUGH FOLDING HAND SAW	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	SUMMER	[empty string]	2011	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	64	15-to-20	0.00	[empty string]	Tough Hand Saw	<p>The Wicked Tough hand saw features a cast aluminum handle and hardened locking hardware along with our Wicked high carbon steel blade.</p>	[empty string]	N	19.99	19.99	[empty string]	78348-DEFAULT-s.jpg	[empty string]	1000	WTG-001	135300	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	wicked-tree-gear/wicked-tough-folding-hand-saw-135300	1
2	[empty string]	WICKED TREE GEAR	Wicked Tree Gear	HUNTING	Hunting>Treestands>Accessories	[empty string]	1	9.99	0	9.99	78349-DEFAULT-l.jpg	9.99	78349-DEFAULT-m.jpg	WICKED SAW REPLACEMENT BLADE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2012	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	23	5-to-10	0.00	[empty string]	Hand Saw Replacement Blade	<p>Replacement blades for your Wicked Tough Hand Saws.</p>	[empty string]	N	9.99	9.99	[empty string]	78349-DEFAULT-s.jpg	[empty string]	1000	WTG-002	150487	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	wicked-tree-gear/wicked-saw-replacement-blade-150487	1
3	[empty string]	WICKED TREE GEAR	Wicked Tree Gear	HUNTING	Hunting>Treestands>Accessories	[empty string]	1	9.99	0	9.99	88142-DEFAULT-l.jpg	9.99	88142-DEFAULT-m.jpg	WICKED TREE PACK	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2013	[empty string]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	16	5-to-10	0.00	[empty string]	Wicked Tree Pack	[empty string]	[empty string]	N	9.99	9.99	[empty string]	88142-DEFAULT-s.jpg	[empty string]	1000	WTG-004	162443	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	wicked-tree-gear/wicked-tree-pack-162443	1
4	[empty string]	WICKED TREE GEAR	Wicked Tree Gear	HUNTING	Hunting>Treestands>Accessories	[empty string]	1	19.99	0	19.99	78350-DEFAULT-l.jpg	19.99	78350-DEFAULT-m.jpg	WICKED TOUGH BONE SAW	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2013	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	48	15-to-20	0.00	[empty string]	Tough Utility / Bone Saw	<p>The Wicked Tough Utility/ Bone Saw features a cast aluminum handle and hardened locking hardware along with their Wicked curved style arborist blade to make quick work of cutting even the hardest materials.</p>	[empty string]	N	19.99	19.99	[empty string]	78350-DEFAULT-s.jpg	[empty string]	1000	WTG-007	162444	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	wicked-tree-gear/wicked-tough-bone-saw-162444	1
5	[empty string]	WICKED TREE GEAR	Wicked Tree Gear	HUNTING	Hunting>Treestands>Accessories	[empty string]	0	99.99	0	99.99	[empty string]	99.99	[empty string]	WICKED TOUGH POLE SAW 6FT	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2013	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	5	50-to-100	0.00	[empty string]	Tough Pole Saw - 6 Feet	<p>The finest telescoping pole saw in the world; the Wicked Tough pole saw features a telescoping design which folds down to a compact length for ease of transport.  The high carbon Wicked curved style arborist blade cuts smooth and fast through all types of trees and wood.</p>	[empty string]	N	99.99	99.99	6FT	[empty string]	[empty string]	1000	WTG-009	162445	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	wicked-tree-gear/wicked-tough-pole-saw-6ft-162445	1
6	[empty string]	WICKED TREE GEAR	Wicked Tree Gear	HUNTING	Hunting>Treestands>Accessories	[empty string]	0	129.99	0	129.99	[empty string]	129.99	[empty string]	WICKED TOUGH POLE SAW 12FT	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2013	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	7	100-to-150	0.00	[empty string]	Tough Pole Saw - 12 Feet	<p>The finest telescoping pole saw in the world; the Wicked Tough pole saw features a telescoping design which folds down to a compact length for ease of transport.  The high carbon Wicked curved style arborist blade cuts smooth and fast through all types of trees and wood.</p>	[empty string]	N	129.99	129.99	12FT	[empty string]	[empty string]	1000	WTG-010	162446	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	wicked-tree-gear/wicked-tough-pole-saw-12ft-162446	1
7	[empty string]	WICKED TREE GEAR	Wicked Tree Gear	HUNTING	Hunting>Treestands>Accessories	[empty string]	0	169.99	0	169.99	[empty string]	169.99	[empty string]	WICKED TOUGH POLE SAW 15FT	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2014	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	7	150-to-200	0.00	[empty string]	Tough Pole Saw - 15 Feet	<p>The finest telescoping pole saw in the world; the Wicked Tough pole saw features a telescoping design which folds down to a compact length for ease of transport.  The high carbon Wicked curved style arborist blade cuts smooth and fast through all types of trees and wood.</p>	[empty string]	N	169.99	169.99	15FT	[empty string]	[empty string]	1000	WTG-012	186102	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	wicked-tree-gear/wicked-tough-pole-saw-15ft-186102	1
8	[empty string]	WICKED TREE GEAR	Wicked Tree Gear	HUNTING	Hunting>Treestands>Accessories	[empty string]	0	14.99	0	14.99	[empty string]	14.99	[empty string]	WICKED POLE SAW REPLACEMENT BLADE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2014	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	8	10-to-15	0.00	[empty string]	Pole Saw Replacement Blade	<p>Replacement blades for your Wicked Tough saws.</p>	[empty string]	N	14.99	14.99	[empty string]	[empty string]	[empty string]	1000	WTG-011	186109	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	wicked-tree-gear/wicked-pole-saw-replacement-blade-186109	1
9	[empty string]	WICKED TREE GEAR	Wicked Tree Gear	HUNTING	Hunting>Treestands>Accessories	[empty string]	0	29.99	0	29.99	[empty string]	29.99	[empty string]	WICKED COMBO PACK SAW AND TREE PACK	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SUMMER	[empty string]	2015	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	21	25-to-50	0.00	[empty string]	Tough Combo Pack	<p>Includes the legendary Wicked Tough hand saw as well as the Wicked Tough Tree Pack.</p>	[empty string]	N	29.99	29.99	[empty string]	[empty string]	[empty string]	1000	WTG-003	250542	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	wicked-tree-gear/wicked-combo-pack-saw-and-tree-pack-250542	1
10	[empty string]	WICKED TREE GEAR	Wicked Tree Gear	HUNTING	Hunting>Treestands>Accessories	[empty string]	0	24.99	0	24.99	[empty string]	24.99	[empty string]	WICKED SHEATH COMBO WITH SAW	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	SUMMER	[empty string]	2015	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	26	20-to-25	0.00	[empty string]	Sheath Packs	<p>Sheath Pack includes legendary Wicked Tough hand saw as well as the Wicked Lightweight Sheath.</p>	[empty string]	N	24.99	24.99	[empty string]	[empty string]	[empty string]	1000	WTG-005	250544	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	wicked-tree-gear/wicked-sheath-combo-with-saw-250544	1
11	[empty string]	WICKED TREE GEAR	Wicked Tree Gear	HUNTING	Hunting>Treestands>Accessories	[empty string]	1	99.99	0	99.99	78355-DEFAULT-l.jpg	99.99	78355-DEFAULT-m.jpg	WICKED ULTRA LIGHT POLE SAW 10FT	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	SUMMER	[empty string]	2015	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	14	50-to-100	0.00	[empty string]	Ultra Light Pole Saw - 10 Feet	<p>The ultimate light weight telescoping pole saw featuring a removable saw head which doubles as a hand saw.</p>	[empty string]	N	99.99	99.99	10FT	78355-DEFAULT-s.jpg	[empty string]	1000	WTG-014	250546	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	wicked-tree-gear/wicked-ultra-light-pole-saw-10ft-250546	1
12	[empty string]	WICKED TREE GEAR	Wicked Tree Gear	HUNTING	Hunting>Treestands>Accessories	[empty string]	0	119.99	0	119.99	[empty string]	119.99	[empty string]	WICKED ULTRA LIGHT POLE SAW 14FT	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SUMMER	[empty string]	2015	[empty string]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	20	100-to-150	0.00	[empty string]	Wicked Ultra Light Pole Saw 14ft	[empty string]	[empty string]	N	119.99	119.99	14FT	[empty string]	[empty string]	1000	WTG-015	250549	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	wicked-tree-gear/wicked-ultra-light-pole-saw-14ft-250549	1
13	[empty string]	WICKED TREE GEAR	Wicked Tree Gear	HUNTING	Hunting>Treestands>Accessories	[empty string]	0	9.99	0	9.99	[empty string]	9.99	[empty string]	WICKED TOUGH POLE SAW UTILITY HOOK	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	SUMMER	[empty string]	2015	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	15	5-to-10	0.00	[empty string]	Wicked Tough Pole Saw Utility Hook	[empty string]	[empty string]	N	9.99	9.99	HOOK	[empty string]	[empty string]	1000	WTG-016	250551	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	wicked-tree-gear/wicked-tough-pole-saw-utility-hook-250551	1
14	[empty string]	WICKED TREE GEAR	Wicked Tree Gear	HUNTING	Hunting>Treestands>Accessories	[empty string]	1	9.99	0	9.99	78375-DEFAULT-l.jpg	9.99	78375-DEFAULT-m.jpg	WICKED REPLACEMENT BONE BLADE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	SUMMER	[empty string]	2015	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	35	5-to-10	0.00	[empty string]	Utility / Bone Saw Replacement Blade	<p>Replacement blades for your Wicked Tough Hand Saws.</p>	[empty string]	N	9.99	9.99	BONEBLADE	78375-DEFAULT-s.jpg	[empty string]	1000	WTG-008	250572	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	wicked-tree-gear/wicked-replacement-bone-blade-250572	1
15	[empty string]	WICKED TREE GEAR	Wicked Tree Gear	HUNTING	Hunting>Treestands>Accessories	[empty string]	1	14.99	0	14.99	78373-DEFAULT-l.jpg	14.99	78373-DEFAULT-m.jpg	WICKED HAND PRUNER	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]	2018	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	55	10-to-15	0.00	[empty string]	Hand Pruner	<p>Wicked Tough Hand Pruner features an aluminum frame and ergonomic yellow rubber grip.</p>	[empty string]	N	14.99	14.99	[empty string]	78373-DEFAULT-s.jpg	[empty string]	1000	WTG-017	299188	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	wicked-tree-gear/wicked-hand-pruner-299188	1
16	[empty string]	WICKED TREE GEAR	Wicked Tree Gear	HUNTING	Hunting>Treestands>Accessories	[empty string]	0	29.99	0	29.99	[empty string]	29.99	[empty string]	WICKED BEAST LARGE HANDS SAW	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]	2018	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	28	25-to-50	0.00	[empty string]	Wicked Beast Large Hands Saw	[empty string]	[empty string]	N	29.99	29.99	[empty string]	[empty string]	[empty string]	1000	WTG-021	299189	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	wicked-tree-gear/wicked-beast-large-hands-saw-299189	1
17	[empty string]	WICKED TREE GEAR	Wicked Tree Gear	HUNTING	Hunting>Treestands>Accessories	[empty string]	0	59.99	0	59.99	[empty string]	59.99	[empty string]	WICKED STICK 3FT POLE SAW	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2018	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	8	50-to-100	0.00	[empty string]	Wicked Stick 3ft Pole Saw	[empty string]	[empty string]	N	59.99	59.99	3FT	[empty string]	[empty string]	1000	WTG-013	299555	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	wicked-tree-gear/wicked-stick-3ft-pole-saw-299555	1
18	ULTRALIGHT	WICKED TREE GEAR	Wicked Tree Gear	HUNTING	Hunting>Treestands>Accessories	ULTRALIGHT\|NULL\|NULL	0	9.99	0	9.99	[empty string]	9.99	[empty string]	WICKED UTILITY HOOK FOR UL POLE SAW	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2018	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	9	5-to-10	0.00	[empty string]	Utility Hook For Ultra Light Pole Saw	<p>This Utility Hook is a big hook for pulling & pushing branches, rope hook for hoisting safety lines, and an incredible accessory for any Wicked Tough Pole Saw.</p>	[empty string]	N	9.99	9.99	[empty string]	[empty string]	[empty string]	1000	WTG-019	299556	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	wicked-tree-gear/wicked-utility-hook-for-ul-pole-saw-299556	1
19	[empty string]	WICKED TREE GEAR	Wicked Tree Gear	HUNTING	Hunting>Treestands>Accessories	[empty string]	0	5.99	0	5.99	[empty string]	5.99	[empty string]	WICKED SHEATH FOR HAND PRUNER	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2018	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	34	5-to-10	0.00	[empty string]	Wicked Sheath For Hand Pruner	[empty string]	[empty string]	N	5.99	5.99	[empty string]	[empty string]	[empty string]	1000	WTG-017S	299557	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	wicked-tree-gear/wicked-sheath-for-hand-pruner-299557	1
20	[empty string]	WICKED TREE GEAR	Wicked Tree Gear	HUNTING	Hunting>Treestands>Accessories	[empty string]	0	7.99	0	7.99	[empty string]	7.99	[empty string]	WICKED LIGHT WEIGHT SHEATH	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2018	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	16	5-to-10	0.00	[empty string]	Lightweight Sheath	<p>Heavy duty canvas sheath holds your Wicked Tough hand saw or bone saw during transport.</p>	[empty string]	N	7.99	7.99	[empty string]	[empty string]	[empty string]	1000	WTG-006	299558	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	wicked-tree-gear/wicked-light-weight-sheath-299558	1
21	XL	WICKED TREE GEAR	Wicked Tree Gear	HUNTING	Hunting>Treestands>Accessories	XL\|NULL\|NULL	0	19.99	0	19.99	[empty string]	19.99	[empty string]	WICKED XL POLE SAW REPL BLADE 14-15INCH	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2018	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	12	15-to-20	0.00	[empty string]	Wicked Xl Pole Saw Repl Blade 14-15inch	[empty string]	[empty string]	N	19.99	19.99	14/15INCH	[empty string]	[empty string]	1000	WTG-023	299559	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	wicked-tree-gear/wicked-xl-pole-saw-repl-blade-14-15inch-299559	1
22	[empty string]	WICKED TREE GEAR	Wicked Tree Gear	HUNTING	Hunting>Treestands>Accessories	[empty string]	0	39.99	0	39.99	[empty string]	39.99	[empty string]	WICKED MACHETE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Wicked Machete	[empty string]	[empty string]	N	39.99	39.99	[empty string]	[empty string]	[empty string]	1000	WTG-028	333549	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	wicked-tree-gear/wicked-machete-333549	1

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter

Filter By

Price

Categories

Brand

Size

Tough Hand Saw

Hand Saw Replacement Blade

Wicked Tree Pack

Tough Utility/Bone Saw

Tough Pole Saw - 6 Feet

Tough Pole Saw - 12 Feet

Tough Pole Saw - 15 Feet

Pole Saw Replacement Blade

Tough Combo Pack

Sheath Packs

Ultra Light Pole Saw - 10 Feet

Wicked Ultra Light Pole Saw 14ft

Wicked Tough Pole Saw Utility Hook

Utility/Bone Saw Replacement Blade

Hand Pruner

Wicked Beast Large Hands Saw

Wicked Stick 3ft Pole Saw

Utility Hook For Ultra Light Pole Saw

Wicked Sheath For Hand Pruner

Lightweight Sheath

Wicked Xl Pole Saw Repl Blade 14- 15inch

Wicked Machete