29" Lab Coat in DWHZ

Style: 84406 Color: DWHZ

Choose a size:

Size Chart

Selected Color:

20.97

Please Choose A Size

About This Product

A 29" fashion lab coat features a notched collar, princess seams And a four button closure. Also featured are two patch pockets and the right pocket has additional sectional pockets for instruments and accessories. Back princess seams and back belt complete this coat.

Fabric: Brushed 60 Cotton/40 Poly Twill

More like this

More in this style 29" Lab Coat (84406)

More in this color (DWHZ)

Size Chart

Dickies: 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 ( [category_name] => Dickies [description] => Array ( [short] => [long] => ) [required] => Array ( [gba] => Array ( [0] => 89 ) [ba] => Array ( [0] => 8901 ) ) ) RegisterFilter in BaseSearch.php szFilterField: gba szFilterVal: 89 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 8901 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: style_id szFilterVal: 84406 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: color_id szFilterVal: DWHZ szFilterType: required RegisterFilter in BaseSearch.php szFilterField: start_num szFilterVal: 24 szFilterType: required ! ignored filter start_num 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 ( [group] => Array ( [ba] => Array ( [0] => 89 ) ) [ba] => Array ( [0] => 8901 ) [style_id] => Array ( [0] => 84406 ) [color_id] => Array ( [0] => DWHZ ) ) ) Starting RefactorRequired in QueryBuilderBase::RefactorRequired field=ba value= 8901 group=89 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 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 req1_ba.sci_group_id = '89' 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 ('8901') AND req1_ba.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= 84406 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 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 ('84406') AND req1_s.status = 0 AND req1_ba.sci_group_id = '89' 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 ('8901') AND req1_ba.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= DWHZ 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, sci_attribute req1_ba, ( 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 ('DWHZ') AND req1_c.status = 0 AND p.style_id = req1_s.style_id AND req1_s.style_id IN ('84406') AND req1_s.status = 0 AND req1_ba.sci_group_id = '89' 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 ('8901') AND req1_ba.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: | 8901 | 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, sci_attribute req1_ba, ( 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 ('DWHZ') AND req1_c.status = 0 AND p.style_id = req1_s.style_id AND req1_s.style_id IN ('84406') AND req1_s.status = 0 AND req1_ba.sci_group_id = '89' 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 ('8901') AND req1_ba.status = 0 AND p.style_id = '84406' 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.029331922531128 seconds Exiting Search in BaseSearch =============================================================================================== label: obj->type: apparel