HOOPIE COLLAR

No 25203

Be the first to review!

^$19⁹⁵

Choose Color

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	OBSIDIAN_BLACK	85313	[empty string]	[empty string]	0	5	0	0	OBSIDIAN_BLACK	44	[empty string]	758881	[empty string]	155039
2	PURPLE_DUSK	85314	[empty string]	[empty string]	0	3	0	0	PURPLE_DUSK	32	[empty string]	758882	[empty string]	155039
3	RED_CURRANT	85315	[empty string]	[empty string]	0	3	0	0	RED_CURRANT	30	[empty string]	758883	[empty string]	155039
4	ORANGE_SUNSET	85316	[empty string]	[empty string]	0	4	0	0	ORANGE_SUNSET	31	[empty string]	758884	[empty string]	155039
5	BLUE_MOUNTAINS	85317	[empty string]	[empty string]	0	4	0	0	BLUE_MOUNTAINS	52	[empty string]	758885	[empty string]	155039
6	RED_BUTTE	85318	[empty string]	[empty string]	0	4	0	0	RED_BUTTE	54	[empty string]	758886	[empty string]	155039
7	BROOK_TROUT	85319	[empty string]	[empty string]	0	5	0	0	BROOK_TROUT	55	[empty string]	758887	[empty string]	155039
8	MONUMENT_VALLEY	85320	[empty string]	[empty string]	0	3	0	0	MONUMENT_VALLEY	31	[empty string]	758888	[empty string]	155039
9	LOTUS	85321	[empty string]	[empty string]	0	4	0	0	LOTUS	38	[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 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 (3,8,9,1,2,6,11,14,5,7) 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 not in ('N','NO') or (a.sell_web is null)) and a.style_id=? AND e.store_id in(3,8,9,1,2,6,11,14,5,7) 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	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	OBSIDIAN_BLACK	85313	[empty string]	[empty string]	0	5	0	0	OBSIDIAN_BLACK	44	[empty string]	758881	[empty string]	155039
2	PURPLE_DUSK	85314	[empty string]	[empty string]	0	3	0	0	PURPLE_DUSK	32	[empty string]	758882	[empty string]	155039
3	RED_CURRANT	85315	[empty string]	[empty string]	0	3	0	0	RED_CURRANT	30	[empty string]	758883	[empty string]	155039
4	ORANGE_SUNSET	85316	[empty string]	[empty string]	0	4	0	0	ORANGE_SUNSET	31	[empty string]	758884	[empty string]	155039
5	BLUE_MOUNTAINS	85317	[empty string]	[empty string]	0	4	0	0	BLUE_MOUNTAINS	52	[empty string]	758885	[empty string]	155039
6	RED_BUTTE	85318	[empty string]	[empty string]	0	4	0	0	RED_BUTTE	54	[empty string]	758886	[empty string]	155039
7	BROOK_TROUT	85319	[empty string]	[empty string]	0	5	0	0	BROOK_TROUT	55	[empty string]	758887	[empty string]	155039
8	MONUMENT_VALLEY	85320	[empty string]	[empty string]	0	3	0	0	MONUMENT_VALLEY	31	[empty string]	758888	[empty string]	155039
9	LOTUS	85321	[empty string]	[empty string]	0	4	0	0	LOTUS	38	[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	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	OBSIDIAN_BLACK	85313	[empty string]	[empty string]	0	5	0	0	OBSIDIAN_BLACK	44	[empty string]	758881	[empty string]	155039
2	PURPLE_DUSK	85314	[empty string]	[empty string]	0	3	0	0	PURPLE_DUSK	32	[empty string]	758882	[empty string]	155039
3	RED_CURRANT	85315	[empty string]	[empty string]	0	3	0	0	RED_CURRANT	30	[empty string]	758883	[empty string]	155039
4	ORANGE_SUNSET	85316	[empty string]	[empty string]	0	4	0	0	ORANGE_SUNSET	31	[empty string]	758884	[empty string]	155039
5	BLUE_MOUNTAINS	85317	[empty string]	[empty string]	0	4	0	0	BLUE_MOUNTAINS	52	[empty string]	758885	[empty string]	155039
6	RED_BUTTE	85318	[empty string]	[empty string]	0	4	0	0	RED_BUTTE	54	[empty string]	758886	[empty string]	155039
7	BROOK_TROUT	85319	[empty string]	[empty string]	0	5	0	0	BROOK_TROUT	55	[empty string]	758887	[empty string]	155039
8	MONUMENT_VALLEY	85320	[empty string]	[empty string]	0	3	0	0	MONUMENT_VALLEY	31	[empty string]	758888	[empty string]	155039
9	LOTUS	85321	[empty string]	[empty string]	0	4	0	0	LOTUS	38	[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	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	OBSIDIAN_BLACK	85313	[empty string]	[empty string]	0	5	0	0	OBSIDIAN_BLACK	44	[empty string]	758881	[empty string]	155039
2	PURPLE_DUSK	85314	[empty string]	[empty string]	0	3	0	0	PURPLE_DUSK	32	[empty string]	758882	[empty string]	155039
3	RED_CURRANT	85315	[empty string]	[empty string]	0	3	0	0	RED_CURRANT	30	[empty string]	758883	[empty string]	155039
4	ORANGE_SUNSET	85316	[empty string]	[empty string]	0	4	0	0	ORANGE_SUNSET	31	[empty string]	758884	[empty string]	155039
5	BLUE_MOUNTAINS	85317	[empty string]	[empty string]	0	4	0	0	BLUE_MOUNTAINS	52	[empty string]	758885	[empty string]	155039
6	RED_BUTTE	85318	[empty string]	[empty string]	0	4	0	0	RED_BUTTE	54	[empty string]	758886	[empty string]	155039
7	BROOK_TROUT	85319	[empty string]	[empty string]	0	5	0	0	BROOK_TROUT	55	[empty string]	758887	[empty string]	155039
8	MONUMENT_VALLEY	85320	[empty string]	[empty string]	0	3	0	0	MONUMENT_VALLEY	31	[empty string]	758888	[empty string]	155039
9	LOTUS	85321	[empty string]	[empty string]	0	4	0	0	LOTUS	38	[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	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	OBSIDIAN_BLACK	85313	[empty string]	[empty string]	0	5	0	0	OBSIDIAN_BLACK	44	[empty string]	758881	[empty string]	155039
2	PURPLE_DUSK	85314	[empty string]	[empty string]	0	3	0	0	PURPLE_DUSK	32	[empty string]	758882	[empty string]	155039
3	RED_CURRANT	85315	[empty string]	[empty string]	0	3	0	0	RED_CURRANT	30	[empty string]	758883	[empty string]	155039
4	ORANGE_SUNSET	85316	[empty string]	[empty string]	0	4	0	0	ORANGE_SUNSET	31	[empty string]	758884	[empty string]	155039
5	BLUE_MOUNTAINS	85317	[empty string]	[empty string]	0	4	0	0	BLUE_MOUNTAINS	52	[empty string]	758885	[empty string]	155039
6	RED_BUTTE	85318	[empty string]	[empty string]	0	4	0	0	RED_BUTTE	54	[empty string]	758886	[empty string]	155039
7	BROOK_TROUT	85319	[empty string]	[empty string]	0	5	0	0	BROOK_TROUT	55	[empty string]	758887	[empty string]	155039
8	MONUMENT_VALLEY	85320	[empty string]	[empty string]	0	3	0	0	MONUMENT_VALLEY	31	[empty string]	758888	[empty string]	155039
9	LOTUS	85321	[empty string]	[empty string]	0	4	0	0	LOTUS	38	[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	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	OBSIDIAN_BLACK	85313	[empty string]	[empty string]	0	5	0	0	OBSIDIAN_BLACK	44	[empty string]	758881	[empty string]	155039
2	PURPLE_DUSK	85314	[empty string]	[empty string]	0	3	0	0	PURPLE_DUSK	32	[empty string]	758882	[empty string]	155039
3	RED_CURRANT	85315	[empty string]	[empty string]	0	3	0	0	RED_CURRANT	30	[empty string]	758883	[empty string]	155039
4	ORANGE_SUNSET	85316	[empty string]	[empty string]	0	4	0	0	ORANGE_SUNSET	31	[empty string]	758884	[empty string]	155039
5	BLUE_MOUNTAINS	85317	[empty string]	[empty string]	0	4	0	0	BLUE_MOUNTAINS	52	[empty string]	758885	[empty string]	155039
6	RED_BUTTE	85318	[empty string]	[empty string]	0	4	0	0	RED_BUTTE	54	[empty string]	758886	[empty string]	155039
7	BROOK_TROUT	85319	[empty string]	[empty string]	0	5	0	0	BROOK_TROUT	55	[empty string]	758887	[empty string]	155039
8	MONUMENT_VALLEY	85320	[empty string]	[empty string]	0	3	0	0	MONUMENT_VALLEY	31	[empty string]	758888	[empty string]	155039
9	LOTUS	85321	[empty string]	[empty string]	0	4	0	0	LOTUS	38	[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	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	OBSIDIAN_BLACK	85313	[empty string]	[empty string]	0	5	0	0	OBSIDIAN_BLACK	44	[empty string]	758881	[empty string]	155039
2	PURPLE_DUSK	85314	[empty string]	[empty string]	0	3	0	0	PURPLE_DUSK	32	[empty string]	758882	[empty string]	155039
3	RED_CURRANT	85315	[empty string]	[empty string]	0	3	0	0	RED_CURRANT	30	[empty string]	758883	[empty string]	155039
4	ORANGE_SUNSET	85316	[empty string]	[empty string]	0	4	0	0	ORANGE_SUNSET	31	[empty string]	758884	[empty string]	155039
5	BLUE_MOUNTAINS	85317	[empty string]	[empty string]	0	4	0	0	BLUE_MOUNTAINS	52	[empty string]	758885	[empty string]	155039
6	RED_BUTTE	85318	[empty string]	[empty string]	0	4	0	0	RED_BUTTE	54	[empty string]	758886	[empty string]	155039
7	BROOK_TROUT	85319	[empty string]	[empty string]	0	5	0	0	BROOK_TROUT	55	[empty string]	758887	[empty string]	155039
8	MONUMENT_VALLEY	85320	[empty string]	[empty string]	0	3	0	0	MONUMENT_VALLEY	31	[empty string]	758888	[empty string]	155039
9	LOTUS	85321	[empty string]	[empty string]	0	4	0	0	LOTUS	38	[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	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	OBSIDIAN_BLACK	85313	[empty string]	[empty string]	0	5	0	0	OBSIDIAN_BLACK	44	[empty string]	758881	[empty string]	155039
2	PURPLE_DUSK	85314	[empty string]	[empty string]	0	3	0	0	PURPLE_DUSK	32	[empty string]	758882	[empty string]	155039
3	RED_CURRANT	85315	[empty string]	[empty string]	0	3	0	0	RED_CURRANT	30	[empty string]	758883	[empty string]	155039
4	ORANGE_SUNSET	85316	[empty string]	[empty string]	0	4	0	0	ORANGE_SUNSET	31	[empty string]	758884	[empty string]	155039
5	BLUE_MOUNTAINS	85317	[empty string]	[empty string]	0	4	0	0	BLUE_MOUNTAINS	52	[empty string]	758885	[empty string]	155039
6	RED_BUTTE	85318	[empty string]	[empty string]	0	4	0	0	RED_BUTTE	54	[empty string]	758886	[empty string]	155039
7	BROOK_TROUT	85319	[empty string]	[empty string]	0	5	0	0	BROOK_TROUT	55	[empty string]	758887	[empty string]	155039
8	MONUMENT_VALLEY	85320	[empty string]	[empty string]	0	3	0	0	MONUMENT_VALLEY	31	[empty string]	758888	[empty string]	155039
9	LOTUS	85321	[empty string]	[empty string]	0	4	0	0	LOTUS	38	[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	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	OBSIDIAN_BLACK	85313	[empty string]	[empty string]	0	5	0	0	OBSIDIAN_BLACK	44	[empty string]	758881	[empty string]	155039
2	PURPLE_DUSK	85314	[empty string]	[empty string]	0	3	0	0	PURPLE_DUSK	32	[empty string]	758882	[empty string]	155039
3	RED_CURRANT	85315	[empty string]	[empty string]	0	3	0	0	RED_CURRANT	30	[empty string]	758883	[empty string]	155039
4	ORANGE_SUNSET	85316	[empty string]	[empty string]	0	4	0	0	ORANGE_SUNSET	31	[empty string]	758884	[empty string]	155039
5	BLUE_MOUNTAINS	85317	[empty string]	[empty string]	0	4	0	0	BLUE_MOUNTAINS	52	[empty string]	758885	[empty string]	155039
6	RED_BUTTE	85318	[empty string]	[empty string]	0	4	0	0	RED_BUTTE	54	[empty string]	758886	[empty string]	155039
7	BROOK_TROUT	85319	[empty string]	[empty string]	0	5	0	0	BROOK_TROUT	55	[empty string]	758887	[empty string]	155039
8	MONUMENT_VALLEY	85320	[empty string]	[empty string]	0	3	0	0	MONUMENT_VALLEY	31	[empty string]	758888	[empty string]	155039
9	LOTUS	85321	[empty string]	[empty string]	0	4	0	0	LOTUS	38	[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.

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.
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!
QA

Your Name Email Question
Live Chat

HOOPIE COLLAR

Choose Color

CHOOSE Size

Qty

Spill the Beans

You may also like