← Back to main page
blog-acoustic-fingerprinting
ARCHIVED - acoustic fingerprinting television shows with python
git clone https://git.vogt.world/blog-acoustic-fingerprinting.git
alt url: https://github.com/vogtb/blog-acoustic-fingerprinting
Log | Files | README.md
← All files
name: src/sql/duplicate_hashes.sql
-rw-r--r--
146
 
1-- Duplicate hashes, should be pretty low.
2SELECT hash, COUNT(DISTINCT episode) AS e FROM fingerprints
3GROUP BY hash HAVING e > 1 ORDER BY e DESC;