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	EDG	SCENTLOK	Scentlok	CLOTHING	Clothing>Mens>Accessories>Gloves	EDG\|NULL\|NULL	0	44.99	0	44.99	[empty string]	44.99	[empty string]	POP TOP GLOVE	N	6 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Pop-top Glove - Realtree Xtra	Don`t let a pair of bulkly gloves ruin a shot of a lifetime. The ScentLok Pop-Top gloves keep your hands exceptionally warm and allows for extreme dexterity when shooting and features a magnetic closure and Realtree Xtra Camo.<br/>	[empty string]	N	44.99	44.99	M	[empty string]	[empty string]	1000	2110034	151663	ACCESSORIES	GLOVES	EMPTY	0	0	0	MENS	[empty string]	scentlok/pop-top-glove-151663	1
2	ELV2	SITKA GEAR	Sitka Gear	CLOTHING	Clothing>Mens>Accessories>Gloves	ELV2\|NULL\|NULL	0	89	0	89	[empty string]	89	[empty string]	STRATUS GLOVE	N	6 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	6	50-to-100	0.00	[empty string]	Stratus Glove - Elevated Ii	<p>The Stratus Glove will keep your fingers warm and agile when the moment of truth strikes. The 100% windproof WINDSTOPPER membrane shields a micro-grid fleece lining to keep your digits comfortable while the stretch-woven shell moves with you for optimal dexterity. With a textured oil tac leather palm and goat leather thumb, pointer and middle finger, the Stratus glove will become your best friend for long days in the blind.</p> <p> </p> <p> </p> <p><strong>PRODUCT FEATURES: </strong></p> <p> </p> <p>-Complete Windproof Protection:  A 100% windproof GORE WINDSTOPPER membrane with a soft micro-grid fleece liner seals out the cold.</p> <p> </p> <p>-Articulated Fingers:  The articulated patterning provides ultimate dexterity and precision.</p> <p> </p> <p>-Pittard`s Oiltac Leather Palms:  High-grip leather palm gives you complete control of your weapon.</p> <p> </p> <p>-Leather Pull:  Durable leather pull provides an easy on/off.</p> <p> </p> <p>-WINDSTOPPER Technology:  WINDSTOPPER products shelter hunters from the adverse effects of bone-chilling winds. The WINDSTOPPER membrane works with our base layers to prevent overheating and perspiration build-up by allowing moisture vapor to easily escape.</p> <p> </p>	[empty string]	N	89	89	L,XL	[empty string]	[empty string]	1000	90093	253435	ACCESSORIES	GLOVES	EMPTY	0	0	0	MENS	[empty string]	sitka-gear/stratus-glove-253435	1
3	TAN	SITKA GEAR	Sitka Gear	CLOTHING	Clothing>Mens>Accessories>Gloves	TAN\|NULL\|NULL	0	99	0	99	[empty string]	99	[empty string]	GUNNER WS GLOVE	N	6 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	7	50-to-100	0.00	[empty string]	Gunner Ws Glove	<p>We built the Gunner WINDSTOPPER Glove to maximize trigger feel while keeping your fingers from going numb late into the season. Durable, supple and dexterous, the goatskin leather outer is fixed to a super smooth, seamless WINDSTOPPER liner. The stretch-woven forefinger gives you precise trigger control, while the reinforced Pusher Thumb withstands pushing thousands of rounds into the chamber.  </p> <p> </p> <p> </p> <p><strong>PRODUCT FEATURES:</strong></p> <p> </p> <p>-Adjustable Closure:  The quiet velcro closure offers a custom fit and further seals out the elements.</p> <p> </p> <p>-WINDSTOPPER Technology:  WINDSTOPPER products shelter hunters from the adverse effects of bone-chilling winds. The WINDSTOPPER membrane works with our base layers to prevent overheating and perspiration build-up by allowing moisture vapor to easily escape.</p> <p> </p>	[empty string]	N	99	99	M,L,XL	[empty string]	[empty string]	1000	90162	270673	ACCESSORIES	GLOVES	EMPTY	0	0	0	MENS	[empty string]	sitka-gear/gunner-ws-glove-270673	1
4	EDG	SCENTLOK	Scentlok	CLOTHING	Clothing>Mens>Accessories>Gloves	EDG\|NULL\|NULL	0	49.99	0	49.99	[empty string]	49.99	[empty string]	WATERPROOF INSUL GLOVE	N	6 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	WATERPROOF	FALL	[empty string]	2020	[empty string]	[empty string]	DISC	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Waterproof Insul Glove	[empty string]	[empty string]	N	49.99	49.99	M	[empty string]	[empty string]	1000	2120033	285367	ACCESSORIES	GLOVES	EMPTY	0	0	0	MENS	[empty string]	scentlok/waterproof-insul-glove-285367	1
5	SBAP	SITKA GEAR	Sitka Gear	CLOTHING	Clothing>Mens>Accessories>Gloves	SBAP\|NULL\|NULL	0	40	0	40	[empty string]	40	[empty string]	TRAVERSE GLOVE	N	6 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	MENS	DISC	[empty string]	[empty string]	[empty string]	8	25-to-50	0.00	[empty string]	Traverse Glove	[empty string]	[empty string]	N	40	40	L,XL,M	[empty string]	[empty string]	1000	90177	316454	ACCESSORIES	GLOVES	EMPTY	0	0	0	MENS	[empty string]	sitka-gear/traverse-glove-316454	1
6	EXCP,GILA	SCENTLOK	Scentlok	CLOTHING	Clothing>Mens>Accessories>Gloves	EXCP\|NULL\|NULL,GILA\|NULL\|NULL	0	69.99	0	69.99	[empty string]	69.99	[empty string]	BE1 FORTRESS GLOVE	N	6 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	9	50-to-100	0.00	[empty string]	Be1 Fortress Glove	[empty string]	[empty string]	N	69.99	69.99	L,M	[empty string]	[empty string]	1000	2110632	337475	ACCESSORIES	GLOVES	EMPTY	0	0	0	MENS	[empty string]	scentlok/be1-fortress-glove-337475	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts618 ORDER BY sortposition asc

Clothing

Sort By:

Items per page:

Close

Filter By

Size

L
M
XL

Filter