-- Fix double-encoded JSON in original_image_urls
-- Convert "[\"url\"]" to ["url"]

UPDATE products_master
SET original_image_urls = REPLACE(REPLACE(original_image_urls, '\"', '"'), '""', '"')
WHERE original_image_urls LIKE '%\\%';

-- Verify the fix
SELECT COUNT(*) as remaining FROM products_master WHERE original_image_urls LIKE '%\\%';
