{"M001":[{"ALterationListID":"3491","ID":"10215","IsDefault":"1","GroupItemID":"2","ListID":"181102","Price":"0","ItemAlteration":"HEM: OPEN","ProductID":"M001-O","CustPrice":null,"AlterationsGroup":"Inseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"0"},{"ALterationListID":"3491","ID":"10230","IsDefault":"0","GroupItemID":"2","ListID":"181081","Price":"1.5","ItemAlteration":"INSEAM HEM: 26","ProductID":"M001-26","CustPrice":null,"AlterationsGroup":"Inseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10296","IsDefault":"0","GroupItemID":"2","ListID":"181082","Price":"1.5","ItemAlteration":"INSEAM HEM: 26 1/2","ProductID":"M001-265","CustPrice":null,"AlterationsGroup":"Inseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10229","IsDefault":"0","GroupItemID":"2","ListID":"181083","Price":"1.5","ItemAlteration":"INSEAM HEM: 27","ProductID":"M001-27","CustPrice":null,"AlterationsGroup":"Inseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10297","IsDefault":"0","GroupItemID":"2","ListID":"181084","Price":"1.5","ItemAlteration":"INSEAM HEM: 27 1/2","ProductID":"M001-275","CustPrice":null,"AlterationsGroup":"Inseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10209","IsDefault":"0","GroupItemID":"2","ListID":"181085","Price":"1.5","ItemAlteration":"INSEAM HEM: 28","ProductID":"M001-28","CustPrice":null,"AlterationsGroup":"Inseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10298","IsDefault":"0","GroupItemID":"2","ListID":"181086","Price":"1.5","ItemAlteration":"INSEAM HEM: 28 1/2","ProductID":"M001-285","CustPrice":null,"AlterationsGroup":"Inseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10218","IsDefault":"0","GroupItemID":"2","ListID":"181087","Price":"1.5","ItemAlteration":"INSEAM HEM: 29","ProductID":"M001-29","CustPrice":null,"AlterationsGroup":"Inseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10299","IsDefault":"0","GroupItemID":"2","ListID":"181088","Price":"1.5","ItemAlteration":"INSEAM HEM: 29 1/2","ProductID":"M001-295","CustPrice":null,"AlterationsGroup":"Inseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10211","IsDefault":"0","GroupItemID":"2","ListID":"181089","Price":"1.5","ItemAlteration":"INSEAM HEM: 30","ProductID":"M001-30","CustPrice":null,"AlterationsGroup":"Inseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10212","IsDefault":"0","GroupItemID":"2","ListID":"181090","Price":"1.5","ItemAlteration":"INSEAM HEM: 30 1/2","ProductID":"M001-305","CustPrice":null,"AlterationsGroup":"Inseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10221","IsDefault":"0","GroupItemID":"2","ListID":"181091","Price":"1.5","ItemAlteration":"INSEAM HEM: 31","ProductID":"M001-31","CustPrice":null,"AlterationsGroup":"Inseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10217","IsDefault":"0","GroupItemID":"2","ListID":"181092","Price":"1.5","ItemAlteration":"INSEAM HEM: 31 1/2","ProductID":"M001-315","CustPrice":null,"AlterationsGroup":"Inseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10210","IsDefault":"0","GroupItemID":"2","ListID":"181093","Price":"1.5","ItemAlteration":"INSEAM HEM: 32","ProductID":"M001-32","CustPrice":null,"AlterationsGroup":"Inseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10213","IsDefault":"0","GroupItemID":"2","ListID":"181094","Price":"1.5","ItemAlteration":"INSEAM HEM: 32 1/2","ProductID":"M001-325","CustPrice":null,"AlterationsGroup":"Inseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10222","IsDefault":"0","GroupItemID":"2","ListID":"181095","Price":"1.5","ItemAlteration":"INSEAM HEM: 33","ProductID":"M001-33","CustPrice":null,"AlterationsGroup":"Inseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10223","IsDefault":"0","GroupItemID":"2","ListID":"181096","Price":"1.5","ItemAlteration":"INSEAM HEM: 33 1/2","ProductID":"M001-335","CustPrice":null,"AlterationsGroup":"Inseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10284","IsDefault":"0","GroupItemID":"2","ListID":"181097","Price":"1.5","ItemAlteration":"INSEAM HEM: 34","ProductID":"M001-34","CustPrice":null,"AlterationsGroup":"Inseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10285","IsDefault":"0","GroupItemID":"2","ListID":"181098","Price":"1.5","ItemAlteration":"INSEAM HEM: 34 1/2","ProductID":"M001-345","CustPrice":null,"AlterationsGroup":"Inseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10226","IsDefault":"0","GroupItemID":"2","ListID":"181099","Price":"1.5","ItemAlteration":"INSEAM HEM: 35","ProductID":"M001-35","CustPrice":null,"AlterationsGroup":"Inseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10225","IsDefault":"0","GroupItemID":"2","ListID":"181100","Price":"1.5","ItemAlteration":"INSEAM HEM: 35 1/2","ProductID":"M001-355","CustPrice":null,"AlterationsGroup":"Inseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10568","IsDefault":"0","GroupItemID":"2","ListID":"2040138","Price":"1.5","ItemAlteration":"INSEAM HEM: 36","ProductID":"M001-36","CustPrice":null,"AlterationsGroup":"Inseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10512","IsDefault":"0","GroupItemID":"2","ListID":"2001499","Price":"1.5","ItemAlteration":"OUTSEAM HEM: 37","ProductID":"M001OS-37","CustPrice":null,"AlterationsGroup":"Outseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10524","IsDefault":"0","GroupItemID":"2","ListID":"2023261","Price":"1.5","ItemAlteration":"OUTSEAM HEM: 37 1/2","ProductID":"M001OS-37","CustPrice":null,"AlterationsGroup":"Outseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10300","IsDefault":"0","GroupItemID":"2","ListID":"181103","Price":"1.5","ItemAlteration":"OUTSEAM HEM: 38","ProductID":"M001OS-38","CustPrice":null,"AlterationsGroup":"Outseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10301","IsDefault":"0","GroupItemID":"2","ListID":"181104","Price":"1.5","ItemAlteration":"OUTSEAM HEM: 38 1/2","ProductID":"M001OS-385","CustPrice":null,"AlterationsGroup":"Outseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10254","IsDefault":"0","GroupItemID":"2","ListID":"181105","Price":"1.5","ItemAlteration":"OUTSEAM HEM: 39","ProductID":"M001OS-39","CustPrice":null,"AlterationsGroup":"Outseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10255","IsDefault":"0","GroupItemID":"2","ListID":"181106","Price":"1.5","ItemAlteration":"OUTSEAM HEM: 39 1/2","ProductID":"M001OS-395","CustPrice":null,"AlterationsGroup":"Outseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10258","IsDefault":"0","GroupItemID":"2","ListID":"181107","Price":"1.5","ItemAlteration":"OUTSEAM HEM: 40","ProductID":"M001OS-40","CustPrice":null,"AlterationsGroup":"Outseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10259","IsDefault":"0","GroupItemID":"2","ListID":"181108","Price":"1.5","ItemAlteration":"OUTSEAM HEM: 40 1/2","ProductID":"M001OS-405","CustPrice":null,"AlterationsGroup":"Outseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10260","IsDefault":"0","GroupItemID":"2","ListID":"181109","Price":"1.5","ItemAlteration":"OUTSEAM HEM: 41","ProductID":"M001OS-41","CustPrice":null,"AlterationsGroup":"Outseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10261","IsDefault":"0","GroupItemID":"2","ListID":"181110","Price":"1.5","ItemAlteration":"OUTSEAM HEM: 41 1/2","ProductID":"M001OS-415","CustPrice":null,"AlterationsGroup":"Outseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10262","IsDefault":"0","GroupItemID":"2","ListID":"181111","Price":"1.5","ItemAlteration":"OUTSEAM HEM: 42","ProductID":"M001OS-42","CustPrice":null,"AlterationsGroup":"Outseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10263","IsDefault":"0","GroupItemID":"2","ListID":"181112","Price":"1.5","ItemAlteration":"OUTSEAM HEM: 42 1/2","ProductID":"M001OS-425","CustPrice":null,"AlterationsGroup":"Outseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10264","IsDefault":"0","GroupItemID":"2","ListID":"181113","Price":"1.5","ItemAlteration":"OUTSEAM HEM: 43","ProductID":"M001OS-43","CustPrice":null,"AlterationsGroup":"Outseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10265","IsDefault":"0","GroupItemID":"2","ListID":"181114","Price":"1.5","ItemAlteration":"OUTSEAM HEM: 43 1/2","ProductID":"M001OS-435","CustPrice":null,"AlterationsGroup":"Outseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10266","IsDefault":"0","GroupItemID":"2","ListID":"181115","Price":"1.5","ItemAlteration":"OUTSEAM HEM: 44","ProductID":"M001OS-44","CustPrice":null,"AlterationsGroup":"Outseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10267","IsDefault":"0","GroupItemID":"2","ListID":"181116","Price":"1.5","ItemAlteration":"OUTSEAM HEM: 44 1/2","ProductID":"M001OS-445","CustPrice":null,"AlterationsGroup":"Outseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10268","IsDefault":"0","GroupItemID":"2","ListID":"181117","Price":"1.5","ItemAlteration":"OUTSEAM HEM: 45","ProductID":"M001OS-45","CustPrice":null,"AlterationsGroup":"Outseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10269","IsDefault":"0","GroupItemID":"2","ListID":"181118","Price":"1.5","ItemAlteration":"OUTSEAM HEM: 45 1/2","ProductID":"M001OS-455","CustPrice":null,"AlterationsGroup":"Outseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10270","IsDefault":"0","GroupItemID":"2","ListID":"181119","Price":"1.5","ItemAlteration":"OUTSEAM HEM: 46","ProductID":"M001OS-46","CustPrice":null,"AlterationsGroup":"Outseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10271","IsDefault":"0","GroupItemID":"2","ListID":"181120","Price":"1.5","ItemAlteration":"OUTSEAM HEM: 46 1/2","ProductID":"M001OS-465","CustPrice":null,"AlterationsGroup":"Outseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10272","IsDefault":"0","GroupItemID":"2","ListID":"181121","Price":"1.5","ItemAlteration":"OUTSEAM HEM: 47","ProductID":"M001OS-47","CustPrice":null,"AlterationsGroup":"Outseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10273","IsDefault":"0","GroupItemID":"2","ListID":"181122","Price":"1.5","ItemAlteration":"OUTSEAM HEM: 47 1/2","ProductID":"M001OS-475","CustPrice":null,"AlterationsGroup":"Outseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10274","IsDefault":"0","GroupItemID":"2","ListID":"181123","Price":"1.5","ItemAlteration":"OUTSEAM HEM: 48","ProductID":"M001OS-48","CustPrice":null,"AlterationsGroup":"Outseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"},{"ALterationListID":"3491","ID":"10275","IsDefault":"0","GroupItemID":"2","ListID":"181124","Price":"1.5","ItemAlteration":"OUTSEAM HEM: 48 1/2","ProductID":"M001OS-485","CustPrice":null,"AlterationsGroup":"Outseam Hemming","GroupName":"M001","ParentID":"2","AlterPrice":"1.5"}}]}
     
 
 
 
 
 	
         
         
         
 	       	
         	
             
                 
                     
                     
                     	
                     	
                             
                                 
					 
                                 Select a color
                                 
                              
                          
                         
                       
                             
                  
                 
                     
                     
                     
                         
                             100% Woven Polyester Satin stripe Two side pockets Available in "Flat Front" Inside-waistband suspender buttons Hemmed, straight leg Sizes: 0-30 The hidden, expandable, "comfort fit" stretch waist band provides 2" of waist expandability for all day comfort. 
						This item is also available in the following brands: 
						
					 
                             Machine Washable 
                          
                      
                     
                         
 
 
 
 
     
         Order This Size: 
         0 
         2 
         4 
         6 
         8 
         10 
         12 
         14 
         16 
         18 
         20 
         22 
         24 
         26 
         28 
         30 
         Tolerance 
      
     
         + 
         - 
      
     
         If Women's Waist Measures: 
         26 1/2" 
         27 1/2" 
         28 1/2" 
         29 1/2" 
         30 1/2" 
         31 1/2" 
         33" 
         34 1/2" 
         36 1/2" 
         38 1/2" 
         40 1/2" 
         42 1/2" 
         44 1/2" 
         46 1/2" 
         48 1/2" 
         50 1/2" 
         1" 
         3/4" 
      
     
         If Women's High Seat (8" Below Bottom of Waist Band) Measures: 
         37 3/4" 
         38 3/4" 
         39 3/4" 
         40 3/4" 
         41 3/4" 
         42 3/4" 
         44 1/4" 
         45 3/4" 
         47 3/4" 
         49 3/4" 
         51 3/4" 
         53 3/4" 
         55 3/4" 
         57 3/4" 
         59 3/4" 
         61 3/4" 
         1" 
         3/4"     
      
 
  
                          
                     
                         
                     
    
                  
              
          
         
 	 
  
 
 
 
 
 
 
 	
         Please Wait... 
         verifying & adding to your items to your shopping cart... 
      
     
         
  
 
 
 	
         Please Wait... Retriving Item History... 
      
     
     
    
  
 
 
 	---------
         
Please Wait... Retriving Item/Size List... 
     
     
  
 
 
 
 
 
 
 
 SELECT `I`.`ListID`, `I`.`ProductID`, `I`.`ItemGroup`, `I`.`ItemColorID`, `I`.`ItemColor`, `I`.`ItemSizeOnly` AS `ItemSize`, `I`.`ItemLength`, `I`.`RequiredAlterationID`, `I`.`ProspectItem`,
		`I`.`SalesPrice`, `I`.`SalesPriceHS` AS `WebPrice`,  
		`I`.`AltShowListID`, `I`.`InventoryOnly`  
		 
		FROM `tbl_items` `I` 
		
		
		
		LEFT JOIN `tbl_items_comp` `T` ON (`I`.`ItemColorID` = `T`.`ItemColorID`)		
		WHERE (`I`.`ItemGroup` = 'HS3-4221') AND (`I`.`ShowOnlyLocal` = '1') AND (IsActive=1) AND (`I`.`SpecialGroupID` Is Null OR `I`.`SpecialGroupID` = '0') AND (`T`.`CompID` = '2')
		GROUP BY `I`.`ListID`
		ORDER BY `I`.`ProspectItem`, IFNULL(`I`.`ItemColor`,'ZZZZZZ'),`I`.`SizeSort`,`I`.`ItemSize`, `I`.`ItemLength`