From e275749f97e7fef77a4e2f452a9abffde39025f0 Mon Sep 17 00:00:00 2001
From: Helmut Grohne <helmut@subdivi.de>
Date: Wed, 6 Mar 2013 15:36:49 +0100
Subject: README: added interesting query

---
 README | 2 ++
 1 file changed, 2 insertions(+)

diff --git a/README b/README
index c185a51..db2ea3c 100644
--- a/README
+++ b/README
@@ -31,3 +31,5 @@ SQL database by hand. Example queries:
     SELECT a.package, a.filename, b.package, b.filename, a.size FROM content AS a JOIN content AS b ON a.hash = b.hash WHERE (a.package != b.package OR a.filename != b.filename) ORDER BY a.size DESC LIMIT 100;
 
     SELECT hash, sum(size)-min(size), count(*), count(distinct package) FROM content GROUP BY hash ORDER BY sum(size)-min(size) DESC LIMIT 100;
+
+    SELECT package, filename, size FROM content WHERE function = "image_sha512" AND filename NOT LIKE "%.png";
-- 
cgit v1.2.3