Skip to content

Instantly share code, notes, and snippets.

/gist:5530187

Created May 7, 2013 04:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anonymous/5530187 to your computer and use it in GitHub Desktop.
Save anonymous/5530187 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
select count(*) from (
select f.id, d1.name as dir, n1.name as name, c.sha1, size from
(select sha1 from collision group by sha1 having count(*)>1) msha
join collision c on c.sha1 = msha.sha1
join file f on f.id=c.id
join NameList n1 on n1.id=f.name
join directory d1 on d1.id=f.dir
) z
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment