Spalten als Variablen verwenden

[Freezer]

Hiho,

Erstmal mein Query:

SELECT  
       request5_2_1.id,  
       COUNT(task5_2_1.id) AS tasks,  
       SUM(task5_2_1.state='Waiting') AS waiting,  
       SUM(task5_2_1.state='Ready') AS ready,  
       SUM(task5_2_1.state='Busy') AS busy,  
       SUM(task5_2_1.state='Aborted') AS aborted,  
       SUM(task5_2_1.state='Failed') AS failed,  
       SUM(task5_2_1.state='Finished') AS finished,  
       CASE  
            WHEN failed>0 THEN 'Failed'  
            WHEN  
                 finished>0  
                 AND (ready=0 || ready IS NULL)  
                 AND (busy=0 || busy IS NULL)  
                 AND (aborted=0 || aborted IS NULL)  
                 AND (waiting=0 || waiting IS NULL)  
                 THEN 'Finished'  
            WHEN  
                 waiting>0  
                 OR ready>0  
                 OR busy>0  
                 OR aborted>0  
                 THEN 'Busy'  
            ELSE 'Ready'  
       END AS state  
FROM request5_2_1  
       LEFT JOIN task5_2_1 ON task5_2_1.requestId = request5_2_1.id  
WHERE request5_2_1.id IN (356, 357, 358, 359, 360, 361)  
GROUP BY request5_2_1.id;  

Mein Problem ist, dass ich gerne die Werte aus den Spalten waiting, ready etc. als Variablen brauchen kann, wie ich das hier gemacht habe. Was muss ich ändern damit mein code funktioniert?

danke für eure Antworten

Gruss Freezer