Round Neck Top in CIEW

Style: 4740 Color: CIEW

Choose a size:

Size Chart

Selected Color:

See Cart For Price

Please Choose A Size

Colors

About This Product

A round neck V-notch top features a unique layered effect with soft knit inset at front neck. Bust darts and back release darts create a flattering shape. Sleeve length finishes above the elbow with notched vent at sleeve hem. Two roomy patch pockets, one cell phone pocket, and side vents complete this top. Center back length is 26 1/2".

Fabric: 65 Poly/35 Cotton Poplin w/ Soil Release

More like this

More in this style Round Neck Top (4740)

More in this color (CIEW)

Size Chart

Women

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

Regular inseams 30-31"
Petite inseams 27 1/2 - 28 1/2"
Tall inseams 33-34"
Ultra Tall inseams 36" unhemmed

SetCategoryInfo in BaseModel.php Array ( ) RegisterFilter in BaseSearch.php szFilterField: style_id szFilterVal: 4740 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: color_id szFilterVal: CIEW 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] => 4740 ) [color_id] => Array ( [0] => CIEW ) ) ) Starting RefactorRequired in QueryBuilderBase::RefactorRequired field=style_id value= 4740 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 ('4740') 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= CIEW 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 ('CIEW') AND req1_c.status = 0 AND p.style_id = req1_s.style_id AND req1_s.style_id IN ('4740') 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 ('CIEW') AND req1_c.status = 0 AND p.style_id = req1_s.style_id AND req1_s.style_id IN ('4740') AND req1_s.status = 0 AND p.style_id = '4740' 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.003849983215332 seconds Exiting Search in BaseSearch =============================================================================================== label: obj->type: apparel