Untitled query #85383

SQL

SELECT 
	DISTINCT CAST(v1.page_id AS CHAR CHARACTER SET utf8) AS `v0`, 
    CAST(v1.page_id_out AS CHAR CHARACTER SET utf8) AS `v1`
FROM (
  SELECT 
  	a.page_id, 
  	b.page_id as page_id_out 
  FROM 
  	s55462__imagehashpublic_p.imagehash as a, 
  	s55462__imagehashpublic_p.imagehash as b 
  WHERE 
    a.page_id=56690328
  	AND a.page_id!=b.page_id 
  AND (
    (a.phash=b.phash AND BIT_COUNT(a.dhash ^ b.dhash)<3) 
    OR 
    (a.dhash=b.dhash)
  )
) v1
WHERE (v1.page_id IS NOT NULL AND CONCAT('https://commons.wikimedia.org/entity/M',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(CAST(v1.page_id AS CHAR CHARACTER SET utf8), '%', '%25'), ' ', '%20'), '!', '%21'), '"', '%22'), '#', '%23'), '$', '%24'), '&', '%26'), '''', '%27'), '(', '%28'), ')', '%29'), '*', '%2A'), '+', '%2B'), ',', '%2C'), '/', '%2F'), ':', '%3A'), ';', '%3B'), '<', '%3C'), '=', '%3D'), '>', '%3E'), '?', '%3F'), '@', '%40'), '[', '%5B'), '\\', '%5C'), ']', '%5D'), '^', '%5E'), '`', '%60'), '{', '%7B'), '|', '%7C'), '}', '%7D')) = 'https://commons.wikimedia.org/entity/M56690328' AND v1.page_id_out IS NOT NULL)
SQL

Checking query status...
