GREENWICH CROSSBODY

No GNW429

Be the first to review!

^$68⁰⁰

Choose Color

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	PLUM_BERRY	109797	[empty string]	[empty string]	0	1	0	0	PLUM_BERRY	7	[empty string]	919995	[empty string]	195133
2	SMOKE	109798	[empty string]	[empty string]	0	3	0	0	SMOKE	19	[empty string]	919996	[empty string]	195133

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,5,7,14) 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,5,7,14) 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	195133

struct
INTERNALLISTPRICE	68
INTERNALMARKDOWN	false
INTERNALPRICE	68
REG	68
SALE	68
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	PLUM_BERRY	109797	[empty string]	[empty string]	0	1	0	0	PLUM_BERRY	7	[empty string]	919995	[empty string]	195133
2	SMOKE	109798	[empty string]	[empty string]	0	3	0	0	SMOKE	19	[empty string]	919996	[empty string]	195133

array
1	195133

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

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

Travel, commute, or whatever you do

Everyday use to occasion travel, keep all the essentials close at hand when you tote them around in the Greenwich Crossbody from Baggallini. This water-resistant crossbody bag features a roomy main compartment, organization pockets and removable phone wristlet with RFID protection, and a grommeted opening for looping your portable charging cord or headphones through. With a place and space for everything you'll need, slip this bag across your body or over the shoulders before you venture out.

Medium nylon crossbody bag perfect for being on-the-go
Lightweight, water-resistant nylon
RFID Interior organization and multifunctional pockets with 5 credit card slots
Removable RFID phone wristlet included has 3 credit card slots and holds iPhone 8 & iPhone 8 plus
52-inch Adjustable strap
Grommeted opening for charging and headphone cords
Dimensions: 9.5 x 7 x 2 inches (width x height x depth)
Weight: 9 ounces
Care instructions: Wipe clean with a damp cloth

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

Everyday use to occasion travel, keep all the essentials close at hand when you tote them around in the Greenwich Crossbody from Baggallini. This water-resistant crossbody bag features a roomy main compartment, organization pockets and removable phone wristlet with RFID protection, and a grommeted opening for looping your portable charging cord or headphones through. With a place and space for everything you'll need, slip this bag across your body or over the shoulders before you venture out.
Specs
- Medium nylon crossbody bag perfect for being on-the-go
- Lightweight, water-resistant nylon
- RFID Interior organization and multifunctional pockets with 5 credit card slots
- Removable RFID phone wristlet included has 3 credit card slots and holds iPhone 8 & iPhone 8 plus
- 52-inch Adjustable strap
- Grommeted opening for charging and headphone cords
- Dimensions: 9.5 x 7 x 2 inches (width x height x depth)
- Weight: 9 ounces
- Care instructions: Wipe clean with a damp cloth
Reviews

No Reviews Yet!
QA

Your Name Email Question
Live Chat

GREENWICH CROSSBODY

Choose Color

Qty

Spill the Beans

You may also like