select * from inventory where id_commodity_type=1042 order by inventory_productcode