SELECT CONCAT(flow_statistik.user_id, "-",  flow_user.name),
SUM(IF(flow_karton_artikel.zustand = 'A', 1, 0)) as A,
SUM(IF(flow_karton_artikel.zustand = 'B', 1, 0)) as B,
SUM(IF(flow_karton_artikel.zustand = 'C', 1, 0)) as C,
SUM(IF(flow_karton_artikel.zustand = 'S', 1, 0)) as S,
SUM(IF(flow_karton_artikel.zustand = 'R', 1, 0)) as R,
COUNT(flow_karton_artikel.id) as Gesamt,
COUNT(DISTINCT flow_karton_artikel.id) as GesamtDeFake
FROM  flow_statistik
LEFT JOIN flow_karton_artikel ON flow_karton_artikel.id = flow_statistik.karton_artikel_id
LEFT JOIN flow_user ON flow_user.id = flow_statistik.user_id
WHERE flow_statistik.timestamp > UNIX_TIMESTAMP('2015-04-01 00:00:00') AND flow_statistik.timestamp < UNIX_TIMESTAMP('2015-05-01 00:00:00')
GROUP BY CONCAT(flow_statistik.user_id, "-",  flow_user.name)
WITH ROLLUP