filters/cats results

From: Dylan Douglas <dylan_at_mediadefender.com>
Date: Mon, 9 Jul 2007 15:24:49 -0700

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