"Youtility" Jr. Fit Mock Wrap Top in DSGZ

Style: 817355 Color: DSGZ

Choose a size:

Size Chart

Selected Color:

19.97

Please Choose A Size

Colors

La La Lemon
Grape

About This Product

A Junior fit mock wrap top features princess seaming for added shaping, non-functional snap details, two large patch pockets, multi-needle contrast top stitching, multi-sectional pockets for accessory storage and side vents. Center back length: 25 1/2".

Fabric: 52 Cotton/45 Poly/3 Spandex Twill

More like this

More in this style "Youtility" Jr. Fit Mock Wrap Top (817355)

More in this color (DSGZ)

Size Chart

Classic Missy Fit

Sizes
XXS
XS
S
M
L
XL
2XL
3XL
4XL
5XL
Size Comparison 0-1 2-4 6-8 10-12 14-16 18-20 22-24 26-28 30-32 34-36
Chest/Bust 31-32 33-34 35-36 37-39 40-43 44-47 48-51 52-55 56-59 60-63
Waist 23-24 25-26 27-28 29-31 32-35 36-39 40-43 44-47 48-51 52-55
Hip 34-35 36-37 37-38 39-41 42-45 46-49 50-53 54-57 60-62 64-67

Inseams: Regular 30.5", Petite 28", Tall 33.5"

SetCategoryInfo in BaseModel.php Array ( ) RegisterFilter in BaseSearch.php szFilterField: style_id szFilterVal: 817355 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: color_id szFilterVal: DSGZ szFilterType: required 1. I'm in the Search function in BaseSearch.php. SELECT p.upc_id, p.style_id, p.color_id, p.wholesale_price, c.color_name, c.color_description, s.style_name, s.style_description, p.quantity_ats, p.size_id, a.attribute_description, p.style_category_group_id FROM ( color c, style s, product p) LEFT JOIN sci_attribute scia ON (p.style_id = scia.style_id AND p.color_id = scia.color_id AND p.identifier_id = scia.identifier_id AND scia.sci_group_id = 5) LEFT JOIN attribute a ON (a.attribute_id = scia.sci_attribute_id) LEFT JOIN sci_attribute exscia ON (p.style_id = exscia.style_id AND p.color_id = exscia.color_id AND p.identifier_id=exscia.identifier_id AND exscia.sci_attribute_id = '647') WHERE p.style_id = '^' AND c.status = 0 AND s.status = 0 AND p.color_id = c.color_id AND p.style_id = s.style_id AND exscia.sci_attribute_id IS NULL In BaseSearch::GenerateQuery with 1 filters In BaseSearch::GenerateQuery filters are Array ( [required] => Array ( [style_id] => Array ( [0] => 817355 ) [color_id] => Array ( [0] => DSGZ ) ) ) Starting RefactorRequired in QueryBuilderBase::RefactorRequired field=style_id value= 817355 group= base:=style # join: p.style_id = #.style_id AND #.style_id = '?' AND #.status = 0 End RefactorRequired QueryBuilderBase::RefactorRequired query SELECT p.upc_id, p.style_id, p.color_id, p.wholesale_price, c.color_name, c.color_description, s.style_name, s.style_description, p.quantity_ats, p.size_id, a.attribute_description, p.style_category_group_id FROM style req1_s, ( color c, style s, product p) LEFT JOIN sci_attribute scia ON (p.style_id = scia.style_id AND p.color_id = scia.color_id AND p.identifier_id = scia.identifier_id AND scia.sci_group_id = 5) LEFT JOIN attribute a ON (a.attribute_id = scia.sci_attribute_id) LEFT JOIN sci_attribute exscia ON (p.style_id = exscia.style_id AND p.color_id = exscia.color_id AND p.identifier_id=exscia.identifier_id AND exscia.sci_attribute_id = '647') WHERE p.style_id = req1_s.style_id AND req1_s.style_id IN ('817355') AND req1_s.status = 0 AND p.style_id = '^' AND c.status = 0 AND s.status = 0 AND p.color_id = c.color_id AND p.style_id = s.style_id AND exscia.sci_attribute_id IS NULL Starting RefactorRequired in QueryBuilderBase::RefactorRequired field=color_id value= DSGZ group= base:=color # join: p.color_id = #.color_id AND #.color_id = '?' AND #.status = 0 End RefactorRequired QueryBuilderBase::RefactorRequired query SELECT p.upc_id, p.style_id, p.color_id, p.wholesale_price, c.color_name, c.color_description, s.style_name, s.style_description, p.quantity_ats, p.size_id, a.attribute_description, p.style_category_group_id FROM color req1_c, style req1_s, ( color c, style s, product p) LEFT JOIN sci_attribute scia ON (p.style_id = scia.style_id AND p.color_id = scia.color_id AND p.identifier_id = scia.identifier_id AND scia.sci_group_id = 5) LEFT JOIN attribute a ON (a.attribute_id = scia.sci_attribute_id) LEFT JOIN sci_attribute exscia ON (p.style_id = exscia.style_id AND p.color_id = exscia.color_id AND p.identifier_id=exscia.identifier_id AND exscia.sci_attribute_id = '647') WHERE p.color_id = req1_c.color_id AND req1_c.color_id IN ('DSGZ') AND req1_c.status = 0 AND p.style_id = req1_s.style_id AND req1_s.style_id IN ('817355') AND req1_s.status = 0 AND p.style_id = '^' AND c.status = 0 AND s.status = 0 AND p.color_id = c.color_id AND p.style_id = s.style_id AND exscia.sci_attribute_id IS NULL Checking for a brand RefactorQuery: | | 1; Not needed =============================================================================================== Executed this query: SELECT p.upc_id, p.style_id, p.color_id, p.wholesale_price, c.color_name, c.color_description, s.style_name, s.style_description, p.quantity_ats, p.size_id, a.attribute_description, p.style_category_group_id FROM color req1_c, style req1_s, ( color c, style s, product p) LEFT JOIN sci_attribute scia ON (p.style_id = scia.style_id AND p.color_id = scia.color_id AND p.identifier_id = scia.identifier_id AND scia.sci_group_id = 5) LEFT JOIN attribute a ON (a.attribute_id = scia.sci_attribute_id) LEFT JOIN sci_attribute exscia ON (p.style_id = exscia.style_id AND p.color_id = exscia.color_id AND p.identifier_id=exscia.identifier_id AND exscia.sci_attribute_id = '647') WHERE p.color_id = req1_c.color_id AND req1_c.color_id IN ('DSGZ') AND req1_c.status = 0 AND p.style_id = req1_s.style_id AND req1_s.style_id IN ('817355') AND req1_s.status = 0 AND p.style_id = '817355' AND c.status = 0 AND s.status = 0 AND p.color_id = c.color_id AND p.style_id = s.style_id AND exscia.sci_attribute_id IS NULL =============================================================================================== No errors found. Well done! Attaching Attributes to results 1 style attributes found 1 color attributes found 1 sci attributes found Exiting attribute attachment after 0.0053699016571045 seconds Exiting Search in BaseSearch =============================================================================================== label: obj->type: apparel