Potential Pairs - Same Prices, No Pair

Custom SQL query returning 129 rows (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,
  pv1.price,
  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_variants pv1 ON p1.id = pv1.product_id
JOIN product_variants pv2 ON pv1.price = pv2.price AND pv1.product_id != pv2.product_id
JOIN products p2 ON p2.id = pv2.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
LEFT JOIN product_images pi1 ON p1.id = pi1.product_id
LEFT JOIN product_images pi2 ON p2.id = pi2.product_id
WHERE pt1.no_product_id IS NULL
  AND pt2.no_product_id IS NULL
  AND p1.language = 'no' AND p2.language = 'en'
  AND p1.id < p2.id
  AND (pi1.md5_hash IS NULL OR pi1.md5_hash != 'ecd12966ed20c8ca8afd0c2bd48cd769')
  AND (pi2.md5_hash IS NULL OR pi2.md5_hash != 'ecd12966ed20c8ca8afd0c2bd48cd769')
GROUP BY p1.id, p2.id
ORDER BY p1.name

Edit SQL