$query=("SELECT sifra, ((SELECT SUM(timestamp) FROM names WHERE reason='2' AND sifra='$id' GROUP BY (sifra)) - (SELECT SUM(timestamp) FROM names WHERE reason='1' AND sifra='$id' GROUP BY (sifra))) AS redni,((SELECT SUM(timestamp) FROM names WHERE reason='4' AND sifra='$id' GROUP BY (sifra)) - (SELECT SUM(timestamp) FROM names WHERE reason='3' AND sifra='$id' GROUP BY (sifra))) AS malica,((SELECT SUM(timestamp) FROM names WHERE reason='6' AND sifra='$id' GROUP BY (sifra)) - (SELECT SUM(timestamp) FROM names WHERE reason='5' AND sifra='$id' GROUP BY (sifra))) AS sluzbeni,((SELECT SUM(timestamp) FROM names WHERE reason='8' AND sifra='$id' GROUP BY (sifra)) - (SELECT SUM(timestamp) FROM names WHERE reason='7' AND sifra='$id' GROUP BY (sifra))) AS zasebni,(((SELECT SUM(timestamp) FROM names WHERE reason='2' AND sifra='$id' GROUP BY (sifra)) - (SELECT SUM(timestamp) FROM names WHERE reason='1' AND sifra='$id' GROUP BY (sifra)))-((SELECT SUM(timestamp) FROM names WHERE reason='4' AND sifra='$id' GROUP BY (sifra)) - (SELECT SUM(timestamp) FROM names WHERE reason='3' AND sifra='$id' GROUP BY (sifra)))) as Redni_brez_malice,(((SELECT SUM(timestamp) FROM names WHERE reason='2' AND sifra='$id' GROUP BY (sifra)) - (SELECT SUM(timestamp) FROM names WHERE reason='1' AND sifra='$id' GROUP BY (sifra)))- ((SELECT SUM(timestamp) FROM names WHERE reason='8' AND sifra='$id' GROUP BY (sifra)) - (SELECT SUM(timestamp) FROM names WHERE reason='7' AND sifra='$id' GROUP BY (sifra)))) as Redni_brez_Zasebni,(((SELECT SUM(timestamp) FROM names WHERE reason='2' AND sifra='$id' GROUP BY (sifra)) - (SELECT SUM(timestamp) FROM names WHERE reason='1' AND sifra='$id' GROUP BY (sifra)))-((SELECT SUM(timestamp) FROM names WHERE reason='4' AND sifra='$id' GROUP BY (sifra)) - (SELECT SUM(timestamp) FROM names WHERE reason='3' AND sifra='$id' GROUP BY (sifra)))-((SELECT SUM(timestamp) FROM names WHERE reason='8' AND sifra='$id' GROUP BY (sifra)) - (SELECT SUM(timestamp) FROM names WHERE reason='7' AND sifra='$id' GROUP BY (sifra)))) as Redni_brez_malice_brez_zasebni FROM names WHERE sifra='$id' GROUP BY (sifra)") ;/*Redni_brez_malice_brez_zasebni otherwise this query works, but I do not get this claculated and I have no idea why, so maybe you will see it, coz I dont, there is no error, it just doesnt return the resoult*/