NO/EN Translation Pairs

Custom SQL query returning 92 rows (hide)

SELECT
  pt.no_product_id,
  '{"href": "/images/' || pt.no_product_id || '.jpg", "img_src": "/images/' || pt.no_product_id || '.jpg"}' as no_image,
  pn.name as norwegian_name,
  GROUP_CONCAT(DISTINCT pvn.price) as no_prices,
  CASE WHEN bn.instock = 1 THEN 'In Stock' WHEN bn.instock = 0 THEN 'Out' ELSE '?' END as no_stock,
  pt.en_product_id,
  '{"href": "/images/' || pt.en_product_id || '.jpg", "img_src": "/images/' || pt.en_product_id || '.jpg"}' as en_image,
  pe.name as english_name,
  GROUP_CONCAT(DISTINCT pve.price) as en_prices,
  CASE WHEN be.instock = 1 THEN 'In Stock' WHEN be.instock = 0 THEN 'Out' ELSE '?' END as en_stock,
  CASE WHEN GROUP_CONCAT(DISTINCT pvn.price) != GROUP_CONCAT(DISTINCT pve.price)
       THEN 'DIFFERENT' ELSE 'same' END as price_match,
  CASE WHEN bn.instock != be.instock THEN 'MISMATCH' ELSE 'same' END as stock_match,
  CASE WHEN pin.md5_hash = pie.md5_hash THEN 'same'
       WHEN pin.md5_hash IS NULL OR pie.md5_hash IS NULL THEN '?'
       ELSE 'DIFFERENT' END as image_match,
  pt.verified
FROM product_translations pt
JOIN products pn ON pt.no_product_id = pn.id
JOIN products pe ON pt.en_product_id = pe.id
LEFT JOIN product_variants pvn ON pn.id = pvn.product_id
LEFT JOIN product_variants pve ON pe.id = pve.product_id
LEFT JOIN product_backend_data bn ON pn.id = bn.product_id
LEFT JOIN product_backend_data be ON pe.id = be.product_id
LEFT JOIN product_images pin ON pn.id = pin.product_id
LEFT JOIN product_images pie ON pe.id = pie.product_id
GROUP BY pt.no_product_id, pt.en_product_id
ORDER BY pn.name

Edit SQL