1: $xport="SELECT COUNT(spalte1) AS x, spalte2 FROM tabelle WHERE spalte3 > 0 ";
2: $progress="SELECT COUNT(spalte1) AS y, spalte2 FROM tabelle WHERE spalte3 > 0 AND spalte4 > 0 ";
3: $clean=SELECT COUNT(spalte1) AS z, spalte2 FROM tabelle WHERE spalte3 = 0 AND spalte4 = 0";

SELECT bestellschein, produkttyp, 
SUM(IF(status>0,1,0)) AS fertig,
SUM(CASE WHEN masterstatus=0 THEN (IF(status=0,1,0)) ELSE 0 END) AS keinMaster,
SUM(CASE WHEN masterstatus=0 THEN (IF(status>0,1,0)) ELSE 0 END) AS verarbeitung,
COUNT(id) AS Total
FROM tabelle
WHERE kunde=koenig
GROUP BY bestellschein, produkttyp;