Boys Flat Front Pant (Sizes 4-7) in BLK

Style: 50361 Color: BLK

Choose a size:

Size Chart

Also available in: Boys Husky 8h-20h, Mens 28-48, Boys 8-20

Selected Color:

11.97

Please Choose A Size

Colors

About This Product

Boys flat-front pant with double knee. Waist has center-back elastic and hook-and-eye closure. Soil-release treated poly/cotton twill holds color and releases stains with little or no ironing. Imported. For Boys 8-20 see style 50362, for Boys 8-16 Slim see style 50362S, for Boys Husky see style 50363, for men's sizes 28-48 see 50364(32" inseam), 50364S (30" inseam), 50364T (34" inseam).

More like this

More in this style Boys Flat Front Pant (50361)

More in this color (BLK)

Size Chart

Classroom Uniforms: Boys Average Size Range 4-7

Sizes
4
5
6
7
Height 39-41 42-44 45-47 48-50
Chest 22-22.5 23-23.5 24-24.5 25-25.5
Waist 20.5-21 21.5-22 22.5-23 23.5-24
Hip/Seat 22-22.5 23-23.5 24-24.5 25-25.5
Inseam To Floor 17 18.5 21 22.5
SetCategoryInfo in BaseModel.php Array ( [category_name] => Boys [description] => Array ( [short] => [long] => We take a little extra care when we design our products: sleeves are reinforced with double-stitching, materials have a built in resistance to fading so colors stay bright, three-button plackets, and generous full cuts for freedom and movement. All styles are made from heavyweight 60% cotton / 40% poly and come in a full range of sizes from youth's extra-extra small to adult triple-extra large. ) [required] => Array ( [gba] => Array ( [0] => 89 ) [gscia] => Array ( [0] => 143 ) [ba] => Array ( [0] => 8908 ) ) [optional] => Array ( [scia] => Array ( [0] => 1433 [1] => 1436 [2] => 1440 ) ) ) RegisterFilter in BaseSearch.php szFilterField: gba szFilterVal: 89 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: gscia szFilterVal: 143 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 8908 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: scia szFilterVal: 1433 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: scia szFilterVal: 1436 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: scia szFilterVal: 1440 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: style_id szFilterVal: 50361 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: color_id szFilterVal: BLK 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 2 filters In BaseSearch::GenerateQuery filters are Array ( [required] => Array ( [group] => Array ( [ba] => Array ( [0] => 89 ) [scia] => Array ( [0] => 143 ) ) [ba] => Array ( [0] => 8908 ) [style_id] => Array ( [0] => 50361 ) [color_id] => Array ( [0] => BLK ) ) [optional] => Array ( [scia] => Array ( [0] => 1433 [1] => 1436 [2] => 1440 ) ) ) Starting RefactorRequired in QueryBuilderBase::RefactorRequired field=ba value= 8908 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 ('8908') 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= 50361 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 ('50361') 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 ('8908') 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= BLK 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 ('BLK') AND req1_c.status = 0 AND p.style_id = req1_s.style_id AND req1_s.style_id IN ('50361') 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 ('8908') 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 RefactorOptional in QueryBuilderBase::RefactorOptional field=scia value= group= base:=sci_attribute # join: p.style_id = #.style_id AND p.color_id = #.color_id AND p.identifier_id = #.identifier_id AND #.sci_attribute_id = '?' AND #.status = 0 End RefactorOptional QueryBuilderBase::RefactorOptional 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 opt1_scia, 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.style_id = opt1_scia.style_id AND p.color_id = opt1_scia.color_id AND p.identifier_id = opt1_scia.identifier_id AND opt1_scia.sci_attribute_id IN ('1433','1436','1440') AND opt1_scia.status = 0 AND p.color_id = req1_c.color_id AND req1_c.color_id IN ('BLK') AND req1_c.status = 0 AND p.style_id = req1_s.style_id AND req1_s.style_id IN ('50361') 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 ('8908') 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: | 8908 | 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 sci_attribute opt1_scia, 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.style_id = opt1_scia.style_id AND p.color_id = opt1_scia.color_id AND p.identifier_id = opt1_scia.identifier_id AND opt1_scia.sci_attribute_id IN ('1433','1436','1440') AND opt1_scia.status = 0 AND p.color_id = req1_c.color_id AND req1_c.color_id IN ('BLK') AND req1_c.status = 0 AND p.style_id = req1_s.style_id AND req1_s.style_id IN ('50361') 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 ('8908') AND req1_ba.status = 0 AND p.style_id = '50361' 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.049540996551514 seconds Exiting Search in BaseSearch =============================================================================================== label: obj->type: classroom