Girls Plus Stretch Fly Front Scooter (Half Sizes) in DNVY

Style: 55643 Color: DNVY

Choose a size:

Size Chart

Also available in: Juniors 1/2 - 21/22

Selected Color:

14.97

Please Choose A Size

Colors

About This Product

Feminine and functional girls scooter with flat back panel, fly front, center-back elastic waist, slash pockets, and belt loops. Stretch fabric of cotton/poly/spandex blend has supple fit and feel with wash-and-wear ease. Imported. For sizes 4-6X see style 55641, for sizes 7-16 see style 55462 and for Juniors sizes 1/2-21/22 see style 55644.

More like this

More in this style Girls Plus Stretch Fly Front Scooter (55643)

More in this color (DNVY)

Size Chart

Classroom Uniforms: Girls Plus Size Range 8h-18h

Sizes
8h
10h
12h
14h
16h
18h
20h
Height 53-54 55-56 57-58 59-60 61-63 64-66 67-70
Chest 29-30 31-32 33-34 35-36 37-38 39-40 41-42
Waist 26-26.5 27-27.5 28-28.5 29-29.5 30-30.5 31-31.5 33-33.5
Hip/Seat 31-32 33-34 35-36 37-38 39-40 41-42 43-44
Inseam 24.5 25 26.5 27.5 29 30.5 31
SetCategoryInfo in BaseModel.php Array ( [category_name] => Girls [description] => Array ( [short] => [long] => Classroom has taken every measure to create a line of fashionable, durable school uniforms tested in real-world situations with real kids. The result is a line of easy-care uniforms that look as crisp and bright as the first day of school all year long. Select our Girls’ Stretch Twill from the fabric dropdown above to see our line of comfortable yet beautifully fitting uniforms. These styles are trim, flattering and fashionable. The cotton/poly/spandex blend allows children to be as free as, well, children! ) [required] => Array ( [gba] => Array ( [0] => 89 ) [gscia] => Array ( [0] => 143 ) [ba] => Array ( [0] => 8908 ) ) [optional] => Array ( [scia] => Array ( [0] => 1433 [1] => 1437 [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: 1437 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: scia szFilterVal: 1440 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: style_id szFilterVal: 55643 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: color_id szFilterVal: DNVY 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 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] => 55643 ) [color_id] => Array ( [0] => DNVY ) ) [optional] => Array ( [scia] => Array ( [0] => 1433 [1] => 1437 [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= 55643 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 ('55643') 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= DNVY 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 ('DNVY') AND req1_c.status = 0 AND p.style_id = req1_s.style_id AND req1_s.style_id IN ('55643') 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','1437','1440') AND opt1_scia.status = 0 AND p.color_id = req1_c.color_id AND req1_c.color_id IN ('DNVY') AND req1_c.status = 0 AND p.style_id = req1_s.style_id AND req1_s.style_id IN ('55643') 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','1437','1440') AND opt1_scia.status = 0 AND p.color_id = req1_c.color_id AND req1_c.color_id IN ('DNVY') AND req1_c.status = 0 AND p.style_id = req1_s.style_id AND req1_s.style_id IN ('55643') 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 = '55643' 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.072758913040161 seconds Exiting Search in BaseSearch =============================================================================================== label: obj->type: classroom