RE: filters/cats results

From: Dylan Douglas <dylan_at_mediadefender.com>
Date: Tue, 10 Jul 2007 11:17:04 -0700

Updated version:
 
http://38.102.232.160/tsr_knight_bak/vit_rsp/vrts/filter_counts.php
 
-----
Dylan Douglas
MediaDefender
 

________________________________

        From: Dylan Douglas
        Sent: Monday, July 09, 2007 3:25 PM
        To: MiiVi Mailing-List (MIIVI_at_mediadefender.com)
        Subject: filters/cats results
        
        
        mysql> select name,count(*) from categorized_hashes,categories
where id = category group by category order by 2 desc;
        +------------------+----------+
        | name | count(*) |
        +------------------+----------+
        | Music | 373 |
        | Entertainment | 243 |
        | Film & Animation | 184 |
        | Sports | 60 |
        | Comedy | 54 |
        | Howto & DIY | 29 |
        | Other | 15 |
        | People & Blogs | 7 |
        | Autos & Vehicles | 5 |
        | Gadgets & Games | 4 |
        | Pets & Animals | 4 |
        | Travel & Places | 2 |
        | News & Politics | 1 |
        +------------------+----------+
        13 rows in set (0.03 sec)
         
        mysql> select level,count(*) from filtered_hashes where type =
'manual' group by level order by 2 desc;
        +------------+----------+
        | level | count(*) |
        +------------+----------+
        | ILLEGAL | 244 |
        | DRM | 216 |
        | LIVEMUSIC | 215 |
        | HARDCORE | 210 |
        | MUSICVIDEO | 172 |
        | COPYRIGHT | 154 |
        | NEWMOVIE | 146 |
        | UNFILTERED | 92 |
        | TVSHOW | 81 |
        | TVCLIP | 56 |
        | SOFTCORE | 44 |
        | DELETE | 35 |
        | OLDMOVIE | 8 |
        +------------+----------+
        13 rows in set (0.02 sec)
         
        -----
        Dylan Douglas
        MediaDefender
         
Received on Fri Sep 14 2007 - 10:55:49 BST

This archive was generated by hypermail 2.2.0 : Sun Sep 16 2007 - 22:19:45 BST