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	BLACK	MOBILE WARMING	Mobile Warming	CLOTHING	Clothing>Women>Outerwear>Tops	BLACK\|NULL\|NULL	1	159.99	0	159.99	99844-DEFAULT-l.jpg	159.99	99844-DEFAULT-m.jpg	W ION SHIRT	N	6.1 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2022	[empty string]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	5	150-to-200	0.00	[empty string]	ION SHIRT - WOMEN'S	<p>The women’s Bluetooth-enabled Ion women's heated baselayer shirt is designed for the outdoor enthusiast. From skiing, hunting, and hiking to running or just spending time outdoors, the Ion shirt complements your outerwear to keep a warm core. Its moisture-wicking, warmth, and stretch features make it a versatile baselayer in the winter, or a standalone shirt during outdoor activity in the Spring and Fall.</p> <p> </p> <ul> <li>Stretch Polyester Fabric</li> <li>88% Polyester, 12% Spandex</li> <li>Chafe-free Flat-lock Seams</li> <li>1/4 Zip Pullover</li> <li>Antibacterial & Anti-Static</li> <li>4 Selectable Heat Settings</li> <li>Bluetooth 4.0 Wireless Control</li> <li>Integrated Touch Control Button</li> <li>2x Back Heat Element</li> <li>Powerful Rechargeable Lithium-Ion Battery</li> <li>Up to 10 Hours of Heat Per Charge</li> <li>Battery Rating: 7.4v, 2200mAh</li> <li>Charge Time: 3.5hrs</li> </ul> <p> </p> <ul> <li>Includes:</li> <li>1  Ion Heated Shirt</li> <li>1  7.4volt Lithium-Ion Battery</li> <li>1  AC Battery Charger</li> </ul>	[empty string]	N	159.99	159.99	L,XL,M	99844-DEFAULT-s.jpg	[empty string]	1000	MWWT1301	339147	OUTERWEAR	TOPS	EMPTY	0	0	0	WOMEN	[empty string]	mobile-warming/ion-shirt-women-s-339147	1
2	TRAGILA	SCENTLOK	Scentlok	CLOTHING	Clothing>Women>Outerwear>Tops	TRAGILA\|NULL\|NULL	0	169.99	0	169.99	[empty string]	169.99	[empty string]	W FOREFRONT JACKET	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]	2023	[empty string]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	19	150-to-200	0.00	[empty string]	W Forefront Jacket	[empty string]	[empty string]	N	169.99	169.99	S,M,L,2X,XL	[empty string]	[empty string]	1000	1721010	352631	OUTERWEAR	TOPS	EMPTY	0	0	0	WOMEN	[empty string]	scentlok/w-forefront-jacket-352631	1
3	BLACK	MOBILE WARMING	Mobile Warming	CLOTHING	Clothing>Women>Outerwear>Tops	BLACK\|NULL\|NULL	1	129.99	0	129.99	99837-DEFAULT-l.jpg	129.99	99837-DEFAULT-m.jpg	PEAK VEST	N	6.1 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2022	[empty string]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	PEAK BT VEST	<p>The Fieldsheer powered by Mobile Warming heating technology Peak BT Heated Vest is a low-cost unisex Heated Vest that is favored by many for its light design that allows it to function as either an outer shell or a baselayer. Engineered to keep outside elements out, the Peak Heated Vest is constructed with Windshark, a Fieldsheer fabric technology designed to take on moderate weather, and a comfortable 4-way stretch material.</p> <p> </p> <ul> <li>4-Way Stretch Soft Shell Construction</li> <li>Wind-Shark Protection from Wind, Rain, & Water</li> <li>Sweatsheer Moisture-Wicking Mesh Liner</li> <li>Zapsheer Anti-Static Protection</li> <li>Multi-Zone Heat Zones, 2x Chest & 1x Back</li> <li>Bluetooth-Enabled Wireless Control</li> <li>MW Connect Mobile App Compatible</li> <li>Integrated Waterproof Touch Control Button</li> <li>4 Selectable Heat Settings</li> </ul> <p> </p> <ul> <li>Battery:</li> <li>Powersheer Rechargeable Lithium-Ion Battery (7.4V 2200mAh)</li> <li>Up to 10 Hours of Power Per Charge</li> <li>UL/CE certified</li> <li>USB Cable included</li> <li>Charge Time 3-4 hours</li> </ul> <p> </p> <ul> <li>Includes:</li> <li>1 Peak BT Heated Vest</li> <li>1 Powersheer Rechargeable Lithium-Ion Battery (7.4V 2200mAh)</li> <li>1 Micro USB cable</li> </ul>	[empty string]	N	129.99	129.99	S	99837-DEFAULT-s.jpg	[empty string]	1000	MWUV0701	356353	OUTERWEAR	TOPS	EMPTY	0	0	0	WOMEN	[empty string]	mobile-warming/peak-bt-vest-356353	1
4	BLACK	MOBILE WARMING	Mobile Warming	CLOTHING	Clothing>Women>Outerwear>Tops	BLACK\|NULL\|NULL	1	219.99	0	219.99	99840-DEFAULT-l.jpg	219.99	99840-DEFAULT-m.jpg	W BACK COUNTRY JACKET	N	6.1 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2022	[empty string]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	2	200-to-250	0.00	[empty string]	BACKCOUNTRY HEATED JACKET - WOMEN'S	<p>The Fieldsheer powered by Mobile Warming heating technology Backcountry Women's Heated Jacket made with Primaloft synthetic down offers a low-profile 7.4-volt battery. With Waterpell technology, water bounces off the garment. Primaloft is a down alternative made from recycled materials into ultra-fine insulative fibers. The Backcountry is stylish enough to wear on its own during day-to-day use, but light and amply compressible to also wear as a base layer under your favorite rain or snow Heated Jacket.</p> <p> </p> <ul> <li>Lightweight 100% Nylon Outer Shell</li> <li>100% Primaloft Synthetic Down Polyester-Filled Core</li> <li>100% Polyester Inner Liner with Zapsheer Anti-Static Technology</li> <li>2 Waist Zipper-Close Hand Pockets</li> <li>Internal Storage Pocket</li> <li>Stow-Away Carry Bag</li> <li>Tri-Zone Heating: <ul> <li>Left & Right Chest</li> <li>Upper Back</li> </ul> </li> <li>Bluetooth-Enabled Wireless Control</li> <li>MW Connect Mobile App Compatible</li> <li>Integrated Waterproof Touch Control Button</li> <li>4 Selectable Instant Heat Settings</li> </ul> <p> </p> <ul> <li>Battery:</li> <li>Powersheer Rechargeable Lithium-Ion Battery (7.4V 2200mAh)</li> <li>Up to 10 Hours of Power Per Charge</li> <li>UL/CE certified</li> <li>USB Cable included</li> <li>Charge Time 3-4 hours</li> <li>Footnote: Charge time is based off using a USB-A wall charger that delivers 5V@2.1A</li> </ul> <p> </p> <ul> <li>Includes:</li> <li>1 Backcountry Heated Jacket</li> <li>1 Stow-Away Bag</li> <li>1 Powersheer Rechargable Lithium-Ion Battery (7.4v 2200mAh)</li> <li>1 Micro USB Charging Cable</li> </ul>	[empty string]	N	219.99	219.99	M,XL	99840-DEFAULT-s.jpg	[empty string]	1000	MWWJ0401	356357	OUTERWEAR	TOPS	EMPTY	0	0	0	WOMEN	[empty string]	mobile-warming/backcountry-heated-jacket-women-s-356357	1
5	DKGRY	MOBILE WARMING	Mobile Warming	CLOTHING	Clothing>Women>Outerwear>Tops	DKGRY\|NULL\|NULL	1	249.99	0	249.99	99839-DEFAULT-l.jpg	249.99	99839-DEFAULT-m.jpg	W ADVENTURE JACKET	N	6.1 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2022	[empty string]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	1	200-to-250	0.00	[empty string]	ADVENTURE HEATED JACKET - WOMEN'S	<p>The Adventure Women's Heated Jacket is built to take on the harsher conditions of winter. A 4-way stretch soft outer shell deters rain or snow with its Rainguard waterproof liner. Protect your personal belongings with the chest storage pocket featuring a waterproof zipper.</p> <p> </p> <ul> <li>4-Way Stretch Soft Outer Shell with Waterpell water repellent protection</li> <li>Rainguard integrated waterproof liner</li> <li>Sweatsheer Moisture-Wicking Mesh Liner</li> <li>Three Waterproof Zipper-Close Pockets</li> <li>Internal Storage Pocket</li> <li>Integrated Hood with draw-cord closure</li> <li>Wrist & Waist Closures to keep the heat in</li> <li>Multi-Zone Heat Zones: Left & Right Chest, Upper & Lower Back</li> <li>Bluetooth Enabled Wireless Control</li> <li>MW Connect Mobile App Compatible</li> <li>Integrated Waterproof Touch Control Button to select 4 Heat Settings</li> </ul> <p> </p> <ul> <li>Battery:</li> <li>Powersheer XL 7.4-volt Rechargeable Lithium-Ion Battery (7.4V 4000mAh)</li> <li>USB Charge Port to charge your devices</li> <li>Nightsheer integrated flashlight</li> <li>Up to 13 Hours of Power Per Charge</li> <li>UL/CE certified</li> <li>USB cable included</li> <li>Charge Time 4-5 hours</li> <li>Footnote: Charge time is based off using a USB-A wall charger that delivers 5V@2.1A</li> </ul> <p> </p> <ul> <li>Includes:</li> <li>1 Adventure Heated Jacket</li> <li>1 Powersheer XL Rechargable Lithium-Ion Battery (7.4v 4000mAh)</li> <li>1 Micro USB Charging Cable</li> </ul>	[empty string]	N	249.99	249.99	XL	99839-DEFAULT-s.jpg	[empty string]	1000	MWWJ1022	371921	OUTERWEAR	TOPS	EMPTY	0	0	0	WOMEN	[empty string]	mobile-warming/adventure-heated-jacket-women-s-371921	1
6	BLACK	MOBILE WARMING	Mobile Warming	CLOTHING	Clothing>Women>Outerwear>Tops	BLACK\|NULL\|NULL	1	99	0	99	99838-DEFAULT-l.jpg	99	99838-DEFAULT-m.jpg	SMART THAWDADDY	N	6.1 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2022	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	SMART THAWDADDY 2.0 - UNISEX	<p>Designed to perfectly blend comfort, performance, and value, Fieldsheer’s Smart Thawdaddy 2.0 Bluetooth (Men’s Heated Vest/ Women’s Heated Vest) is updated with Mobile's powerful Mobile Warming Technology. Their Powersheer 7.4-Volt Lithium-Ion battery is supported by a universal USB charging port and can provide heat for up to 10 hours on a single charge. 4 distinct heat settings put you in control, and with seamless Bluetooth connectivity on Mobile's proprietary MW Connect app, you can stay warm in even the harshest winter conditions.</p> <p> </p> <ul> <li>100% Polyester Outer Shell</li> <li>Sweatsheer Moisture Wicking Mesh</li> <li>Compact Vest Design</li> <li>4 Selectable Heat Settings</li> <li>7.4volt Rechargeable Lithium-Ion Battery</li> <li>Up to 10 Hours of Power Per Charge</li> <li>Universal USB Charging Input</li> </ul>	[empty string]	N	99	99	2X/3X	99838-DEFAULT-s.jpg	[empty string]	1000	MWUV1101	371924	OUTERWEAR	TOPS	EMPTY	0	0	0	WOMEN	[empty string]	mobile-warming/smart-thawdaddy-2-0-unisex-371924	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts626 ORDER BY sortposition asc

Clothing

Sort By:

Items per page:

Filter