what type of transmission does c4 use?
(AND automotive.transmission_type (JOIN automotive.transmission_type.transmissions m.07t0tc))