Preschool Unisex LS Pique Polo in WHT

Style: 58350 Color: WHT

Choose a size:

Size Chart

Selected Color:

9.97

Please Choose A Size

Colors

About This Product

Preschool sized long sleeve unisex polo in pique knit with 2 button placket (left over right) and matching knit cuffs. Colorfast 60% cotton / 40% poly blend is easy care wash-and-wear. Imported. For Youth sizes see style 58352 and for Adult sizes see style 58354.

More like this

More in this style Preschool Unisex LS Pique Polo (58350)

More in this color (WHT)

Size Chart

Classroom Uniforms: Toddler Size Range 2T-4T

Sizes
2T
3T
4T
Height 33-35.5; 36-37.5; 38-40
Weight (lbs) 25-28 29-32 33-36
Chest 21 22 23
Waist 20 21 22
Hip/Seat 21 22 23
SetCategoryInfo in BaseModel.php Array ( [category_name] => Preschool [description] => Array ( [short] => [long] => The real world can be very messy. If you're a toddler or kindergartner it's part of the required curriculum. That is why we make our preschool sizes with the same hearty construction that the big kids get, including reinforced knees, elastic waists and the wrinkle-resistant, color-fast, stain resistant miracle of StainSmart. ) [required] => Array ( [gba] => Array ( [0] => 89 ) [gscia] => Array ( [0] => 143 ) [scia] => Array ( [0] => 1439 ) [ba] => Array ( [0] => 8908 ) ) ) 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: scia szFilterVal: 1439 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 8908 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: style_id szFilterVal: 58350 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: color_id szFilterVal: WHT szFilterType: required RegisterFilter in BaseSearch.php szFilterField: category_name szFilterVal: preschool szFilterType: required ! ignored filter category_name 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 ) [scia] => Array ( [0] => 143 ) ) [scia] => Array ( [0] => 1439 ) [ba] => Array ( [0] => 8908 ) [style_id] => Array ( [0] => 58350 ) [color_id] => Array ( [0] => WHT ) ) ) Starting RefactorRequired in QueryBuilderBase::RefactorRequired field=scia value= 1439 group=143 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 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_scia, ( 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_scia.sci_group_id = '143' AND p.style_id = req1_scia.style_id AND p.color_id = req1_scia.color_id AND p.identifier_id = req1_scia.identifier_id AND req1_scia.sci_attribute_id IN ('1439') AND req1_scia.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= 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, sci_attribute req1_scia, ( 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 req1_scia.sci_group_id = '143' AND p.style_id = req1_scia.style_id AND p.color_id = req1_scia.color_id AND p.identifier_id = req1_scia.identifier_id AND req1_scia.sci_attribute_id IN ('1439') AND req1_scia.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= 58350 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 req2_s, sci_attribute req1_ba, sci_attribute req1_scia, ( 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 = req2_s.style_id AND req2_s.style_id IN ('58350') AND req2_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 req1_scia.sci_group_id = '143' AND p.style_id = req1_scia.style_id AND p.color_id = req1_scia.color_id AND p.identifier_id = req1_scia.identifier_id AND req1_scia.sci_attribute_id IN ('1439') AND req1_scia.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= WHT 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 req2_s, sci_attribute req1_ba, sci_attribute req1_scia, ( 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 ('WHT') AND req1_c.status = 0 AND p.style_id = req2_s.style_id AND req2_s.style_id IN ('58350') AND req2_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 req1_scia.sci_group_id = '143' AND p.style_id = req1_scia.style_id AND p.color_id = req1_scia.color_id AND p.identifier_id = req1_scia.identifier_id AND req1_scia.sci_attribute_id IN ('1439') AND req1_scia.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 color req1_c, style req2_s, sci_attribute req1_ba, sci_attribute req1_scia, ( 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 ('WHT') AND req1_c.status = 0 AND p.style_id = req2_s.style_id AND req2_s.style_id IN ('58350') AND req2_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 req1_scia.sci_group_id = '143' AND p.style_id = req1_scia.style_id AND p.color_id = req1_scia.color_id AND p.identifier_id = req1_scia.identifier_id AND req1_scia.sci_attribute_id IN ('1439') AND req1_scia.status = 0 AND p.style_id = '58350' 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.0035049915313721 seconds Exiting Search in BaseSearch =============================================================================================== label: obj->type: classroom