SELECT 
 
(select SUM(audio.count) from audio) +
(select SUM(video.count) from video) +
(select SUM(software.count) from software) +
(select SUM(linux.count) from count) +
(select SUM(foto.count) FROM foto) 

;