Jr. Fit Mid-Rise Drawstring Pant in CRBZ

Style: 851206 Color: CRBZ

Choose a size:

  • XS
  • S
  • M
  • L
  • XL
  • 2XL

Size Chart

12.97

Please Choose A Size

About This Product

A Junior fit, mid-rise, flare leg pant has an adjustable drawstring, two front pockets, one back pocket and side vents. Inseam: 30 1/2".

Fabric: 65 Poly/35 Cotton Poplin

More like this

More in this style Jr. Fit Mid-Rise Drawstring Pant (851206)

More in this color (CRBZ)

Size Chart

Classic Missy Fit

Sizes
XXS
XS
S
M
L
XL
2XL
3XL
4XL
5XL
Size Comparison 0-1 2-4 6-8 10-12 14-16 18-20 22-24 26-28 30-32 34-36
Chest/Bust 31-32 33-34 35-36 37-39 40-43 44-47 48-51 52-55 56-59 60-63
Waist 23-24 25-26 27-28 29-31 32-35 36-39 40-43 44-47 48-51 52-55
Hip 34-35 36-37 37-38 39-41 42-45 46-49 50-53 54-57 60-62 64-67

Inseams: Regular 30.5", Petite 28", Tall 33.5"

SetCategoryInfo in BaseModel.php Array ( ) RegisterFilter in BaseSearch.php szFilterField: style_id szFilterVal: 851206 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: color_id szFilterVal: CRBZ 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] => 851206 ) [color_id] => Array ( [0] => CRBZ ) ) ) Starting RefactorRequired in QueryBuilderBase::RefactorRequired field=style_id value= 851206 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 ('851206') 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= CRBZ 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 ('CRBZ') AND req1_c.status = 0 AND p.style_id = req1_s.style_id AND req1_s.style_id IN ('851206') 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 ('CRBZ') AND req1_c.status = 0 AND p.style_id = req1_s.style_id AND req1_s.style_id IN ('851206') AND req1_s.status = 0 AND p.style_id = '851206' 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.0039570331573486 seconds Exiting Search in BaseSearch =============================================================================================== label: obj->type: apparel