TOAD AND CO

Toad&Co Women's Chaka Skirt

$60.00

Item # T1182127

query
RESULTSET
query
  ORIGSIZ QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SKU_ID STYLE_ID
1 XS 8 120631 XS [empty string] 531520 109554
2 S 7 120632 S [empty string] 531521 109554
3 M 13 120633 M [empty string] 531522 109554
4 L 9 120634 L [empty string] 531523 109554
5 XL 3 120635 XL [empty string] 531524 109554
CACHED false
EXECUTIONTIME 1157
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 T1182127
2 109554
query
RESULTSET
query
  ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID FAM HEX ORIGATTR1 QOH SIZE SKU_ID SORT_ORDER STYLE_ID
1 BLACK [empty string] 135138 [empty string] [empty string] BLACK 22 120634 432658 [empty string] 109554
2 BUFFALO_242 [empty string] 135145 [empty string] [empty string] BUFFALO_242 18 120635 531524 [empty string] 109554
CACHED false
EXECUTIONTIME 0
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 109554
Toad&Co Women's Chaka Skirt BLACK Toad&Co Women's Chaka Skirt BUFFALO_242
XS S M L XL
query
RESULTSET
query
  ATTR1_ENTRY_ID ATTR2_ENTRY_ID DEPT PURCHASE_AMOUNT QOH SCALE_ENTRY_ID SKU_ID STORE_ID STYLE
1 135138 49493 72-W/S SPORTSWEAR [empty string] 5 120631 432652 98 T1182127
2 135138 49493 72-W/S SPORTSWEAR [empty string] 4 120632 432654 98 T1182127
3 135138 49493 72-W/S SPORTSWEAR [empty string] 6 120633 432656 98 T1182127
4 135138 49493 72-W/S SPORTSWEAR [empty string] 7 120634 432658 98 T1182127
5 135138 49493 72-W/S SPORTSWEAR [empty string] 1 120635 432660 98 T1182127
6 135140 49493 72-W/S SPORTSWEAR [empty string] 0 120631 478102 98 T1182127
7 135140 49493 72-W/S SPORTSWEAR [empty string] 0 120632 478103 98 T1182127
8 135140 49493 72-W/S SPORTSWEAR [empty string] 0 120633 478104 98 T1182127
9 135140 49493 72-W/S SPORTSWEAR [empty string] 0 120634 478105 98 T1182127
10 135140 49493 72-W/S SPORTSWEAR [empty string] 0 120635 478106 98 T1182127
11 135141 49493 72-W/S SPORTSWEAR [empty string] 0 120631 478107 98 T1182127
12 135141 49493 72-W/S SPORTSWEAR [empty string] 0 120632 478108 98 T1182127
13 135141 49493 72-W/S SPORTSWEAR [empty string] 0 120633 478109 98 T1182127
14 135141 49493 72-W/S SPORTSWEAR [empty string] 0 120634 478110 98 T1182127
15 135141 49493 72-W/S SPORTSWEAR [empty string] 0 120635 478111 98 T1182127
16 135145 49493 72-W/S SPORTSWEAR [empty string] 3 120631 531520 98 T1182127
17 135145 49493 72-W/S SPORTSWEAR [empty string] 3 120632 531521 98 T1182127
18 135145 49493 72-W/S SPORTSWEAR [empty string] 7 120633 531522 98 T1182127
19 135145 49493 72-W/S SPORTSWEAR [empty string] 2 120634 531523 98 T1182127
20 135145 49493 72-W/S SPORTSWEAR [empty string] 3 120635 531524 98 T1182127
CACHED false
EXECUTIONTIME 31
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 = 'T1182127' ) 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 = 49493 AND isNull(b.sell_web,'Y') = 'Y' GROUP BY b.sku_id ORDER BY b.sku_id
SQLPARAMETERS
array
1 109554
41
Add to Cart Find in Store Add to Wish List

product description Remember the girl in college who could dance all night and ace her finals the next morning? Maybe she was you. Either way, here’s the skirt equivalent. The Toad&Co Women's Chaka Skirt has a wide, gathered waistband that’s flattering, even when you’re burning the candle at both ends. The A–line silhouette keeps things from getting too serious. The bottom hem falls a few inches above the knee, calling for flats in the day and boots when the sun goes down. This super versatile skirt is made from Samba fabric, an eco–responsible blend of Tencel® and organic cotton.
product specs
  • Fabric: Samba 48% Tencel®, 48% Organic Cotton, 4% Spandex
  • Movement friendly stretch
  • Moisture-wicking
  • Ruched elastic waistband with inside stash pocket
  • A–line silhouette
  • bluesign® certified fabric
  • OEKO-TEX 100® certified fabric
  • Lengths: XS: 19.5in, S: 20in, M: 20.5in, L: 21in, XL: 21.5in
Overall Rating

0.0/5.0

Review Stats 0 total reviews

5 0

4 0

3 0

2 0

1 0

Write a Review
Very Poor Poor Average Very Good Excellent
Name: *
Location:
Review Title:
Review: * (maximum 1000 characters)
1 - 0 of 0

No reviews have been written for this product.
Be the first one!  –


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 <li>Fabric: Samba 48% Tencel&reg;, 48% Organic Cotton, 4% Spandex</li> <li>Movement friendly stretch</li> <li>Moisture-wicking</li> <li>Ruched elastic waistband with inside stash pocket</li> <li>A&ndash;line silhouette</li> <li>bluesign&reg; certified fabric</li> <li>OEKO-TEX 100&reg; certified fabric</li> <li>Lengths: XS: 19.5in, S: 20in, M: 20.5in, L: 21in, XL: 21.5in</li> [empty string] [empty string] 61195 BLACK,BUFFALO_242, 49471 TOAD AND CO TOAD AND CO CLOTHING & FOOTWEAR Clothing & Footwear &gt Women's &gt Bottoms &gt Skirts [empty string] [empty string] [empty string] 596 [empty string] 27418446 [empty string] 60 60 60 [empty string] 23512-DEFAULT-l.jpg 60 [empty string] 23512-DEFAULT-m.jpg Go from work to the party with the super versatile Toad and Co Women's Chaka Skirt. It has a flattering wide, gathered waistband and an A–line silhouette keeps things from getting too serious. [empty string] W/ Chaka Skirt N NEWATTR [empty string] [empty string] [empty string] [empty string] BTSTFW [empty string] [empty string] PIN [empty string] [empty string] A 72K [empty string] [empty string] FALL_3 [empty string] [empty string] [empty string] N TOAD AND CO 40 0 [empty string] 23512 23512 50-to-100 0.00 0 [empty string] [empty string] [empty string] Toad&Co Women's Chaka Skirt Remember the girl in college who could dance all night and ace her finals the next morning? Maybe she was you. Either way, here&rsquo;s the skirt equivalent. The Toad&amp;Co Women&#39;s Chaka Skirt has a wide, gathered waistband that&rsquo;s flattering, even when you&rsquo;re burning the candle at both ends. The A&ndash;line silhouette keeps things from getting too serious. The bottom hem falls a few inches above the knee, calling for flats in the day and boots when the sun goes down. This super versatile skirt is made from Samba fabric, an eco&ndash;responsible blend of Tencel&reg; and organic cotton. [empty string] N 60 60 41991 0 L,M,S,XL,XS, [empty string] 23512-DEFAULT-s.jpg 1000 T1182127 109554 BOTTOMS SKIRTS EMPTY 0 [empty string] [empty string] 23512-DEFAULT-xs.jpg WOMENS shop/toadco-womens-chaka-skirt-109554 0 [empty string] T1182127 [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 15
SQL SELECT * from [dbo].[web_all_products] WHERE style_id='109554' order by ID desc