Untitled query #84936

SQL

select 
   CONCAT('https://commons.wikimedia.org/entity/M', i1.page_id) as image1, 
   CONCAT('https://commons.wikimedia.org/entity/M', i2.page_id) as image2,
   CONCAT('phash:', i1.phash) as phash_str,
   CONCAT('dhash:', i1.dhash) as dhash_str
from 
   imagehash as i1, 
   imagehash as i2 
where 
   i1.page_id!=i2.page_id 
   AND
   (
      (i1.phash=i2.phash AND BIT_COUNT(i1.dhash ^ i2.dhash) < 2 AND i1.phash NOT IN (0, 9223372036854775808))
      OR 
      (i1.dhash=i2.dhash AND BIT_COUNT(i1.phash ^ i2.phash) < 2 AND i1.dhash NOT IN (0, 9223372036854775808))
   )
limit 10
SQL

Checking query status...
