select * from inventory where id_commodity_type=1071 order by inventory_productcode