Eagle Creek

Eagle Creek Pack-It Original Quilted Mini Cube Set

$24.95

Item # EC0A37G3

query
RESULTSET
query
  ORIGSIZ QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SKU_ID STYLE_ID
1 OS 46 116146 One Size [empty string] 469452 107907
CACHED false
EXECUTIONTIME 378
SQL SELECT distinct (b.siz) as origSiz, max(CASE WHEN b.siz_alias IS NULL OR RTRIM(LTRIM(b.siz_alias)) = '' THEN b.siz ELSE b.siz_alias END) as siz, max(b.size_order) as size_order, max(a.sku_id) as sku_id, max(a.scale_entry_id) as scale_entry_id, sum(e.qoh) as qoh, max(a.style_id) as style_id FROM tb_skus a WITH (NOLOCK) LEFT JOIN tb_size_entries b WITH (NOLOCK) on (b.scale_entry_id = a.scale_entry_id) INNER JOIN ( SELECT DISTINCT sku_id , sum(qoh+qc) as qoh FROM dbo.tb_sku_buckets WITH (NOLOCK) WHERE store_id in(98,8,9,2,5,7,6,3) GROUP BY sku_id ) e on (a.sku_id = e.sku_id) LEFT JOIN tb_attr1_entries d WITH (NOLOCK) on (d.attr1_entry_id = a.attr1_entry_id) LEFT JOIN ( SELECT style_id FROM tb_styles WITH (NOLOCK) WHERE web_style = ? and web_style is not null ) sq ON(a.style_id = sq.style_id) WHERE (sq.style_id is not null OR a.style_id = ?) AND (b.siz_alias is null OR b.siz_alias NOT IN ('NO SHOW','NOSHOW') ) AND isNull(a.sell_web,'Y') = 'Y' AND e.qoh > 1 GROUP BY b.siz ORDER BY max(b.size_order), max(a.scale_entry_id)
SQLPARAMETERS
array
1 EC0A37G3
2 107907
query
RESULTSET
query
  ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID FAM HEX ORIGATTR1 QOH SIZE SKU_ID SORT_ORDER STYLE_ID
1 Black Black 115648 [empty string] [empty string] BLK_010 26 116146 422676 [empty string] 107907
2 Blue Sea Blue Sea 115649 [empty string] [empty string] BLS_137 16 116146 422677 [empty string] 107907
3 Red Fire Red Fire 115650 [empty string] [empty string] RED_138 4 116146 469452 [empty string] 107907
CACHED false
EXECUTIONTIME 1
SQL SELECT distinct (b.attr1) as origAttr1, max(b.attr1_alias) as attr1_alias, 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) as qoh, max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam, max(a.style_id) as style_id, max(a.SCALE_ENTRY_ID) as size FROM tb_skus a LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id) INNER JOIN ( SELECT DISTINCT sku_id , sum(qoh+qc) as qoh FROM dbo.tb_sku_buckets WITH (NOLOCK) WHERE store_id in(98,8,9,2,5,7,6,3) GROUP BY sku_id ) e on (a.sku_id = e.sku_id) LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1) LEFT JOIN tb_size_entries k WITH (NOLOCK) on (k.scale_entry_id = a.scale_entry_id) LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id) WHERE a.style_id =? AND (b.attr1_alias is null OR b.attr1_alias NOT IN ('NO SHOW','NOSHOW') ) AND e.qoh > 1 AND isNull(a.sell_web,'Y') = 'Y' GROUP BY b.attr1 ORDER BY sum(e.qoh) DESC --max(b.attr1_order), max(b.attr1_entry_id)
SQLPARAMETERS
array
1 107907
Eagle Creek Pack-It Original Quilted Mini Cube Set BLK_010 Eagle Creek Pack-It Original Quilted Mini Cube Set BLS_137 Eagle Creek Pack-It Original Quilted Mini Cube Set RED_138
One Size
query
RESULTSET
query
  ATTR1_ENTRY_ID ATTR2_ENTRY_ID DEPT PURCHASE_AMOUNT QOH SCALE_ENTRY_ID SKU_ID STORE_ID STYLE
1 115648 48193 05-LUGGAGE_TRAVEL [empty string] 26 116146 422676 98 EC0A37G3
2 115649 48193 05-LUGGAGE_TRAVEL [empty string] 16 116146 422677 98 EC0A37G3
3 115650 48193 05-LUGGAGE_TRAVEL [empty string] 4 116146 469452 98 EC0A37G3
CACHED false
EXECUTIONTIME 21
SQL SELECT sum(c.qoh+c.qc) as qoh ,max(b.sku_id) as sku_id , max(b.scale_entry_id) as scale_entry_id , max(b.attr2_entry_id) as attr2_entry_id , max(e.attr1_entry_id) as attr1_entry_id , max(g.dept) as dept , max(a.style) as style , max(c.store_id) as store_id , max(h.purchase_amount) as purchase_amount FROM tb_styles a LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id) LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id) LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id) LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id) LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id) LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id) LEFT JOIN web_product_information h WITH (NOLOCK) ON (a.style_id = h.style_id) WHERE (b.style_id IN ( SELECT style_id FROM tb_styles WHERE web_style = 'EC0A37G3' ) or b.style_id =?) and c.store_id in(98,8,9,2,5,7,6,3) --AND c.qoh > 1 and b.attr2_entry_id = 48193 and b.scale_entry_id = 116146 AND isNull(b.sell_web,'Y') = 'Y' GROUP BY b.sku_id ORDER BY b.sku_id
SQLPARAMETERS
array
1 107907
46
Add to Cart Find in Store Add to Wish List

product description

Big things come in small packages. The Eagle Creek Quilted Mini Cube Set is proof that travel cubes encompass this sentiment. This set allows you to safely protect and organize small jewelry, eye care toiletries, or small electronics with features like quilting for padding and internal see-through zip pockets for the extra small stuff. An ideal piece for traveling with precious tiny cargo, this Mini Cube Set protects your accessories to ease your mind while you're on the go.

product specs
  • Internal see-through zip pocket keeps small items secure
  • TPU Mesh-lined fabric makes visibility of your contents no problem
  • Quick grab handle is a special touch to seal the deal
  • Easy-to-wipe clean material is washable and offers protection from moisture
  • Capacity: 20cu in (each) | 0.3L (each)
  • Dimensions: 4 x 3 x 1.75in | 10 x 7.5 x 4.5cm
  • Weight: 2.9oz | 82g
  • Material: Quilted 300D Poly Micro-Weave

FREE SHIPPING* ON ORDERS OVER $100.00
My Bag (0)
Menu

query
RESULTSET
query
  ADDITIONAL_DESCRIPTION AGERANGE ALTIMAGERECORDCOUNT ATTR1ID ATTR1LIST ATTR2ID BRAND BRANDDISPLAY DEPT DEPTTREE DESCRIPTION FAMLIST GENDER GOOGLEPRODUCTTAXONOMY HEXLIST ID INSTORE_ONLY INTERNALLISTPRICE INTERNALMARKDOWN INTERNALPRICE KEYWORDS LARGEPICTURE LISTPRICE LOWESTPRICE MEDIUMPICTURE METADESC METATAGS NAME NEW OF1 OF10 OF11 OF12 OF13 OF14 OF15 OF16 OF17 OF18 OF19 OF2 OF20 OF3 OF4 OF5 OF6 OF7 OF8 OF9 ORIGBRAND OVERALLQOH OVERALL_RATING PAGETITLE PICTUREID PICTURE_ID PRICERANGE PRODREVIEWSAVERAGE PRODREVIEWSRECORDCOUNT QUANTITYONHANDSUM QUANTITYSOLDSUM RANKING REALNAME ROMANTICCOPYLONG ROMANTICCOPYSHORT SALE SALEPRICERANGEBOTTOM SALEPRICERANGETOP SCALEID SHIP_SURCHARGE SIZELIST SIZING_IMAGE_FILE SMALLPICTURE SORTPOSITION STYLE STYLE_ID SUBTYP1 SUBTYP2 SUBTYP3 TERMSALE TERMSALELISTPRICE TERMSALEPRICE TINYPICTURE TYP URL USEPACKAGE VIDEO WEBSTYLE WEB_OF1 WEB_OF10 WEB_OF11 WEB_OF12 WEB_OF13 WEB_OF14 WEB_OF15 WEB_OF16 WEB_OF17 WEB_OF18 WEB_OF19 WEB_OF2 WEB_OF20 WEB_OF3 WEB_OF4 WEB_OF5 WEB_OF6 WEB_OF7 WEB_OF8 WEB_OF9
1 <ul> <li>Internal see-through zip pocket keeps small items secure</li> <li>TPU Mesh-lined fabric makes visibility of your contents no problem</li> <li>Quick grab handle is a special touch to seal the deal</li> <li>Easy-to-wipe clean material is washable and offers protection from moisture</li> <li>Capacity: 20cu in (each) | 0.3L (each)</li> <li>Dimensions: 4 x 3 x 1.75in | 10 x 7.5 x 4.5cm</li> <li>Weight: 2.9oz | 82g</li> <li>Material: Quilted 300D Poly Micro-Weave</li> </ul> [empty string] [empty string] 54728 BLK_010,BLS_137,RED_138, 48171 EAGLE CREEK Eagle Creek TRAVEL & OUTDOOR GEAR Travel & Outdoor Gear [empty string] [empty string] [empty string] 596 [empty string] 27372441 [empty string] 24.95 24 24.95 [empty string] 12155-DEFAULT-l.jpg 24.95 [empty string] 12155-DEFAULT-m.jpg The Eagle Creek Quilted Mini Cube Set is perfect for small jewelry, eye care toiletries, or small electronics. [empty string] PACK-IT ORIGINAL QUILTED MINI CUBE SET N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] ACTIVE [empty string] 05C [empty string] [empty string] FALL_1 [empty string] [empty string] [empty string] [empty string] EAGLE CREEK, INC. 45 0 [empty string] 12155 12155 20-to-25 0.00 0 [empty string] [empty string] [empty string] Eagle Creek Pack-It Original Quilted Mini Cube Set <p>Big things come in small packages. The Eagle Creek Quilted Mini Cube Set is proof that travel cubes encompass this sentiment. This set allows you to safely protect and organize small jewelry, eye care toiletries, or small electronics with features like quilting for padding and internal see-through zip pockets for the extra small stuff. An ideal piece for traveling with precious tiny cargo, this Mini Cube Set protects your accessories to ease your mind while you&#39;re on the go.</p> [empty string] N 24.95 24.95 40792 0 One Size, [empty string] 12155-DEFAULT-s.jpg 1000 EC0A37G3 107907 EMPTY EMPTY EMPTY 0 [empty string] [empty string] 12155-DEFAULT-xs.jpg EMPTY shop/eagle-creek-pack-it-original-q-107907 0 [empty string] EC0A37G3 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string]
CACHED false
EXECUTIONTIME 6
SQL SELECT * from [dbo].[web_all_products] WHERE style_id='107907' order by ID desc