Potential Pairs - Same Image

Custom SQL query (hide)

SELECT
  p1.id as no_id,
  '{"href": "/images/' || p1.id || '.jpg", "img_src": "/images/' || p1.id || '.jpg"}' as no_image,
  p1.name as no_name,
  p2.id as en_id,
  '{"href": "/images/' || p2.id || '.jpg", "img_src": "/images/' || p2.id || '.jpg"}' as en_image,
  p2.name as en_name,
  'python cli.py add-pair ' || p1.id || ' ' || p2.id as command
FROM products p1
JOIN product_images pi1 ON p1.id = pi1.product_id
JOIN product_images pi2 ON pi1.md5_hash = pi2.md5_hash AND pi1.product_id != pi2.product_id
JOIN products p2 ON p2.id = pi2.product_id
LEFT JOIN product_translations pt1 ON p1.id = pt1.no_product_id OR p1.id = pt1.en_product_id
LEFT JOIN product_translations pt2 ON p2.id = pt2.no_product_id OR p2.id = pt2.en_product_id
WHERE pt1.no_product_id IS NULL
  AND pt2.no_product_id IS NULL
  AND p1.id < p2.id
  AND ((p1.language = 'no' AND p2.language = 'en') OR (p1.language IS NULL OR p2.language IS NULL))
  AND pi1.md5_hash != 'ecd12966ed20c8ca8afd0c2bd48cd769'
ORDER BY p1.name

Edit SQL