HOOPIE COLLAR

No 25203

Be the first to review!

$19.95

Choose Color

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	OBSIDIAN_BLACK	85313	[empty string]	[empty string]	0	4	0	0	OBSIDIAN_BLACK	47	Y	[empty string]	758881	[empty string]	155039
2	PURPLE_DUSK	85314	[empty string]	[empty string]	0	3	0	0	PURPLE_DUSK	17	Y	[empty string]	758882	[empty string]	155039
3	RED_CURRANT	85315	[empty string]	[empty string]	0	3	0	0	RED_CURRANT	20	Y	[empty string]	758883	[empty string]	155039
4	ORANGE_SUNSET	85316	[empty string]	[empty string]	0	2	0	0	ORANGE_SUNSET	30	Y	[empty string]	758884	[empty string]	155039
5	BLUE_MOUNTAINS	85317	[empty string]	[empty string]	0	4	0	0	BLUE_MOUNTAINS	22	Y	[empty string]	758885	[empty string]	155039
6	RED_BUTTE	85318	[empty string]	[empty string]	0	3	0	-1	RED_BUTTE	29	Y	[empty string]	758886	[empty string]	155039
7	BROOK_TROUT	85319	[empty string]	[empty string]	0	2	0	0	BROOK_TROUT	15	Y	[empty string]	758887	[empty string]	155039
8	MONUMENT_VALLEY	85320	[empty string]	[empty string]	0	3	0	-1	MONUMENT_VALLEY	10	Y	[empty string]	758888	[empty string]	155039
9	LOTUS	85321	[empty string]	[empty string]	0	2	0	0	LOTUS	13	Y	[empty string]	758889	[empty string]	155039

SELECT distinct (b.attr1) as origAttr1, max(CASE WHEN b.attr1_alias IS NULL OR RTRIM(LTRIM(b.attr1_alias)) = '' THEN b.attr1 ELSE b.attr1_alias END) as attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh+e.qc) as qoh , max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam,max(a.SKU_OF16) as skuOF16,max(e.qoh) as maxqoh,max(e.qc) as maxqc,min(e.qoh) as minqoh,min(e.qc) as minqc,max(a.style_id) as style_id,max(a.sell_web) as sell_web FROM tb_skus a with (nolock) inner join (select distinct sku_id as sku_id from TB_SKU_BUCKETS with (nolock) where 1=1 and store_id in (11,5,8,6,9,14,15,7,2,1,3,97) group by sku_id having sum(qoh+qc) >=2) skuqoh on (skuqoh.sku_id=a.sku_id) LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id) LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id) LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1) LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id) WHERE (a.sell_web in ('Y','YES') ) and a.style_id=? AND e.store_id in(11,5,8,6,9,14,15,7,2,1,3,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 2 ORDER BY max(b.attr1_order), max(b.attr1_entry_id)

SQLPARAMETERS

array
1	155039

struct
INTERNALLISTPRICE	19.95
INTERNALMARKDOWN	false
INTERNALPRICE	19.95
REG	19.95
SALE	19.95
TERMSALE	false
TERMSALELISTPRICE	0
TERMSALEPRICE	0

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	OBSIDIAN_BLACK	85313	[empty string]	[empty string]	0	4	0	0	OBSIDIAN_BLACK	47	Y	[empty string]	758881	[empty string]	155039
2	PURPLE_DUSK	85314	[empty string]	[empty string]	0	3	0	0	PURPLE_DUSK	17	Y	[empty string]	758882	[empty string]	155039
3	RED_CURRANT	85315	[empty string]	[empty string]	0	3	0	0	RED_CURRANT	20	Y	[empty string]	758883	[empty string]	155039
4	ORANGE_SUNSET	85316	[empty string]	[empty string]	0	2	0	0	ORANGE_SUNSET	30	Y	[empty string]	758884	[empty string]	155039
5	BLUE_MOUNTAINS	85317	[empty string]	[empty string]	0	4	0	0	BLUE_MOUNTAINS	22	Y	[empty string]	758885	[empty string]	155039
6	RED_BUTTE	85318	[empty string]	[empty string]	0	3	0	-1	RED_BUTTE	29	Y	[empty string]	758886	[empty string]	155039
7	BROOK_TROUT	85319	[empty string]	[empty string]	0	2	0	0	BROOK_TROUT	15	Y	[empty string]	758887	[empty string]	155039
8	MONUMENT_VALLEY	85320	[empty string]	[empty string]	0	3	0	-1	MONUMENT_VALLEY	10	Y	[empty string]	758888	[empty string]	155039
9	LOTUS	85321	[empty string]	[empty string]	0	2	0	0	LOTUS	13	Y	[empty string]	758889	[empty string]	155039

array
1	155039

struct
INTERNALLISTPRICE	19.95
INTERNALMARKDOWN	false
INTERNALPRICE	19.95
REG	19.95
SALE	19.95
TERMSALE	false
TERMSALELISTPRICE	0
TERMSALEPRICE	0

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	OBSIDIAN_BLACK	85313	[empty string]	[empty string]	0	4	0	0	OBSIDIAN_BLACK	47	Y	[empty string]	758881	[empty string]	155039
2	PURPLE_DUSK	85314	[empty string]	[empty string]	0	3	0	0	PURPLE_DUSK	17	Y	[empty string]	758882	[empty string]	155039
3	RED_CURRANT	85315	[empty string]	[empty string]	0	3	0	0	RED_CURRANT	20	Y	[empty string]	758883	[empty string]	155039
4	ORANGE_SUNSET	85316	[empty string]	[empty string]	0	2	0	0	ORANGE_SUNSET	30	Y	[empty string]	758884	[empty string]	155039
5	BLUE_MOUNTAINS	85317	[empty string]	[empty string]	0	4	0	0	BLUE_MOUNTAINS	22	Y	[empty string]	758885	[empty string]	155039
6	RED_BUTTE	85318	[empty string]	[empty string]	0	3	0	-1	RED_BUTTE	29	Y	[empty string]	758886	[empty string]	155039
7	BROOK_TROUT	85319	[empty string]	[empty string]	0	2	0	0	BROOK_TROUT	15	Y	[empty string]	758887	[empty string]	155039
8	MONUMENT_VALLEY	85320	[empty string]	[empty string]	0	3	0	-1	MONUMENT_VALLEY	10	Y	[empty string]	758888	[empty string]	155039
9	LOTUS	85321	[empty string]	[empty string]	0	2	0	0	LOTUS	13	Y	[empty string]	758889	[empty string]	155039

array
1	155039

struct
INTERNALLISTPRICE	19.95
INTERNALMARKDOWN	false
INTERNALPRICE	19.95
REG	19.95
SALE	19.95
TERMSALE	false
TERMSALELISTPRICE	0
TERMSALEPRICE	0

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	OBSIDIAN_BLACK	85313	[empty string]	[empty string]	0	4	0	0	OBSIDIAN_BLACK	47	Y	[empty string]	758881	[empty string]	155039
2	PURPLE_DUSK	85314	[empty string]	[empty string]	0	3	0	0	PURPLE_DUSK	17	Y	[empty string]	758882	[empty string]	155039
3	RED_CURRANT	85315	[empty string]	[empty string]	0	3	0	0	RED_CURRANT	20	Y	[empty string]	758883	[empty string]	155039
4	ORANGE_SUNSET	85316	[empty string]	[empty string]	0	2	0	0	ORANGE_SUNSET	30	Y	[empty string]	758884	[empty string]	155039
5	BLUE_MOUNTAINS	85317	[empty string]	[empty string]	0	4	0	0	BLUE_MOUNTAINS	22	Y	[empty string]	758885	[empty string]	155039
6	RED_BUTTE	85318	[empty string]	[empty string]	0	3	0	-1	RED_BUTTE	29	Y	[empty string]	758886	[empty string]	155039
7	BROOK_TROUT	85319	[empty string]	[empty string]	0	2	0	0	BROOK_TROUT	15	Y	[empty string]	758887	[empty string]	155039
8	MONUMENT_VALLEY	85320	[empty string]	[empty string]	0	3	0	-1	MONUMENT_VALLEY	10	Y	[empty string]	758888	[empty string]	155039
9	LOTUS	85321	[empty string]	[empty string]	0	2	0	0	LOTUS	13	Y	[empty string]	758889	[empty string]	155039

array
1	155039

struct
INTERNALLISTPRICE	19.95
INTERNALMARKDOWN	false
INTERNALPRICE	19.95
REG	19.95
SALE	19.95
TERMSALE	false
TERMSALELISTPRICE	0
TERMSALEPRICE	0

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	OBSIDIAN_BLACK	85313	[empty string]	[empty string]	0	4	0	0	OBSIDIAN_BLACK	47	Y	[empty string]	758881	[empty string]	155039
2	PURPLE_DUSK	85314	[empty string]	[empty string]	0	3	0	0	PURPLE_DUSK	17	Y	[empty string]	758882	[empty string]	155039
3	RED_CURRANT	85315	[empty string]	[empty string]	0	3	0	0	RED_CURRANT	20	Y	[empty string]	758883	[empty string]	155039
4	ORANGE_SUNSET	85316	[empty string]	[empty string]	0	2	0	0	ORANGE_SUNSET	30	Y	[empty string]	758884	[empty string]	155039
5	BLUE_MOUNTAINS	85317	[empty string]	[empty string]	0	4	0	0	BLUE_MOUNTAINS	22	Y	[empty string]	758885	[empty string]	155039
6	RED_BUTTE	85318	[empty string]	[empty string]	0	3	0	-1	RED_BUTTE	29	Y	[empty string]	758886	[empty string]	155039
7	BROOK_TROUT	85319	[empty string]	[empty string]	0	2	0	0	BROOK_TROUT	15	Y	[empty string]	758887	[empty string]	155039
8	MONUMENT_VALLEY	85320	[empty string]	[empty string]	0	3	0	-1	MONUMENT_VALLEY	10	Y	[empty string]	758888	[empty string]	155039
9	LOTUS	85321	[empty string]	[empty string]	0	2	0	0	LOTUS	13	Y	[empty string]	758889	[empty string]	155039

array
1	155039

struct
INTERNALLISTPRICE	19.95
INTERNALMARKDOWN	false
INTERNALPRICE	19.95
REG	19.95
SALE	19.95
TERMSALE	false
TERMSALELISTPRICE	0
TERMSALEPRICE	0

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	OBSIDIAN_BLACK	85313	[empty string]	[empty string]	0	4	0	0	OBSIDIAN_BLACK	47	Y	[empty string]	758881	[empty string]	155039
2	PURPLE_DUSK	85314	[empty string]	[empty string]	0	3	0	0	PURPLE_DUSK	17	Y	[empty string]	758882	[empty string]	155039
3	RED_CURRANT	85315	[empty string]	[empty string]	0	3	0	0	RED_CURRANT	20	Y	[empty string]	758883	[empty string]	155039
4	ORANGE_SUNSET	85316	[empty string]	[empty string]	0	2	0	0	ORANGE_SUNSET	30	Y	[empty string]	758884	[empty string]	155039
5	BLUE_MOUNTAINS	85317	[empty string]	[empty string]	0	4	0	0	BLUE_MOUNTAINS	22	Y	[empty string]	758885	[empty string]	155039
6	RED_BUTTE	85318	[empty string]	[empty string]	0	3	0	-1	RED_BUTTE	29	Y	[empty string]	758886	[empty string]	155039
7	BROOK_TROUT	85319	[empty string]	[empty string]	0	2	0	0	BROOK_TROUT	15	Y	[empty string]	758887	[empty string]	155039
8	MONUMENT_VALLEY	85320	[empty string]	[empty string]	0	3	0	-1	MONUMENT_VALLEY	10	Y	[empty string]	758888	[empty string]	155039
9	LOTUS	85321	[empty string]	[empty string]	0	2	0	0	LOTUS	13	Y	[empty string]	758889	[empty string]	155039

array
1	155039

struct
INTERNALLISTPRICE	19.95
INTERNALMARKDOWN	false
INTERNALPRICE	19.95
REG	19.95
SALE	19.95
TERMSALE	false
TERMSALELISTPRICE	0
TERMSALEPRICE	0

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	OBSIDIAN_BLACK	85313	[empty string]	[empty string]	0	4	0	0	OBSIDIAN_BLACK	47	Y	[empty string]	758881	[empty string]	155039
2	PURPLE_DUSK	85314	[empty string]	[empty string]	0	3	0	0	PURPLE_DUSK	17	Y	[empty string]	758882	[empty string]	155039
3	RED_CURRANT	85315	[empty string]	[empty string]	0	3	0	0	RED_CURRANT	20	Y	[empty string]	758883	[empty string]	155039
4	ORANGE_SUNSET	85316	[empty string]	[empty string]	0	2	0	0	ORANGE_SUNSET	30	Y	[empty string]	758884	[empty string]	155039
5	BLUE_MOUNTAINS	85317	[empty string]	[empty string]	0	4	0	0	BLUE_MOUNTAINS	22	Y	[empty string]	758885	[empty string]	155039
6	RED_BUTTE	85318	[empty string]	[empty string]	0	3	0	-1	RED_BUTTE	29	Y	[empty string]	758886	[empty string]	155039
7	BROOK_TROUT	85319	[empty string]	[empty string]	0	2	0	0	BROOK_TROUT	15	Y	[empty string]	758887	[empty string]	155039
8	MONUMENT_VALLEY	85320	[empty string]	[empty string]	0	3	0	-1	MONUMENT_VALLEY	10	Y	[empty string]	758888	[empty string]	155039
9	LOTUS	85321	[empty string]	[empty string]	0	2	0	0	LOTUS	13	Y	[empty string]	758889	[empty string]	155039

array
1	155039

struct
INTERNALLISTPRICE	19.95
INTERNALMARKDOWN	false
INTERNALPRICE	19.95
REG	19.95
SALE	19.95
TERMSALE	false
TERMSALELISTPRICE	0
TERMSALEPRICE	0

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	OBSIDIAN_BLACK	85313	[empty string]	[empty string]	0	4	0	0	OBSIDIAN_BLACK	47	Y	[empty string]	758881	[empty string]	155039
2	PURPLE_DUSK	85314	[empty string]	[empty string]	0	3	0	0	PURPLE_DUSK	17	Y	[empty string]	758882	[empty string]	155039
3	RED_CURRANT	85315	[empty string]	[empty string]	0	3	0	0	RED_CURRANT	20	Y	[empty string]	758883	[empty string]	155039
4	ORANGE_SUNSET	85316	[empty string]	[empty string]	0	2	0	0	ORANGE_SUNSET	30	Y	[empty string]	758884	[empty string]	155039
5	BLUE_MOUNTAINS	85317	[empty string]	[empty string]	0	4	0	0	BLUE_MOUNTAINS	22	Y	[empty string]	758885	[empty string]	155039
6	RED_BUTTE	85318	[empty string]	[empty string]	0	3	0	-1	RED_BUTTE	29	Y	[empty string]	758886	[empty string]	155039
7	BROOK_TROUT	85319	[empty string]	[empty string]	0	2	0	0	BROOK_TROUT	15	Y	[empty string]	758887	[empty string]	155039
8	MONUMENT_VALLEY	85320	[empty string]	[empty string]	0	3	0	-1	MONUMENT_VALLEY	10	Y	[empty string]	758888	[empty string]	155039
9	LOTUS	85321	[empty string]	[empty string]	0	2	0	0	LOTUS	13	Y	[empty string]	758889	[empty string]	155039

array
1	155039

struct
INTERNALLISTPRICE	19.95
INTERNALMARKDOWN	false
INTERNALPRICE	19.95
REG	19.95
SALE	19.95
TERMSALE	false
TERMSALELISTPRICE	0
TERMSALEPRICE	0

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	OBSIDIAN_BLACK	85313	[empty string]	[empty string]	0	4	0	0	OBSIDIAN_BLACK	47	Y	[empty string]	758881	[empty string]	155039
2	PURPLE_DUSK	85314	[empty string]	[empty string]	0	3	0	0	PURPLE_DUSK	17	Y	[empty string]	758882	[empty string]	155039
3	RED_CURRANT	85315	[empty string]	[empty string]	0	3	0	0	RED_CURRANT	20	Y	[empty string]	758883	[empty string]	155039
4	ORANGE_SUNSET	85316	[empty string]	[empty string]	0	2	0	0	ORANGE_SUNSET	30	Y	[empty string]	758884	[empty string]	155039
5	BLUE_MOUNTAINS	85317	[empty string]	[empty string]	0	4	0	0	BLUE_MOUNTAINS	22	Y	[empty string]	758885	[empty string]	155039
6	RED_BUTTE	85318	[empty string]	[empty string]	0	3	0	-1	RED_BUTTE	29	Y	[empty string]	758886	[empty string]	155039
7	BROOK_TROUT	85319	[empty string]	[empty string]	0	2	0	0	BROOK_TROUT	15	Y	[empty string]	758887	[empty string]	155039
8	MONUMENT_VALLEY	85320	[empty string]	[empty string]	0	3	0	-1	MONUMENT_VALLEY	10	Y	[empty string]	758888	[empty string]	155039
9	LOTUS	85321	[empty string]	[empty string]	0	2	0	0	LOTUS	13	Y	[empty string]	758889	[empty string]	155039

array
1	155039

struct
INTERNALLISTPRICE	19.95
INTERNALMARKDOWN	false
INTERNALPRICE	19.95
REG	19.95
SALE	19.95
TERMSALE	false
TERMSALELISTPRICE	0
TERMSALEPRICE	0

CHOOSE Size

Size

Qty

Check Store Availability

Add to Basket

Please login or create an account to save this product to your wish list.

Description
Specs
Reviews
Live Chat

Enjoy Your Walk A Little More

Need an everyday collar for your four-legged buddy that's easy to use? Ruffwear has you covered with the Hoopie Collar. Featuring a side-release buckle, strong and comfortable webbing, and an aluminum v-ring, this fun collar is a stylish and practical dog-walking accessory.

Why we love it:

I purchased this collar for my 50 pound rescue pup. It is attractive, durable and holds up well to our active lifestyle. I especially like the unique mountain pattern that is woven into the collar webbing, as well as, the aluminum v-ring that makes attaching the leash quick and easy.

Tami S., Mast General Store - Roanoke, VA

Ruffwear-designed Tubelok™ webbing
Easily add or remove tags with Quick Ring™
Separate ID attachment point
Silicone tag silencer
Care instructions: Hand wash; mild detergent; air dry
Imported

No Reviews Yet!

Spill the Beans

Headline Name Email Overall Rating

Review

We want to make sure you know: All reviews become the property of Mast General Store. Your review requires staff approval before posting. See our Terms of Use for details.

Description

Need an everyday collar for your four-legged buddy that's easy to use? Ruffwear has you covered with the Hoopie Collar. Featuring a side-release buckle, strong and comfortable webbing, and an aluminum v-ring, this fun collar is a stylish and practical dog-walking accessory.

Why we love it:

I purchased this collar for my 50 pound rescue pup. It is attractive, durable and holds up well to our active lifestyle. I especially like the unique mountain pattern that is woven into the collar webbing, as well as, the aluminum v-ring that makes attaching the leash quick and easy.

Tami S., Mast General Store - Roanoke, VA
Specs
- Ruffwear-designed Tubelok™ webbing
- Easily add or remove tags with Quick Ring™
- Separate ID attachment point
- Silicone tag silencer
- Care instructions: Hand wash; mild detergent; air dry
- Imported
Reviews

No Reviews Yet!
Live Chat

HOOPIE COLLAR

$19.95

Choose Color

CHOOSE Size

Qty

Spill the Beans

You may also like

Regular Price: $12.99

Sale Price: $9.09