user: ### NOW ANSWER:
Question: During which years was the Model 318td (diesel) with the Engine code of M47D20 manufactured?
Columns: ['Model', 'Years', 'Engine code', 'Power', 'Torque']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['316ti', '2001–2004', 'N42B18 / N46B18', 'kW (PS; hp) @ 5500', 'N·m (lb·ft) @ 3750']
SQL:

assistant: SELECT "Years" FROM "Table" WHERE "Engine code" = 'M47D20' AND "Model" = '318td (diesel)';