SELECT count(*) FROM parts WHERE manufacturer_id=88
Hitachi
Showing -7899--7800 out of 6 total parts.