ATOM SLING 8L PACK
- Description
- Specs
- Reviews
- Live Chat
Great for commuting, biking, or hiking — the Atom Sling is at your service and ready to roll! It combines the comfort of a backpack, the convenience of a shoulder bag, and the ergonomic design of a courier's tote. Made of strong, lightweight recycled polyester with a DWR finish, the 8-liter carrier comes with lots of pockets in which to stash essentials. Its teardrop shape aids in positioning the pack right behind your shoulders keeping it out of the way as you navigate crowded areas. The simple design allows you to access the bag without having to take it off — simply spin it around front. 3-D spacer mesh in the shoulder strap and back panel keep you cool, and there's a zippered pocket on the shoulder strap that is lined to protect your valuables. The Atom Sling is the perfect companion for those everyday adventures.
- Two-compartment sling has just enough room for daily essentials
- Asymmetrical harness carries close to body for all-day comfort
- Exterior compression manages loads and securely holds a yoga mat or spare jacket
- Soft and highly breathable mesh on back panel and harness
- Large and expandable pocket on the chest/shoulder strap holds most cell phones
- Padded tablet sleeve
- Material (Body): 7.4-ounce 630-denier 100% nylon (50% recycled/50% high-tenacity) plain weave with a polyurethane coating and a DWR (durable water repellent) finish
- Lining: 3.3-ounce 200-denier 100% recycled polyester
- Volume: 8 liters (488 cubic inches)
- Weight: 10.1 ounces (286 g)
- Imported
No Reviews Yet!
-
Description
Great for commuting, biking, or hiking — the Atom Sling is at your service and ready to roll! It combines the comfort of a backpack, the convenience of a shoulder bag, and the ergonomic design of a courier's tote. Made of strong, lightweight recycled polyester with a DWR finish, the 8-liter carrier comes with lots of pockets in which to stash essentials. Its teardrop shape aids in positioning the pack right behind your shoulders keeping it out of the way as you navigate crowded areas. The simple design allows you to access the bag without having to take it off — simply spin it around front. 3-D spacer mesh in the shoulder strap and back panel keep you cool, and there's a zippered pocket on the shoulder strap that is lined to protect your valuables. The Atom Sling is the perfect companion for those everyday adventures.
-
Specs
- Two-compartment sling has just enough room for daily essentials
- Asymmetrical harness carries close to body for all-day comfort
- Exterior compression manages loads and securely holds a yoga mat or spare jacket
- Soft and highly breathable mesh on back panel and harness
- Large and expandable pocket on the chest/shoulder strap holds most cell phones
- Padded tablet sleeve
- Material (Body): 7.4-ounce 630-denier 100% nylon (50% recycled/50% high-tenacity) plain weave with a polyurethane coating and a DWR (durable water repellent) finish
- Lining: 3.3-ounce 200-denier 100% recycled polyester
- Volume: 8 liters (488 cubic inches)
- Weight: 10.1 ounces (286 g)
- Imported
-
Reviews
No Reviews Yet!
- Live Chat
$59.00
Choose Color
-
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 AGAVE_PLUME_GREY 132395 [empty string] [empty string] 0 1 0 0 AGAVE_PLUME_GREY 2 Y [empty string] 991227 [empty string] 210984 2 CANYON_HIKE_SAFFRON 132397 [empty string] [empty string] 0 1 0 0 CANYON_HIKE_SAFFRON 4 Y [empty string] 991229 [empty string] 210984 3 FORGE_GREY 132398 [empty string] [empty string] 0 3 0 0 FORGE_GREY 16 Y [empty string] 991230 [empty string] 210984 4 PAMPAS_TAN 132399 [empty string] [empty string] 0 1 0 0 PAMPAS_TAN 4 Y [empty string] 991231 [empty string] 210984 5 ROSEHIP 132400 [empty string] [empty string] 0 3 0 0 ROSEHIP 9 Y [empty string] 991232 [empty string] 210984 6 TIDEPOOL_BLUE 132401 [empty string] [empty string] 0 2 0 0 TIDEPOOL_BLUE 3 Y [empty string] 991233 [empty string] 210984 7 BLACK 132402 [empty string] [empty string] 0 3 0 0 BLACK 4 Y [empty string] 991244 [empty string] 210984 CACHED false EXECUTIONTIME 0 SQL 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,14,6,5,9,8,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,14,6,5,9,8,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 210984 struct INTERNALLISTPRICE 59 INTERNALMARKDOWN false INTERNALPRICE 59 REG 59 SALE 59 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 AGAVE_PLUME_GREY 132395 [empty string] [empty string] 0 1 0 0 AGAVE_PLUME_GREY 2 Y [empty string] 991227 [empty string] 210984 2 CANYON_HIKE_SAFFRON 132397 [empty string] [empty string] 0 1 0 0 CANYON_HIKE_SAFFRON 4 Y [empty string] 991229 [empty string] 210984 3 FORGE_GREY 132398 [empty string] [empty string] 0 3 0 0 FORGE_GREY 16 Y [empty string] 991230 [empty string] 210984 4 PAMPAS_TAN 132399 [empty string] [empty string] 0 1 0 0 PAMPAS_TAN 4 Y [empty string] 991231 [empty string] 210984 5 ROSEHIP 132400 [empty string] [empty string] 0 3 0 0 ROSEHIP 9 Y [empty string] 991232 [empty string] 210984 6 TIDEPOOL_BLUE 132401 [empty string] [empty string] 0 2 0 0 TIDEPOOL_BLUE 3 Y [empty string] 991233 [empty string] 210984 7 BLACK 132402 [empty string] [empty string] 0 3 0 0 BLACK 4 Y [empty string] 991244 [empty string] 210984 CACHED false EXECUTIONTIME 0 SQL 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,14,6,5,9,8,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,14,6,5,9,8,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 210984 struct INTERNALLISTPRICE 59 INTERNALMARKDOWN false INTERNALPRICE 59 REG 59 SALE 59 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 AGAVE_PLUME_GREY 132395 [empty string] [empty string] 0 1 0 0 AGAVE_PLUME_GREY 2 Y [empty string] 991227 [empty string] 210984 2 CANYON_HIKE_SAFFRON 132397 [empty string] [empty string] 0 1 0 0 CANYON_HIKE_SAFFRON 4 Y [empty string] 991229 [empty string] 210984 3 FORGE_GREY 132398 [empty string] [empty string] 0 3 0 0 FORGE_GREY 16 Y [empty string] 991230 [empty string] 210984 4 PAMPAS_TAN 132399 [empty string] [empty string] 0 1 0 0 PAMPAS_TAN 4 Y [empty string] 991231 [empty string] 210984 5 ROSEHIP 132400 [empty string] [empty string] 0 3 0 0 ROSEHIP 9 Y [empty string] 991232 [empty string] 210984 6 TIDEPOOL_BLUE 132401 [empty string] [empty string] 0 2 0 0 TIDEPOOL_BLUE 3 Y [empty string] 991233 [empty string] 210984 7 BLACK 132402 [empty string] [empty string] 0 3 0 0 BLACK 4 Y [empty string] 991244 [empty string] 210984 CACHED false EXECUTIONTIME 0 SQL 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,14,6,5,9,8,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,14,6,5,9,8,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 210984 struct INTERNALLISTPRICE 59 INTERNALMARKDOWN false INTERNALPRICE 59 REG 59 SALE 59 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 AGAVE_PLUME_GREY 132395 [empty string] [empty string] 0 1 0 0 AGAVE_PLUME_GREY 2 Y [empty string] 991227 [empty string] 210984 2 CANYON_HIKE_SAFFRON 132397 [empty string] [empty string] 0 1 0 0 CANYON_HIKE_SAFFRON 4 Y [empty string] 991229 [empty string] 210984 3 FORGE_GREY 132398 [empty string] [empty string] 0 3 0 0 FORGE_GREY 16 Y [empty string] 991230 [empty string] 210984 4 PAMPAS_TAN 132399 [empty string] [empty string] 0 1 0 0 PAMPAS_TAN 4 Y [empty string] 991231 [empty string] 210984 5 ROSEHIP 132400 [empty string] [empty string] 0 3 0 0 ROSEHIP 9 Y [empty string] 991232 [empty string] 210984 6 TIDEPOOL_BLUE 132401 [empty string] [empty string] 0 2 0 0 TIDEPOOL_BLUE 3 Y [empty string] 991233 [empty string] 210984 7 BLACK 132402 [empty string] [empty string] 0 3 0 0 BLACK 4 Y [empty string] 991244 [empty string] 210984 CACHED false EXECUTIONTIME 0 SQL 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,14,6,5,9,8,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,14,6,5,9,8,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 210984 struct INTERNALLISTPRICE 59 INTERNALMARKDOWN false INTERNALPRICE 59 REG 59 SALE 59 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 AGAVE_PLUME_GREY 132395 [empty string] [empty string] 0 1 0 0 AGAVE_PLUME_GREY 2 Y [empty string] 991227 [empty string] 210984 2 CANYON_HIKE_SAFFRON 132397 [empty string] [empty string] 0 1 0 0 CANYON_HIKE_SAFFRON 4 Y [empty string] 991229 [empty string] 210984 3 FORGE_GREY 132398 [empty string] [empty string] 0 3 0 0 FORGE_GREY 16 Y [empty string] 991230 [empty string] 210984 4 PAMPAS_TAN 132399 [empty string] [empty string] 0 1 0 0 PAMPAS_TAN 4 Y [empty string] 991231 [empty string] 210984 5 ROSEHIP 132400 [empty string] [empty string] 0 3 0 0 ROSEHIP 9 Y [empty string] 991232 [empty string] 210984 6 TIDEPOOL_BLUE 132401 [empty string] [empty string] 0 2 0 0 TIDEPOOL_BLUE 3 Y [empty string] 991233 [empty string] 210984 7 BLACK 132402 [empty string] [empty string] 0 3 0 0 BLACK 4 Y [empty string] 991244 [empty string] 210984 CACHED false EXECUTIONTIME 0 SQL 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,14,6,5,9,8,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,14,6,5,9,8,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 210984 struct INTERNALLISTPRICE 59 INTERNALMARKDOWN false INTERNALPRICE 59 REG 59 SALE 59 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 AGAVE_PLUME_GREY 132395 [empty string] [empty string] 0 1 0 0 AGAVE_PLUME_GREY 2 Y [empty string] 991227 [empty string] 210984 2 CANYON_HIKE_SAFFRON 132397 [empty string] [empty string] 0 1 0 0 CANYON_HIKE_SAFFRON 4 Y [empty string] 991229 [empty string] 210984 3 FORGE_GREY 132398 [empty string] [empty string] 0 3 0 0 FORGE_GREY 16 Y [empty string] 991230 [empty string] 210984 4 PAMPAS_TAN 132399 [empty string] [empty string] 0 1 0 0 PAMPAS_TAN 4 Y [empty string] 991231 [empty string] 210984 5 ROSEHIP 132400 [empty string] [empty string] 0 3 0 0 ROSEHIP 9 Y [empty string] 991232 [empty string] 210984 6 TIDEPOOL_BLUE 132401 [empty string] [empty string] 0 2 0 0 TIDEPOOL_BLUE 3 Y [empty string] 991233 [empty string] 210984 7 BLACK 132402 [empty string] [empty string] 0 3 0 0 BLACK 4 Y [empty string] 991244 [empty string] 210984 CACHED false EXECUTIONTIME 0 SQL 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,14,6,5,9,8,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,14,6,5,9,8,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 210984 struct INTERNALLISTPRICE 59 INTERNALMARKDOWN false INTERNALPRICE 59 REG 59 SALE 59 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 AGAVE_PLUME_GREY 132395 [empty string] [empty string] 0 1 0 0 AGAVE_PLUME_GREY 2 Y [empty string] 991227 [empty string] 210984 2 CANYON_HIKE_SAFFRON 132397 [empty string] [empty string] 0 1 0 0 CANYON_HIKE_SAFFRON 4 Y [empty string] 991229 [empty string] 210984 3 FORGE_GREY 132398 [empty string] [empty string] 0 3 0 0 FORGE_GREY 16 Y [empty string] 991230 [empty string] 210984 4 PAMPAS_TAN 132399 [empty string] [empty string] 0 1 0 0 PAMPAS_TAN 4 Y [empty string] 991231 [empty string] 210984 5 ROSEHIP 132400 [empty string] [empty string] 0 3 0 0 ROSEHIP 9 Y [empty string] 991232 [empty string] 210984 6 TIDEPOOL_BLUE 132401 [empty string] [empty string] 0 2 0 0 TIDEPOOL_BLUE 3 Y [empty string] 991233 [empty string] 210984 7 BLACK 132402 [empty string] [empty string] 0 3 0 0 BLACK 4 Y [empty string] 991244 [empty string] 210984 CACHED false EXECUTIONTIME 0 SQL 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,14,6,5,9,8,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,14,6,5,9,8,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 210984 struct INTERNALLISTPRICE 59 INTERNALMARKDOWN false INTERNALPRICE 59 REG 59 SALE 59 TERMSALE false TERMSALELISTPRICE 0 TERMSALEPRICE 0