SELECT count(*) AS total FROM video WHERE type='public' AND active=1 AND approve=1