Unisex Pull-On Short (Sizes 8-20) in KAK

Style: 52132 Color: KAK

Choose a size:

Size Chart

Also available in: Boys Husky 8h-20h

Selected Color:

9.97

Please Choose A Size

Colors

About This Product

Pull-on short has triple-stitched all-elastic waist, side pockets, knee-length. Poly/cotton twill is soil release, easy-care, wash-and-wear. Imported. For Unisex sizes 4-7 see style 52131N, for Unisex Husky sizes 8H-20H see style see 52133.

More like this

More in this style Unisex Pull-On Short (52132)

More in this color (KAK)

Size Chart

Classroom Uniforms: Girls Average Size Range 7-16

Sizes
7
8
10
12
14
16
Height 50-52 53-54 55-56 57-58 59-60 61-63
Chest 26-27 27-28 28-29 29-30 31-32 32-33
Waist 23-23.5 23.5-24 24.5-25 25.5-26 26.5-27 27.5-28
Hip/Seat 28-29 29-30 30-31 31.5-32.5 33-34 35-36
Inseam To Floor 24.5 25 26.5 27.5 29 30.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: 52132 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: color_id szFilterVal: KAK 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] => 52132 ) [color_id] => Array ( [0] => KAK ) ) [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= 52132 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 ('52132') 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= KAK 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 ('KAK') AND req1_c.status = 0 AND p.style_id = req1_s.style_id AND req1_s.style_id IN ('52132') 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 ('KAK') AND req1_c.status = 0 AND p.style_id = req1_s.style_id AND req1_s.style_id IN ('52132') 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 ('KAK') AND req1_c.status = 0 AND p.style_id = req1_s.style_id AND req1_s.style_id IN ('52132') 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 = '52132' 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.0031449794769287 seconds Exiting Search in BaseSearch =============================================================================================== label: obj->type: classroom