select Z_durch_soll, Z_id, Z_status, Z_durch_ist, (((Z_durch_soll+0.25)-Z_durch_ist) / 2) AS Z_durch_delta, Z_durch_soll+0.25 AS Z_durch_korr
from Zylinder
where (Z_A_nr is NULL
AND Z_umfang = '900' AND Z_blaenge = '2340' AND Z_durch_soll ='286.45'
AND Z_status = 'zcu'
AND (((Z_durch_soll+0.25)-Z_durch_ist) / 2) >= 0.085
AND (((Z_durch_soll+0.25)-Z_durch_ist) / 2) >  0.12)
UNION
select Z_durch_soll, Z_id, Z_status, Z_durch_ist, (((Z_durch_soll+0.2)-Z_durch_ist) / 2) AS Z_durch_delta, Z_durch_soll+0.2 AS Z_durch_korr
from Zylinder
where (Z_A_nr is NULL
AND Z_umfang = '900' AND Z_blaenge = '2340' AND Z_durch_soll ='286.40'
AND Z_status = 'zcu'
AND (((Z_durch_soll+0.25)-Z_durch_ist) / 2) >= 0.085
AND (((Z_durch_soll+0.25)-Z_durch_ist) / 2) >  0.12)
UNION
select Z_durch_soll, Z_id, Z_status, Z_durch_ist, (((Z_durch_soll+0.2)-Z_durch_ist) / 2) AS Z_durch_delta, Z_durch_soll+0.2 AS Z_durch_korr
from Zylinder
where (Z_A_nr is NULL
AND Z_umfang = '900' AND Z_blaenge = '2340' AND Z_durch_soll ='286.35'
AND Z_status = 'zcu'
AND (((Z_durch_soll+0.25)-Z_durch_ist) / 2) >= 0.085
AND (((Z_durch_soll+0.25)-Z_durch_ist) / 2) >  0.12)
UNION
select Z_durch_soll, Z_id, Z_status, Z_durch_ist, (((Z_durch_soll+0.2)-Z_durch_ist) / 2) AS Z_durch_delta, Z_durch_soll+0.2 AS Z_durch_korr
from Zylinder
where (Z_A_nr is NULL
AND Z_umfang = '900' AND Z_blaenge = '2340' AND Z_durch_soll ='286.30'
AND Z_status = 'zcu'
AND (((Z_durch_soll+0.25)-Z_durch_ist) / 2) >= 0.085
AND (((Z_durch_soll+0.25)-Z_durch_ist) / 2) >  0.12)
UNION
select Z_durch_soll, Z_id, Z_status, Z_durch_ist, (((Z_durch_soll+0.2)-Z_durch_ist) / 2) AS Z_durch_delta, Z_durch_soll+0.2 AS Z_durch_korr
from Zylinder
where (Z_A_nr is NULL
AND Z_umfang = '900' AND Z_blaenge = '2340' AND Z_durch_soll ='286.20'
AND Z_status = 'zcu'
AND (((Z_durch_soll+0.25)-Z_durch_ist) / 2) >= 0.085
AND (((Z_durch_soll+0.25)-Z_durch_ist) / 2) >  0.12)
UNION
select Z_durch_soll, Z_id, Z_status, Z_durch_ist, (((Z_durch_soll+0.2)-Z_durch_ist) / 2) AS Z_durch_delta, Z_durch_soll+0.2 AS Z_durch_korr
from Zylinder
where (Z_A_nr is NULL
AND Z_umfang = '900' AND Z_blaenge = '2340' AND Z_durch_soll ='286.15'
AND Z_status = 'zcu'
AND (((Z_durch_soll+0.25)-Z_durch_ist) / 2) >= 0.085
AND (((Z_durch_soll+0.25)-Z_durch_ist) / 2) >  0.12)
UNION
select Z_durch_soll, Z_id, Z_status, Z_durch_ist, (((Z_durch_soll+0.2)-Z_durch_ist) / 2) AS Z_durch_delta, Z_durch_soll+0.2 AS Z_durch_korr
from Zylinder
where (Z_A_nr is NULL
AND Z_umfang = '900' AND Z_blaenge = '2340' AND Z_durch_soll ='286.1'
AND Z_status = 'zcu'
AND (((Z_durch_soll+0.25)-Z_durch_ist) / 2) >= 0.085
AND (((Z_durch_soll+0.25)-Z_durch_ist) / 2) >  0.12)
UNION
select Z_durch_soll, Z_id, Z_status, Z_durch_ist, (((Z_durch_soll+0.2)-Z_durch_ist) / 2) AS Z_durch_delta, Z_durch_soll+0.2 AS Z_durch_korr
from Zylinder
where (Z_A_nr is NULL
AND Z_umfang = '900' AND Z_blaenge = '2340' AND Z_durch_soll ='286.05'
AND Z_status = 'zcu'
AND (((Z_durch_soll+0.25)-Z_durch_ist) / 2) >= 0.085
AND (((Z_durch_soll+0.25)-Z_durch_ist) / 2) >  0.12)
order by Z_durch_soll DESC, Z_durch_delta ASC