select files.path,md5s.md5 from files,md5s 
where files.md5 in 
(
  select files.md5 from files group by files.md5 
  having count(*)>1
) 
AND
md5s.id=files.md5
order by files.md5;