Round Neck Embroidered Top

A round neck top features contrast piping and floral embroidery on the left side of neckline. Contrast empire waistband, patch pockets, back elastic, and side vents complete the picture. Center back length: 25 1/2"

Fabric: 100% Cotton Sheeting

Available Sizes: XS - 2XL Size Chart

Coordinating Colors

Pants in these colors coordinate well with this top. Click to browse.

Ready to Shop?

Search the store locator for your nearest uniform retailer.

Style 3906CB in color NTLE
SetCategoryInfo in BaseModel.php Array ( [category_name] => Runway Prints [description] => Array ( [short] => [long] => ) [required] => Array ( [gca] => Array ( [0] => 30 ) [ca] => Array ( [0] => 3010 ) [ba] => Array ( [0] => 89101 ) ) ) RegisterFilter in BaseSearch.php szFilterField: gca szFilterVal: 30 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: ca szFilterVal: 3010 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 89101 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: style_id szFilterVal: 3906CB szFilterType: required RegisterFilter in BaseSearch.php szFilterField: color_id szFilterVal: NTLE 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, marketing_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 = '648') 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 ( [group] => Array ( [ca] => Array ( [0] => 30 ) ) [ca] => Array ( [0] => 3010 ) [ba] => Array ( [0] => 89101 ) [style_id] => Array ( [0] => 3906CB ) [color_id] => Array ( [0] => NTLE ) ) ) Starting RefactorRequired in QueryBuilderBase::RefactorRequired field=ca value= 3010 group=30 base:=color_attribute # join: p.color_id = #.color_id AND #.color_attribute_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_attribute req1_ca, ( color c, style s, marketing_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 = '648') WHERE req1_ca.color_group_id = '30' AND p.color_id = req1_ca.color_id AND req1_ca.color_attribute_id IN ('3010') AND req1_ca.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=ba value= 89101 group= base:=sci_attribute # join: p.style_id = #.style_id AND p.color_id = #.color_id AND p.identifier_id = #.identifier_id AND #.sci_group_id='89' AND #.sci_attribute_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 sci_attribute req1_ba, color_attribute req1_ca, ( color c, style s, marketing_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 = '648') WHERE p.style_id = req1_ba.style_id AND p.color_id = req1_ba.color_id AND p.identifier_id = req1_ba.identifier_id AND req1_ba.sci_group_id='89' AND req1_ba.sci_attribute_id IN ('89101') AND req1_ba.status = 0 AND req1_ca.color_group_id = '30' AND p.color_id = req1_ca.color_id AND req1_ca.color_attribute_id IN ('3010') AND req1_ca.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=style_id value= 3906CB 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, sci_attribute req1_ba, color_attribute req1_ca, ( color c, style s, marketing_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 = '648') WHERE p.style_id = req1_s.style_id AND req1_s.style_id IN ('3906CB') AND req1_s.status = 0 AND p.style_id = req1_ba.style_id AND p.color_id = req1_ba.color_id AND p.identifier_id = req1_ba.identifier_id AND req1_ba.sci_group_id='89' AND req1_ba.sci_attribute_id IN ('89101') AND req1_ba.status = 0 AND req1_ca.color_group_id = '30' AND p.color_id = req1_ca.color_id AND req1_ca.color_attribute_id IN ('3010') AND req1_ca.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= NTLE 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 req2_c, style req1_s, sci_attribute req1_ba, color_attribute req1_ca, ( color c, style s, marketing_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 = '648') WHERE p.color_id = req2_c.color_id AND req2_c.color_id IN ('NTLE') AND req2_c.status = 0 AND p.style_id = req1_s.style_id AND req1_s.style_id IN ('3906CB') AND req1_s.status = 0 AND p.style_id = req1_ba.style_id AND p.color_id = req1_ba.color_id AND p.identifier_id = req1_ba.identifier_id AND req1_ba.sci_group_id='89' AND req1_ba.sci_attribute_id IN ('89101') AND req1_ba.status = 0 AND req1_ca.color_group_id = '30' AND p.color_id = req1_ca.color_id AND req1_ca.color_attribute_id IN ('3010') AND req1_ca.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: | 89101 | 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 req2_c, style req1_s, sci_attribute req1_ba, color_attribute req1_ca, ( color c, style s, marketing_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 = '648') WHERE p.color_id = req2_c.color_id AND req2_c.color_id IN ('NTLE') AND req2_c.status = 0 AND p.style_id = req1_s.style_id AND req1_s.style_id IN ('3906CB') AND req1_s.status = 0 AND p.style_id = req1_ba.style_id AND p.color_id = req1_ba.color_id AND p.identifier_id = req1_ba.identifier_id AND req1_ba.sci_group_id='89' AND req1_ba.sci_attribute_id IN ('89101') AND req1_ba.status = 0 AND req1_ca.color_group_id = '30' AND p.color_id = req1_ca.color_id AND req1_ca.color_attribute_id IN ('3010') AND req1_ca.status = 0 AND p.style_id = '3906CB' 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.0044939517974854 seconds Exiting Search in BaseSearch =============================================================================================== label: obj->type: apparel