NO/EN Pairs with Language Conflicts

Custom SQL query returning 8 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 no_name,
  pn.language as no_detected_lang,
  CASE WHEN pn.language = 'en' THEN 'WRONG - English!'
       WHEN pn.language IS NULL THEN 'Unknown'
       ELSE 'OK' END as no_lang_status,
  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 en_name,
  pe.language as en_detected_lang,
  CASE WHEN pe.language = 'no' THEN 'WRONG - Norwegian!'
       WHEN pe.language IS NULL THEN 'Unknown'
       ELSE 'OK' END as en_lang_status
FROM product_translations pt
JOIN products pn ON pt.no_product_id = pn.id
JOIN products pe ON pt.en_product_id = pe.id
WHERE pn.language = 'en'
   OR pe.language = 'no'
   OR (pn.language IS NULL AND pe.language IS NULL)
ORDER BY pn.name

Edit SQL