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