Products with Language but No Translation Pair

Custom SQL query returning 238 rows (hide)

SELECT
  p.id,
  '{"href": "/images/' || p.id || '.jpg", "img_src": "/images/' || p.id || '.jpg"}' as image,
  p.name,
  p.language,
  p.categories_raw,
  CASE WHEN b.instock = 1 THEN 'In Stock' WHEN b.instock = 0 THEN 'Out' ELSE '?' END as stock_status
FROM products p
LEFT JOIN product_translations pt_no ON p.id = pt_no.no_product_id
LEFT JOIN product_translations pt_en ON p.id = pt_en.en_product_id
LEFT JOIN product_backend_data b ON p.id = b.product_id
WHERE p.language IS NOT NULL
  AND pt_no.no_product_id IS NULL
  AND pt_en.en_product_id IS NULL
ORDER BY p.language, p.name

Edit SQL