SELECT count(*) FROM parts WHERE manufacturer_id=87
SpectraWave
Showing -2799--2700 out of 44 total parts.