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]	TUBBS SNOWSHOES	Tubbs Snowshoes	FOOTWEAR	Footwear	[empty string]	0	179.99	0	179.99	[empty string]	179.99	[empty string]	FLEX RDG WOMENS SNOWSHOES 8X22	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	HOLIDAY	[empty string]	2018	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	2	150-to-200	0.00	[empty string]	Flex Rdg - Women'S - 22 Inch	<p>Designed to tackle a wide variety of all-mountain terrain, the FLEX RDG features Tubb's easiest-to-use CustomWrap binding with BOA Closure System. It’s their only binding that incorporates the heel-strap into the binding’s construction, creating exceptional full-foot precision with the simple twist of a dial.</p>	[empty string]	N	179.99	179.99	8X22	[empty string]	[empty string]	1000	X18010200122W	311773	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	tubbs-snowshoes/flex-rdg-womens-snowshoes-8x22-311773	1
2	[empty string]	TUBBS SNOWSHOES	Tubbs Snowshoes	FOOTWEAR	Footwear	[empty string]	0	179.99	0	179.99	[empty string]	179.99	[empty string]	FLEX RDG 24 SNOWSHOES	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	HOLIDAY	[empty string]	2018	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	6	150-to-200	0.00	[empty string]	Flex Rdg - Men`s - 24 Inch	<p>Designed to tackle a wide variety of all-mountain terrain, the FLEX RDG featuresTubb`s easiest-to-use CustomWrap binding with BOA Closure System. It’s their only binding that incorporates the heel-strap into the binding’s construction, creating exceptional full-foot precision with the simple twist of a dial.</p>	[empty string]	N	179.99	179.99	8X24	[empty string]	[empty string]	1000	X180102001240	311775	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	tubbs-snowshoes/flex-rdg-24-snowshoes-311775	1
3	[empty string]	TUBBS SNOWSHOES	Tubbs Snowshoes	FOOTWEAR	Footwear	[empty string]	0	29.99	0	29.99	[empty string]	29.99	[empty string]	MEN`S SNOWSHOE GAITER	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	HOLIDAY	[empty string]	2018	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	3	25-to-50	0.00	[empty string]	Gaiter - Men'S	<p>Water-resistant and breathable, full-length nylon gaiters provide protection from the elements by keeping snow out of your boots.</p>	[empty string]	N	29.99	29.99	[empty string]	[empty string]	[empty string]	1000	X1203002010	311783	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	tubbs-snowshoes/men-s-snowshoe-gaiter-311783	1
4	[empty string]	TUBBS SNOWSHOES	Tubbs Snowshoes	FOOTWEAR	Footwear	[empty string]	0	29.99	0	29.99	[empty string]	29.99	[empty string]	SNOWSHOE BAG	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	HOLIDAY	[empty string]	2018	[empty string]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	5	25-to-50	0.00	[empty string]	Snowshoe Bag	<p>The Tubbs Panoramic women`s snowshoe is poised for optimal floatation in fresh snow. This shoe`s flexible DynamicFit and reliable Boa closure system deliver uncompromised security, and their Cobra Traction design will grip unexpectedly icy terrain. Don`t turn around early ndash; tackle local trails and reach winter vistas on the Tubbs Panoramic.</p>	[empty string]	N	29.99	29.99	[empty string]	[empty string]	[empty string]	1000	X10500196	311785	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	tubbs-snowshoes/snowshoe-bag-311785	1
5	BLACK/GRAY	TUBBS SNOWSHOES	Tubbs Snowshoes	FOOTWEAR	Footwear	BLACK/GRAY\|NULL\|NULL	0	29.99	0	29.99	[empty string]	29.99	[empty string]	WOMEN`S SNOWSHOE GAITER	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	HOLIDAY	[empty string]	2018	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Gaiter - Women'S	<p>Water-resistant and breathable, full-length nylon gaiters provide protection from the elements by keeping snow out of your boots.</p>	[empty string]	N	29.99	29.99	[empty string]	[empty string]	[empty string]	1000	X1203001010	312569	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	tubbs-snowshoes/women-s-snowshoe-gaiter-312569	1
6	[empty string]	TUBBS SNOWSHOES	Tubbs Snowshoes	FOOTWEAR	Footwear	[empty string]	0	29.99	0	29.99	[empty string]	29.99	[empty string]	SNOWSHOE BAG	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	HOLIDAY	[empty string]	2019	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	3	25-to-50	0.00	[empty string]	Snowshoe Bag	<p>The Tubbs Panoramic women`s snowshoe is poised for optimal floatation in fresh snow. This shoe`s flexible DynamicFit and reliable Boa closure system deliver uncompromised security, and their Cobra Traction design will grip unexpectedly icy terrain. Don`t turn around early ndash; tackle local trails and reach winter vistas on the Tubbs Panoramic.</p>	[empty string]	N	29.99	29.99	[empty string]	[empty string]	[empty string]	1000	X10500194	329505	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	tubbs-snowshoes/snowshoe-bag-329505	1
7	[empty string]	TUBBS SNOWSHOES	Tubbs Snowshoes	FOOTWEAR	Footwear	[empty string]	0	199.99	0	199.99	[empty string]	199.99	[empty string]	WILDERNESS BLUE 25 MENS SNOWSHOE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	HOLIDAY	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	150-to-200	0.00	[empty string]	Wilderness Blue 25 Mens Snowshoe	[empty string]	[empty string]	N	199.99	199.99	[empty string]	[empty string]	[empty string]	1000	X200100201250	343896	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	tubbs-snowshoes/wilderness-blue-25-mens-snowshoe-343896	1
8	[empty string]	TUBBS SNOWSHOES	Tubbs Snowshoes	FOOTWEAR	Footwear	[empty string]	0	199.99	0	199.99	[empty string]	199.99	[empty string]	WILDERNESS BLUE 30 MENS SNOWSHOE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	HOLIDAY	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	6	150-to-200	0.00	[empty string]	Wilderness Blue 30 Mens Snowshoe	[empty string]	[empty string]	N	199.99	199.99	30	[empty string]	[empty string]	1000	X200100201300	343897	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	tubbs-snowshoes/wilderness-blue-30-mens-snowshoe-343897	1
9	[empty string]	TUBBS SNOWSHOES	Tubbs Snowshoes	FOOTWEAR	Footwear	[empty string]	0	199.99	0	199.99	[empty string]	199.99	[empty string]	WILDERNESS BLUE 36 MENS SNOWSHOE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	HOLIDAY	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	150-to-200	0.00	[empty string]	Wilderness Blue 36 Mens Snowshoe	[empty string]	[empty string]	N	199.99	199.99	36	[empty string]	[empty string]	1000	X200100201360	343898	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	tubbs-snowshoes/wilderness-blue-36-mens-snowshoe-343898	1
10	[empty string]	TUBBS SNOWSHOES	Tubbs Snowshoes	FOOTWEAR	Footwear	[empty string]	0	199.99	0	199.99	[empty string]	199.99	[empty string]	WILDERNESS GREY/MINT 21 WOMENS SNOWSHOE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	HOLIDAY	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	150-to-200	0.00	[empty string]	Wilderness Grey/mint 21 Womens Snowshoe	[empty string]	[empty string]	N	199.99	199.99	21	[empty string]	[empty string]	1000	X20010020121W	343899	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	tubbs-snowshoes/wilderness-grey-mint-21-womens-snowshoe-343899	1
11	[empty string]	TUBBS SNOWSHOES	Tubbs Snowshoes	FOOTWEAR	Footwear	[empty string]	0	199.99	0	199.99	[empty string]	199.99	[empty string]	WILDERNESS GREY/MINT 25 WOMENS SNOWSHOE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	HOLIDAY	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	6	150-to-200	0.00	[empty string]	Wilderness Grey/mint 25 Womens Snowshoe	[empty string]	[empty string]	N	199.99	199.99	25	[empty string]	[empty string]	1000	X20010020125W	343900	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	tubbs-snowshoes/wilderness-grey-mint-25-womens-snowshoe-343900	1
12	[empty string]	TUBBS SNOWSHOES	Tubbs Snowshoes	FOOTWEAR	Footwear	[empty string]	0	199.99	0	199.99	[empty string]	199.99	[empty string]	WILDERNESS GREY/MINT 30 WOMENS SNOWSHOE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	HOLIDAY	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	Wilderness Grey/mint 30 Womens Snowshoe	[empty string]	[empty string]	N	199.99	199.99	30	[empty string]	[empty string]	1000	X20010020130W	343901	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	tubbs-snowshoes/wilderness-grey-mint-30-womens-snowshoe-343901	1
13	[empty string]	TUBBS SNOWSHOES	Tubbs Snowshoes	FOOTWEAR	Footwear	[empty string]	0	189.99	0	189.99	[empty string]	189.99	[empty string]	WAYFINDER 36 MENS SNOWSHOE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	HOLIDAY	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	150-to-200	0.00	[empty string]	Wayfinder 36 Mens Snowshoe	[empty string]	[empty string]	N	189.99	189.99	36	[empty string]	[empty string]	1000	X200100401360	343904	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	tubbs-snowshoes/wayfinder-36-mens-snowshoe-343904	1
14	[empty string]	TUBBS SNOWSHOES	Tubbs Snowshoes	FOOTWEAR	Footwear	[empty string]	0	189.99	0	189.99	[empty string]	189.99	[empty string]	WAYFINDER 21 WOMENS SNOWSHOE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	HOLIDAY	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	Wayfinder 21 Womens Snowshoe	[empty string]	[empty string]	N	189.99	189.99	21	[empty string]	[empty string]	1000	X20010040121W	343905	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	tubbs-snowshoes/wayfinder-21-womens-snowshoe-343905	1
15	[empty string]	TUBBS SNOWSHOES	Tubbs Snowshoes	FOOTWEAR	Footwear	[empty string]	0	169.99	0	169.99	[empty string]	169.99	[empty string]	FRONTIER BLACK 30 MENS SNOWSHOE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	HOLIDAY	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	5	150-to-200	0.00	[empty string]	Frontier Black 30 Mens Snowshoe	[empty string]	[empty string]	N	169.99	169.99	30	[empty string]	[empty string]	1000	X200100302300	343908	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	tubbs-snowshoes/frontier-black-30-mens-snowshoe-343908	1
16	[empty string]	TUBBS SNOWSHOES	Tubbs Snowshoes	FOOTWEAR	Footwear	[empty string]	0	169.99	0	169.99	[empty string]	169.99	[empty string]	FRONTIER BLACK 36 MENS SNOWSHOE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	HOLIDAY	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	6	150-to-200	0.00	[empty string]	Frontier Black 36 Mens Snowshoe	[empty string]	[empty string]	N	169.99	169.99	36	[empty string]	[empty string]	1000	X200100302360	343909	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	tubbs-snowshoes/frontier-black-36-mens-snowshoe-343909	1
17	[empty string]	TUBBS SNOWSHOES	Tubbs Snowshoes	FOOTWEAR	Footwear	[empty string]	0	169.99	0	169.99	[empty string]	169.99	[empty string]	FRONTIER CORAL 21 WOMENS SNOWSHOE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	HOLIDAY	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	150-to-200	0.00	[empty string]	Frontier Coral 21 Womens Snowshoe	[empty string]	[empty string]	N	169.99	169.99	21	[empty string]	[empty string]	1000	X20010030121W	343910	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	tubbs-snowshoes/frontier-coral-21-womens-snowshoe-343910	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Size

Filter