FROM public.products p WHERE p.id::text = pv.product_id AND LOWER(p.name) = 'kungumam' AND p.is_active=true AND pv.is_active=true; UPDATE public.products SET price=20 WHERE LOWER(name)='kungumam' AND ...