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!=b.page_id AND ((a.phash=b.phash AND BIT_COUNT(a.dhash ^ b.dhash)) 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...
