Unisex Drawstring Cargo Pant (Short) in AZLW

Style: 4100S Color: AZLW

Choose a size:

Size Chart

Also available in: Tall, Regular

Selected Color:

See Cart For Price

Please Choose A Size

Colors

Dark Khaki

About This Product

A casual Unisex pant features a natural rise and an adjustable webbed drawstring at the waist, one back pocket, and a cargo pocket with an inside cell phone pocket. Inseam 28.5".

Fabric: 65 Poly/35 Cotton Poplin w/ Soil Release

More like this

More in this style Unisex Drawstring Cargo Pant (4100S)

More in this color (AZLW)

Size Chart

Workwear: Men / Unisex

Sizes
XXS
XS
S
M
L
XL
2XL
3XL
4XL
5XL
Chest 29-31 32-34 35-37 38-40 42-44 46-48 50-52 54-56 58-60 62-64
Waist 21-23 24-26 27-29 30-32 34-36 38-40 42-44 46-48 50-52 54-56
Hip 29-31 32-34 35-37 38-40 42-44 46-48 50-52 54-60 58-60 62-64

Regular inseams: 31-32"
Short inseams: 29-30"
Tall inseams: 34-35"
Ultra Tall unhemmed inseams: 36"

SetCategoryInfo in BaseModel.php Array ( [category_name] => Pants [description] => Array ( [short] => [long] => ) [required] => Array ( [gba] => Array ( [0] => 89 ) [sa] => Array ( [0] => 4010 ) ) [optional] => Array ( [ba] => Array ( [0] => 8900 [1] => 8901 [2] => 8902 [3] => 89103 ) ) ) RegisterFilter in BaseSearch.php szFilterField: gba szFilterVal: 89 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: sa szFilterVal: 4010 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 8900 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 8901 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 8902 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 89103 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: style_id szFilterVal: 4100S szFilterType: required RegisterFilter in BaseSearch.php szFilterField: color_id szFilterVal: AZLW 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 ) ) [sa] => Array ( [0] => 4010 ) [style_id] => Array ( [0] => 4100S ) [color_id] => Array ( [0] => AZLW ) ) [optional] => Array ( [ba] => Array ( [0] => 8900 [1] => 8901 [2] => 8902 [3] => 89103 ) ) ) Starting RefactorRequired in QueryBuilderBase::RefactorRequired field=sa value= 4010 group= base:=style_attribute # join: p.style_id = #.style_id AND #.style_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 style_attribute req1_sa, ( 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_sa.style_id AND req1_sa.style_attribute_id IN ('4010') AND req1_sa.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= 4100S 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, style_attribute req1_sa, ( 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 ('4100S') AND req2_s.status = 0 AND p.style_id = req1_sa.style_id AND req1_sa.style_attribute_id IN ('4010') AND req1_sa.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= AZLW 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, style_attribute req1_sa, ( 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 ('AZLW') AND req1_c.status = 0 AND p.style_id = req2_s.style_id AND req2_s.style_id IN ('4100S') AND req2_s.status = 0 AND p.style_id = req1_sa.style_id AND req1_sa.style_attribute_id IN ('4010') AND req1_sa.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=ba 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_group_id='89' 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_ba, color req1_c, style req2_s, style_attribute req1_sa, ( 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_ba.style_id AND p.color_id = opt1_ba.color_id AND p.identifier_id = opt1_ba.identifier_id AND opt1_ba.sci_group_id='89' AND opt1_ba.sci_attribute_id IN ('8900','8901','8902','89103') AND opt1_ba.status = 0 AND p.color_id = req1_c.color_id AND req1_c.color_id IN ('AZLW') AND req1_c.status = 0 AND p.style_id = req2_s.style_id AND req2_s.style_id IN ('4100S') AND req2_s.status = 0 AND p.style_id = req1_sa.style_id AND req1_sa.style_attribute_id IN ('4010') AND req1_sa.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: 8900 | | 1; Refactored to: 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_ba, color req1_c, style req2_s, style_attribute req1_sa, ( 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_ba.style_id AND p.color_id = opt1_ba.color_id AND p.identifier_id = opt1_ba.identifier_id AND opt1_ba.sci_group_id='89' AND opt1_ba.sci_attribute_id IN ('8900','8901','8902','89103') AND opt1_ba.status = 0 AND p.color_id = req1_c.color_id AND req1_c.color_id IN ('AZLW') AND req1_c.status = 0 AND p.style_id = req2_s.style_id AND req2_s.style_id IN ('4100S') AND req2_s.status = 0 AND p.style_id = req1_sa.style_id AND req1_sa.style_attribute_id IN ('4010') AND req1_sa.status = 0 AND p.style_id = '4100S' 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 =============================================================================================== 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_ba, color req1_c, style req2_s, style_attribute req1_sa, ( 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_ba.style_id AND p.color_id = opt1_ba.color_id AND p.identifier_id = opt1_ba.identifier_id AND opt1_ba.sci_group_id='89' AND opt1_ba.sci_attribute_id IN ('8900','8901','8902','89103') AND opt1_ba.status = 0 AND p.color_id = req1_c.color_id AND req1_c.color_id IN ('AZLW') AND req1_c.status = 0 AND p.style_id = req2_s.style_id AND req2_s.style_id IN ('4100S') AND req2_s.status = 0 AND p.style_id = req1_sa.style_id AND req1_sa.style_attribute_id IN ('4010') AND req1_sa.status = 0 AND p.style_id = '4100S' 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.0063941478729248 seconds Exiting Search in BaseSearch =============================================================================================== label: obj->type: apparel