Error! - browse2test -- SELECT carmakes.name, kn_parts.model FROM carmakes LEFT JOIN kn_parts on kn_parts.modelID = '19' WHERE ID = 'INTERNATIONAL' ORDER BY name