SELECT ( SELECT COUNT( releasenfoID ) AS cnt from releases where consoleinfoID IS NULL and categoryID BETWEEN 1000 AND 1999 ) AS console, \
( SELECT COUNT( releasenfoID ) AS cnt from releases where imdbID IS NULL and categoryID BETWEEN 2000 AND 2999 ) AS movies, \
( SELECT COUNT( releasenfoID ) AS cnt from releases where musicinfoID IS NULL and categoryID BETWEEN 3000 AND 3999 ) AS audio, \
( SELECT COUNT( releasenfoID ) AS cnt from releases r left join category c on c.ID = r.categoryID where (categoryID BETWEEN 4000 AND 4999 and ((r.passwordstatus between -6 and -1) or (r.haspreview = -1 and c.disablepreview = 0)))) AS pc, \
( SELECT COUNT( releasenfoID ) AS cnt from releases where rageID = -1 and categoryID BETWEEN 5000 AND 5999 ) AS tv, \
( SELECT COUNT( releasenfoID ) AS cnt from releases where bookinfoID IS NULL and categoryID = 7020 ) AS book, \
( SELECT COUNT( releasenfoID ) AS cnt from releases r left join category c on c.ID = r.categoryID where (r.passwordstatus between -6 and -1) or (r.haspreview = -1 and c.disablepreview = 0)) AS work, \
( SELECT COUNT( releasenfoID ) AS cnt FROM releases r WHERE r.releasenfoID = 0) AS nforemains, \
( SELECT count( releasenfoID ) AS cnt FROM releases WHERE releasenfoID not in (0, -1)) AS nfo, \
( SELECT table_rows AS cnt FROM information_schema.TABLES where table_name = 'parts' AND ENGINE = 'InnoDB') AS parts, \
( SELECT concat(round((data_length+index_length)/(1024*1024*1024),2),'GB') AS cnt FROM information_schema.tables where table_name = 'parts' AND ENGINE = 'InnoDB') AS partsize;