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]	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	[empty string]	0	189.99	0	189.99	[empty string]	189.99	[empty string]	W ICEFIELD PAC BOOT BLACK	N	5 MAIDA	[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]	WOMENS	ACTIVE	ONLINE	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	Icefield - Women`s	<p>FEATURES:<br /> -Liner: Removable, max-layer inner boot system<br /> -Double B-Tek insulation<br /> -Double aluminum insole<br /> -Waffle-comb foot-bed<br /> -Base: Arctic Rubber Shell, EVA Midsole, Polar Rubber Outsole<br /> -Waterproof, Diamond-Lite insulated nylon upper<br /> -Side-to-side webbed lacing system<br /> -Waterproof nylon snow collar</p>	[empty string]	N	189.99	189.99	6	[empty string]	[empty string]	1000	40100172-001	2871	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/w-icefield-pac-boot-black-2871	1
2	BLACK	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	BLACK\|NULL\|NULL	0	159.99	0	159.99	[empty string]	159.99	[empty string]	M TITAN PAC BOOT	N	5 MAIDA	[empty string]	[empty string]	[empty string]	B	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	MENS	ACTIVE	ONLINE	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	Titan - Pln - Men'S	<p>FEATURES:<br /> -Fully moulded waterproof boot<br /> -Aggressive, long wearing, self-cleaning outsole design<br /> -Micro-cellular waffle foot-bed traps air and moisture<br /> -Light weight and flexible TR compound<br /> -Plain toe</p>	[empty string]	N	159.99	159.99	8	[empty string]	[empty string]	1000	23550000-001	85905	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/m-titan-pac-boot-85905	1
3	BLACK	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	BLACK\|NULL\|NULL	0	139.99	0	139.99	[empty string]	139.99	[empty string]	M TUNDRA PAC BOOT	N	5 MAIDA	[empty string]	[empty string]	[empty string]	B	[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]	1	100-to-150	0.00	[empty string]	Tundra	<p>FEATURES:<br /> -Liner: Removable, Baffin multi-layer inner boot system<br /> -Moisture management system<br /> -Comfort<br /> -Base: Arctic Rubber Shell, EVA Midsole, Polar Rubber Outsole<br /> -Locking snow collar<br /> -Reflective piping for visibility with velcro-strap ankle support</p>	[empty string]	N	139.99	139.99	8	[empty string]	[empty string]	1000	43000162-001	102749	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/m-tundra-pac-boot-102749	1
4	BLACK	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	BLACK\|NULL\|NULL	0	74.99	0	74.99	[empty string]	74.99	[empty string]	JR MUSTANG PAC BOOT	N	5 MAIDA	[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]	YOUTH	ACTIVE	ONLINE	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	Mustang - Juniors	<p>FEATURES:<br /> -Removable, multi-layer inner boot system liner<br /> -Arctic Rubber base<br /> -Locking snow collar<br /> -Ankle height Velcro strap for fastening<br /> -Rip-stop nylon upper</p>	[empty string]	N	74.99	74.99	3,4	[empty string]	[empty string]	1000	4820-0068	105064	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/jr-mustang-pac-boot-105064	1
5	BLACK	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	BLACK\|NULL\|NULL	0	229.99	0	229.99	[empty string]	229.99	[empty string]	M EIGER PAC BOOT	N	5 MAIDA	[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	ONLINE	[empty string]	[empty string]	3	200-to-250	0.00	[empty string]	Eiger - Men'S	<p>FEATURES:<br /> -Waterproof base<br /> -Liner: Removable, Baffin multi-layer inner boot system<br /> -Base: Arctic Rubber Shell, EVA Midsole, Polar Rubber Outsole<br /> -Double B-Tek insulation<br /> -Double aluminum insole<br /> -Waffle-comb foot-bed<br /> -Double-strap Velcro fastening<br /> -Waterproof nylon snow collar with built-in extendable gaiter<br /> -Waterproof, Diamond-Lite insulated nylon with full-grain leather upper</p>	[empty string]	N	229.99	229.99	8,9,10	[empty string]	[empty string]	1000	4000-M001-BK1	117887	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/m-eiger-pac-boot-117887	1
6	BLACK	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	BLACK\|NULL\|NULL	0	94.99	0	94.99	[empty string]	94.99	[empty string]	JR EIGER PAC BOOT	N	5 MAIDA	[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]	YOUTH	ACTIVE	ONLINE	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Eiger - Junior`s	<p>FEATURES:<br /> -Removable, multi-layer inner boot system<br /> -Waffle-comb foot-bed<br /> -Arctic Rubber base<br /> -Double-strap Velcro fastening<br /> -Waterproof nylon snow collar</p>	[empty string]	N	94.99	94.99	3	[empty string]	[empty string]	1000	EPIC-J001	117895	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/jr-eiger-pac-boot-117895	1
7	BROWN	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	BROWN\|NULL\|NULL	0	229.99	0	229.99	[empty string]	229.99	[empty string]	M CONTROLMAX PAC BOOT	N	5 MAIDA	[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]	1	200-to-250	0.00	[empty string]	Control Max	<p>FEATURES:<br /> -Liner: Removable, Baffin multi-layer inner boot system<br /> -Waffle-comb foot-bed<br /> -Base: Arctic Rubber Shell, EVA Midsole, Polar Rubber Outsole <br /> -Multi D-Ring lace fastening<br /> -Full-grain insulated leather<br /> -Waterproof seam-sealed upper</p>	[empty string]	N	229.99	229.99	13	[empty string]	[empty string]	1000	EPIC-M004-BR5	118191	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/m-controlmax-pac-boot-118191	1
8	BLK	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	BLK\|NULL\|NULL	0	74.99	0	74.99	[empty string]	74.99	[empty string]	YTH MUSTANG PAC BOOT	N	5 MAIDA	[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]	YOUTH	ACTIVE	ONLINE	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	Mustang - Youth	<p>FEATURES:<br /> -Removable, multi-layer inner boot system<br /> -Arctic Rubber base<br /> -Locking snow collar<br /> -Ankle height Velcro strap for fastening<br /> -Rip-stop nylon upper</p>	[empty string]	N	74.99	74.99	13,11	[empty string]	[empty string]	1000	4880-0068	121248	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/yth-mustang-pac-boot-121248	1
9	BLACK/BARK	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	BLACK/BARK\|NULL\|NULL	0	249.99	0	249.99	[empty string]	249.99	[empty string]	MNS APEX	N	5 MAIDA	[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	ONLINE	[empty string]	[empty string]	1	200-to-250	0.00	[empty string]	Apex - Men'S	<p>FEATURES:<br /> -Waterproof base<br /> -Liner: Removable, Baffin multi-layer inner boot system<br /> -Double B-Tek insulation<br /> -Double aluminum insole<br /> -Waffle-comb foot-bed<br /> -Base: Arctic Rubber Shell, EVA Midsole, Polar Rubber Outsole<br /> -Speed-lace front fastening system<br /> -Full length tongue for ease-of-entry<br /> -Waterproof leather upper</p>	[empty string]	N	249.99	249.99	9	[empty string]	[empty string]	1000	4000-1305-455	159388	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/mns-apex-159388	1
10	CHARCOAL	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	CHARCOAL\|NULL\|NULL	0	139.99	0	139.99	[empty string]	139.99	[empty string]	W SNOWGOOSE	N	5 MAIDA	[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]	WOMENS	ACTIVE	ONLINE	[empty string]	[empty string]	6	100-to-150	0.00	[empty string]	Snogoose - Women`s	<p>FEATURES:<br /> -Liner: Removable, Baffin multi-layer inner boot system<br /> -Base: Arctic Rubber Shell, EVA Midsole and Polar Rubber Outsole designed for a women’s foot<br /> -Side-to-side lace fastening with toggle<br /> -Waterproof nylon snow collar<br /> -Waterproof 900 Denier nylon upper</p>	[empty string]	N	139.99	139.99	7,11	[empty string]	[empty string]	1000	4510-1330-GY2	254106	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/w-snowgoose-254106	1
11	TAUPE	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	TAUPE\|NULL\|NULL	0	159.99	0	159.99	[empty string]	159.99	[empty string]	W CHOLE	N	5 MAIDA	[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]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	Chloe - Women`s	<p>FEATURES:<br /> -Liner: Removable, Baffin multi-layer inner boot system<br /> -Base: Arctic Rubber Shell, EVA Midsole and Polar Rubber Outsole designed for a women’s foot<br /> -D-Ring front lace fastening system<br /> -Faux-fur collar and sidepiece<br /> -Waterproof suede leather upper</p>	[empty string]	N	159.99	159.99	6	[empty string]	[empty string]	1000	4510-0185-BG4	254107	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/w-chole-254107	1
12	BROWN	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	BROWN\|NULL\|NULL	0	94.99	0	94.99	[empty string]	94.99	[empty string]	M ONTARIO	N	5 MAIDA	[empty string]	[empty string]	[empty string]	B	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	MENS	SELL THRU	ONLINE	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Ontario - Men`s	<p>FEATURES:<br /> -Liner: Fixed Lining<br /> -Thermaplush<br /> -Removable comfort-crafted insole<br /> -Base: Premium rubber, waterproof base<br /> -Waterproof - B-Tek.DRY breathable membrane<br /> -Low slip-on for easy entry<br /> -Front lace fastening<br /> -Waterproof, durable leather</p>	[empty string]	N	94.99	94.99	9	[empty string]	[empty string]	1000	LAKE-MOO3-BR1	288911	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/m-ontario-288911	1
13	BLACK	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	BLACK\|NULL\|NULL	0	167.99	0	167.99	[empty string]	167.99	[empty string]	M SNOWSTORM	N	5 MAIDA	[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]	1	150-to-200	0.00	[empty string]	M Snowstorm	[empty string]	[empty string]	N	167.99	167.99	13	[empty string]	[empty string]	1000	SOFT-M024-BK1	322718	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/m-snowstorm-322718	1
14	BLACK	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	BLACK\|NULL\|NULL	0	94.99	0	94.99	[empty string]	94.99	[empty string]	JUNIOR AVERY	N	5 MAIDA	[empty string]	[empty string]	[empty string]	B	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	YOUTH	ACTIVE	[empty string]	[empty string]	[empty string]	7	50-to-100	0.00	[empty string]	Junior Avery	[empty string]	[empty string]	N	94.99	94.99	3,5,6,4	[empty string]	[empty string]	1000	SNFL-J020-BK1	335954	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/junior-avery-335954	1
15	BLK,BLK/LAV	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	BLK\|NULL\|NULL,BLK/LAV\|NULL\|NULL	0	49.99	0	49.99	[empty string]	49.99	[empty string]	YTH ICE CASTLE -22	N	5 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	16	25-to-50	0.00	[empty string]	Iceberg - Youth	<p>FEATURES:<br /> -Removable, Baffin multi-layer inner boot system<br /> -Frost plate<br /> -Arctic Rubber Shell, GelFlex Midsole, Polar Rubber Outsole<br /> -Waterproof, double rip-stop nylon and leather<br /> -Velcro front fastening<br /> -Locking snow collar</p>	[empty string]	N	49.99	49.99	1,2,3,4,12,8,10,11	[empty string]	[empty string]	1000	WRUB-Y001	342010	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/yth-ice-castle-22-342010	1
16	BROWN	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	BROWN\|NULL\|NULL	0	149.99	0	149.99	[empty string]	149.99	[empty string]	W YELLOWKNIFE	N	5 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2022	[empty string]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	3	100-to-150	0.00	[empty string]	W Yellowknife	[empty string]	[empty string]	N	149.99	149.99	6,7	[empty string]	[empty string]	1000	CANA-W001-BBJ	356240	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/w-yellowknife-356240	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Size

1
10
11
12
13
14
15
2
3
4
5
6
7
8
9
NA

Filter