{"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 `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-9221') 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`