SELECT count(*) as total FROM tag_video AS tv, tags AS t, video AS v WHERE tv.tag_id = t.id AND t.tag = 'table' AND v.type = 'public' AND v.approve =1 AND v.active =1 AND v.VID=tv.vid group by tv.vid