what type of transmission does 5 speed manual use?
(AND automotive.transmission_type (JOIN automotive.transmission_type.transmissions m.02k_mmq))