Pivot table query using mysql function GROUP_CONCAT

eav-query.sql

SELECT  
  t.email,  
  GROUP_CONCAT(if(a.attr = 'title', value, NULL)) AS 'Title',
  GROUP_CONCAT(if(a.attr = 'forename', value, NULL)) AS 'First Name', 
  GROUP_CONCAT(if(a.attr = 'surname', value, NULL)) AS 'Last Name'
FROM targets t
JOIN attr_value_pairs a
ON t.attr_value_id = a.id
GROUP BY t.email;