SQL Key Value to Row

query.sql

SELECT 
l.status,
l.date_created, 
ca1.value AS Email, 
ca2.value AS Name,  
ca3.value AS Phone
FROM tablename l 
LEFT JOIN lead_data AS ca1 ON l.id = ca1.id_lead AND ca1.key='email'
LEFT JOIN lead_data AS ca2 ON l.id = ca2.id_lead AND ca2.key='name'
LEFT JOIN lead_data AS ca3 ON l.id = ca3.id_lead AND ca3.key='phone'
WHERE (l.id_campaign = '17') AND l.status = 'nova'