SET @query=NULL;
SET @columns=NULL;

SELECT
  GROUP_CONCAT(DISTINCT
    CONCAT( 'MAX(IF(t.name = ''', name, ''', a.data, NULL)) AS ','\'', t.name,'\'' )
  ) INTO @columns
FROM `Archive` as a
INNER JOIN type t on t.uid=a.type_uid
WHERE date_uid=2;


SET @query=CONCAT('SELECT b.name, b.regnum, ',@columns,'
FROM `Archive` a 
INNER JOIN banks b on b.uid=a.bank_uid
INNER JOIN type  t on t.uid=a.type_uid
WHERE date_uid=2 and currency_uid=1 GROUP BY bank_uid ORDER BY b.regnum');

PREPARE stmt FROM @query;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;