SET @sql = NULL;

SELECT

 GROUP_CONCAT(DISTINCT

 CONCAT(

 'MAX(IF(pa.produk = ''',

 rating.produk,

 ''', pa.nilai, NULL)) AS `',

 products.`id`,'`'

 )

 ) INTO @sql

FROM rating

LEFT JOIN products ON products.id = rating.produk

;



SET @sql = CONCAT('SELECT p.id

 , p.first_name

 , p.last_name, ', @sql, ' 

 FROM clients p

 LEFT JOIN rating AS pa 

 ON p.id = pa.client

 GROUP BY p.id');



PREPARE stmt FROM @sql;

EXECUTE stmt;

DEALLOCATE PREPARE stmt;