fixed query for pc and tv counts