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