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