Girls Stretch Pique Polo (Sizes 8-20) in BLK

Style: 58222 Color: BLK

Choose a size:

Also available in: Adult S-XXXL

Selected Color:

9.97

Please Choose A Size

Colors

About This Product

Comfy stretch pique knit girls polo has cap sleeve, 4-button narrow placket, and a longer silhouette. Colorfast 95% Cotton / 5% Spandex blend is easy care wash-and-wear. Imported. For Junior sizes S-3XL see style 58224.

Fabric: Cotton/Spandex

More like this

More in this style Girls Stretch Pique Polo (58222)

More in this color (BLK)

SetCategoryInfo in BaseModel.php Array ( ) RegisterFilter in BaseSearch.php szFilterField: style_id szFilterVal: 58222 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 1 filters In BaseSearch::GenerateQuery filters are Array ( [required] => Array ( [style_id] => Array ( [0] => 58222 ) [color_id] => Array ( [0] => BLK ) ) ) Starting RefactorRequired in QueryBuilderBase::RefactorRequired field=style_id value= 58222 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, ( 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 ('58222') AND req1_s.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, ( 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 ('58222') AND req1_s.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: | | 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, ( 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 ('58222') AND req1_s.status = 0 AND p.style_id = '58222' 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.0026729106903076 seconds Exiting Search in BaseSearch =============================================================================================== label: obj->type: classroom