media: get_stats

Custom SQL query returning 1 row (hide)

SELECT
  (SELECT count(*) FROM videos)     AS videos,
  (SELECT count(*) FROM actresses)  AS actresses,
  (SELECT count(*) FROM makers)     AS makers,
  (SELECT count(*) FROM labels)     AS labels,
  (SELECT count(*) FROM directors)  AS directors,
  (SELECT count(*) FROM categories) AS categories,
  (SELECT count(*) FROM series)     AS series,
  (SELECT count(*) FROM streams)    AS streams,
  (SELECT count(DISTINCT v_uid) FROM streams) AS videosWithStreams,
  (SELECT count(*) FROM videos v
    WHERE NOT EXISTS (SELECT 1 FROM streams s WHERE s.v_uid = v.uid)
  ) AS videosWithoutStreams