← back to Dw Dead Image Recovery

data/apply-versa-kamatera.sql

159 lines

-- TK-11048 versa image_url backfill — KAMATERA-SCOPED — 145 rows — GATED canonical-catalog write.
-- CORRECTED apply: keyed on Kamatera's ACTUAL mfr_sku (as-stored), derived from a fresh
--   re-recovery against the live product_url of each currently-broken Kamatera row.
--   (Supersedes apply-versa.sql, which was Mac2-mirror-derived and matched 0 rows on prod.)
-- SAFE GUARD: each UPDATE only fires if the row is STILL broken (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://').
--   Every new_image_url is SKU-core-keyed to its product page AND liveness-verified (200 + image/*).
--   Idempotent — re-run = no-op once fixed; cannot clobber a healthy image.
--
-- STEP 0 — restore capture from the TARGET db BEFORE updating (rollback record):
--   psql "<KAMATERA dw_unified conn>" -c "\copy (SELECT mfr_sku,image_url FROM versa_catalog WHERE (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://')) TO 'versa-restore-kamatera-<ts>.csv' CSV HEADER"
-- ROLLBACK — replay data/versa-restore-kamatera-map.jsonl: UPDATE versa_catalog SET image_url=<old_image_url> WHERE mfr_sku=<mfr_sku>;
BEGIN;
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/d/b/csm_Lombard_A132-194-Rincon_Hill_24e31a14d7.jpg' WHERE mfr_sku='a132-194-262' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/1/c/csm_Brio_A119-231-Ceylon_82d1b50e77.jpg' WHERE mfr_sku='a119-231-258' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/7/7/csm_Brio_A119-872-Travertino_5e26820103.jpg' WHERE mfr_sku='a119-872-258' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/a/8/csm_Fabrications_A151-505-Oxide_170f27e93f.jpg' WHERE mfr_sku='a151-505-263' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/1/7/csm_Brio_A119-592-Sepia_3db1c67665.jpg' WHERE mfr_sku='a119-592-258' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/9/f/csm_Brio_A119-897-Peony_7348fe8247.jpg' WHERE mfr_sku='a119-897-258' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/3/3/csm_Fabrications_A151-841-Glaze_82e72538ac.jpg' WHERE mfr_sku='a151-841-263' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/6/6/csm_Lombard_A132-320-Marina_Blvd._5bd14e9e3b.jpg' WHERE mfr_sku='a132-320-262' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/4/b/csm_Prism_A153-085-Silver_Lining_d720057100.jpg' WHERE mfr_sku='a153-085-264' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/d/1/csm_Prism_A153-163-Temptation_7fe25c756f.jpg' WHERE mfr_sku='a153-163-264' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/d/8/csm_Prism_A153-181-Ivory_Palace_b745ad9b31.jpg' WHERE mfr_sku='a153-181-264' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/e/5/csm_Fabrications_A151-898-Oiled_Brass_93e3147b76.jpg' WHERE mfr_sku='a151-898-263' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/d/9/csm_Prism_A153-841-Boot_Strap_a42c0c9f96.jpg' WHERE mfr_sku='a153-841-264' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/0/3/csm_Embarcadero_A156-895-Mountain_Mist_f11fa11871.jpg' WHERE mfr_sku='a156-895-265' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/7/1/csm_Embarcadero_A156-101-Spring_Wood_0a86e3f071.jpg' WHERE mfr_sku='a156-101-265' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/3/f/csm_Embarcadero_A156-152-Promenade_e6fd56113e.jpg' WHERE mfr_sku='a156-152-265' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/7/5/csm_Urban_Oasis_A157-196-Sandstone_a8dfcd9000.jpg' WHERE mfr_sku='a157-196-266' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/f/d/csm_Urban_Oasis_A157-802-Mercury_3719e0bef1.jpg' WHERE mfr_sku='a157-802-266' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/6/9/csm_Urban_Oasis_A157-114-Horn_a7257a68a3.jpg' WHERE mfr_sku='a157-114-266' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/c/3/csm_Kouri_A158-480-Treasure_Island_5c3ff2a29b.jpg' WHERE mfr_sku='a158-480-267' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/d/5/csm_Kouri_A158-310-Tempest_b3b2facb66.jpg' WHERE mfr_sku='a158-310-267' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/a/4/csm_Aura_A166-322-Lagoon_c891c135db.jpg' WHERE mfr_sku='a166-322-270' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/3/2/csm_Aura_A166-357-Night_Watchman_0dacc24adf.jpg' WHERE mfr_sku='a166-357-270' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/e/c/csm_Kouri_A158-892-Flax_bc0d4e6acb.jpg' WHERE mfr_sku='a158-892-267' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/9/d/csm_Chesapeake_A167-000-Chiffon_3d498bf789.jpg' WHERE mfr_sku='a167-000-271' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/6/9/csm_Chesapeake_A167-865-Flint_ab5f42b421.jpg' WHERE mfr_sku='a167-865-271' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/3/b/csm_Aura_A166-895-Silverado_3f2048648c.jpg' WHERE mfr_sku='a166-895-270' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/5/e/csm_Sonoma_A171-520-Meditation_b3b65e95ad.jpg' WHERE mfr_sku='a171-520-273' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/d/e/csm_Chesapeake_A167-101-Lino_03669e8cdb.jpg' WHERE mfr_sku='a167-101-271' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/a/b/csm_Omni_Linen_A169-804-Windsor_64ad60754d.jpg' WHERE mfr_sku='a169-804-272' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/a/b/csm_Omni_Linen_A169-308-Plume_387517b3a2.jpg' WHERE mfr_sku='a169-308-272' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/1/e/csm_Sonoma_A171-864-Shoreline_6543544b78.jpg' WHERE mfr_sku='a171-864-273' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/c/b/csm_Sonoma_A171-899-Daybreak_79fe8ade3d.jpg' WHERE mfr_sku='a171-899-273' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/6/c/csm_Alley_Cat_A176-329-Tidal_Wave_b04e4dd592.jpg' WHERE mfr_sku='a176-329-276' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/6/a/csm_Alley_Cat_A176-852-Stone_Wash_bfa8888a20.jpg' WHERE mfr_sku='a176-852-276' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/8/b/csm_Omni_Linen_A169-312-Night_Owl_a189b59ec4.jpg' WHERE mfr_sku='a169-312-272' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/a/4/csm_Interlude_A177-890-Opal_4a63618d40.jpg' WHERE mfr_sku='a177-890-277' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/4/0/csm_Atmosphere_A180-342-Pewter_666177d4e8.jpg' WHERE mfr_sku='a180-342-279' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/e/b/csm_Interlude_A177-263-Ivy_fe2cf1cbff.jpg' WHERE mfr_sku='a177-263-277' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/5/2/csm_Atmosphere_A180-386-Blue_Lava_245cf5e78e.jpg' WHERE mfr_sku='a180-386-279' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/d/d/csm_Atmosphere_A180-231-Organic_5a99b79a3c.jpg' WHERE mfr_sku='a180-231-279' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/4/d/csm_Mandolin_A181-082-Birch_236d3923f3.jpg' WHERE mfr_sku='a181-082-280' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/9/c/csm_Mandolin_A181-213-Tropics_fdcb42dd44.jpg' WHERE mfr_sku='a181-213-280' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/c/1/csm_Ithaca_A183-007-Bay_East_738611332c.jpg' WHERE mfr_sku='a183-007-281' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/5/d/csm_Ithaca_A183-466-Butter_Rum_210551fc94.jpg' WHERE mfr_sku='a183-466-281' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/4/f/csm_Matka_A187-012-Keshii_0aa570da9d.jpg' WHERE mfr_sku='a187-012-284' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/6/a/csm_Matka_A187-111-Patina_1db4f2a970.jpg' WHERE mfr_sku='a187-111-284' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/e/3/csm_Ithaca_A183-667-Earth_Tone_1b2f9ed02b.jpg' WHERE mfr_sku='a183-667-281' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/b/7/csm_Matka_A187-115-Arbor_79d8459bf6.jpg' WHERE mfr_sku='a187-115-284' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/4/c/csm_Miura_A189-190-Fawn_26d20dcc14.jpg' WHERE mfr_sku='a189-190-286' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/6/7/csm_Miura_A189-117-Flax_74f50c6d10.jpg' WHERE mfr_sku='a189-117-286' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/7/0/csm_Miura_A189-058-Cirrus_7d7748ef6e.jpg' WHERE mfr_sku='a189-058-286' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/d/5/csm_Ocean_Drive_A191-401-Espirit_198a3f2546.jpg' WHERE mfr_sku='a191-401-288' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/6/4/csm_Yoki_A190-127-Toffee_4521db879d.jpg' WHERE mfr_sku='a190-127-287' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/b/a/csm_Yoki_A190-633-Etruscan_ae8f5f8933.jpg' WHERE mfr_sku='a190-633-287' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/f/d/csm_Ocean_Drive_A191-502-Gatsby_70b042bd9f.jpg' WHERE mfr_sku='a191-502-288' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/c/b/csm_Aries_A188-722-Akoya_39ee4bb75b.jpg' WHERE mfr_sku='a188-722-285' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/3/9/csm_Ocean_Drive_A191-540-Mirage_86f0c5976e.jpg' WHERE mfr_sku='a191-540-288' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/f/e/csm_Caba_A194-610-Cayenne_f236d6e3d0.jpg' WHERE mfr_sku='a194-610-290' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/3/0/csm_Capri_A192-588-Alloy_4ee5330738.jpg' WHERE mfr_sku='a192-588-289' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/c/e/csm_Parallel_A195-596-Sandstone_58530db322.jpg' WHERE mfr_sku='a195-596-291' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/a/3/csm_Parallel_A195-502-Slate_40b8a637f7.jpg' WHERE mfr_sku='a195-502-291' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/2/6/csm_Corda_A196-592-Labrinth_3f0fa6a235.jpg' WHERE mfr_sku='a196-592-292' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/e/0/csm_Burnished_Silk_A198-458-Spiced_Cider_072c320c3d.jpg' WHERE mfr_sku='a198-458-294' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/2/d/csm_Burnished_Silk_A198-592-Noir_d81207b504.jpg' WHERE mfr_sku='a198-592-294' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/4/4/csm_Astoria_A197-081-Silver_Leaf_d7124adaab.jpg' WHERE mfr_sku='a197-081-293' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/e/2/csm_Lurra_A199-806-London_Road_6c9e838fdd.jpg' WHERE mfr_sku='a199-806-295' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/d/a/csm_Senza_A200-958-Signoria_Mylar_608272391f.jpg' WHERE mfr_sku='a200-958-296' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/8/f/csm_Burnished_Silk_A198-763-Marigold_b16b270bbc.jpg' WHERE mfr_sku='a198-763-294' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/4/1/csm_Akasha_A201-706-Eris_Mylar_74994e7d8d.jpg' WHERE mfr_sku='a201-706-297' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/7/a/csm_Alegre_A203-571-Cadenza_bee4c40644.jpg' WHERE mfr_sku='a203-571-299' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/d/c/csm_Navarre_A202-885-Thistle_5a759d0435.jpg' WHERE mfr_sku='a202-885-298' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/5/3/csm_Sterling_Heights_A207-501-Sun_Ray_d4765a1921.jpg' WHERE mfr_sku='a207-501-303' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/2/d/csm_Patina_Blocks_A208-801-Brushed_Silver_bd899e3938.jpg' WHERE mfr_sku='a208-801-304' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/2/d/csm_Patina_Blocks_A208-890-Obsidian_989b8ffaba.jpg' WHERE mfr_sku='a208-890-304' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/6/e/csm_Patina_Blocks_A208-379-Kyanite_0359f67e9f.jpg' WHERE mfr_sku='a208-379-304' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/6/1/csm_Sterling_Heights_A207-899-Luceat_bf2093bfba.jpg' WHERE mfr_sku='a207-899-303' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/0/9/csm_Oracle_A209-834-Cielo_73ee337b46.jpg' WHERE mfr_sku='a209-834-305' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/2/a/csm_Oracle_A209-805-Macael_f57e9eb98e.jpg' WHERE mfr_sku='a209-805-305' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/2/1/csm_Ossian_A210-347-Pelagic_5032bf1f92.jpg' WHERE mfr_sku='a210-347-306' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/c/6/csm_Ossian_A210-502-Lightwave_54a9e0b84d.jpg' WHERE mfr_sku='a210-502-306' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/f/4/csm_Ossian_A210-516-Argent_882d131523.jpg' WHERE mfr_sku='a210-516-306' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/e/b/csm_Bellevue_A211-941-Upstream_2b7e01a256.jpg' WHERE mfr_sku='a211-941-307' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/8/7/csm_Bellevue_A211-310-Savvy_8d8755af0e.jpg' WHERE mfr_sku='a211-310-307' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/e/9/csm_Bellevue_A211-175-Cherry_Wine_d941a8fe9d.jpg' WHERE mfr_sku='a211-175-307' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/b/f/csm_Isla_Grass_A213-302-Tahitian_b2fe949a80.jpg' WHERE mfr_sku='a213-302-309' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/c/a/csm_Isla_Grass_A213-838-Ceramic_54750be1b5.jpg' WHERE mfr_sku='a213-838-309' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/0/f/csm_Alameda_A214-196-Snug_9c4744b242.jpg' WHERE mfr_sku='a214-196-310' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/a/3/csm_Alameda_A214-380-Hideaway_2f71bbdddf.jpg' WHERE mfr_sku='a214-380-310' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/e/5/csm_Isla_Grass_A213-879-Nocturnal_4dc2047684.jpg' WHERE mfr_sku='a213-879-309' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/3/7/csm_Alameda_A214-863-Bedrock_da640c986e.jpg' WHERE mfr_sku='a214-863-310' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/3/f/csm_Secret_Garden_A215-146-Heavy_Cream_ac92823bd3.jpg' WHERE mfr_sku='a215-146-311' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/a/b/csm_Ascoli_A216-710-Aurum_Mylar_a91c0b9028.jpg' WHERE mfr_sku='a216-710-312' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/4/1/csm_Secret_Garden_A215-896-Overcast_fff755e777.jpg' WHERE mfr_sku='a215-896-311' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/a/d/csm_Ascoli_A216-871-Flourite_Mylar_0f64e201de.jpg' WHERE mfr_sku='a216-871-312' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/2/7/csm_Brenn_A222-039-Limewash_4397ed618a.jpg' WHERE mfr_sku='a222-039' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/e/5/csm_Brenn_A222-317-Inkroot_5c3edb7bdf.jpg' WHERE mfr_sku='a222-317' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/6/3/csm_Sakai_A95-870-Cirrus_ee302c325c.jpg' WHERE mfr_sku='a95-870-316' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/6/b/csm_Loma_ABS03-849-Windflower_544852e58b.jpg' WHERE mfr_sku='abs03-849-38' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/7/a/csm_Loma_ABS03-758-Cabana_a5ce177e1f.jpg' WHERE mfr_sku='abs03-758-38' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/9/5/csm_Zari_ABS04-819-Gold_Pavement_32e020ef45.jpg' WHERE mfr_sku='abs04-819-39' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/2/2/csm_Sakai_A95-556-Silver_Point_46aab2138b.jpg' WHERE mfr_sku='a95-556-316' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/0/7/csm_Zari_ABS04-879-Pewter_ecf4c0af16.jpg' WHERE mfr_sku='abs04-879-39' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/d/6/csm_Terra_AVF01-025-Ice_Blink_PVC-free_df75398070.jpg' WHERE mfr_sku='avf01-025-70' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/b/b/csm_Terra_AVF01-216-Water_Sky_PVC-free_f2435a1c16.jpg' WHERE mfr_sku='avf01-216-70' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/b/f/csm_Terra_AVF01-591-Rolling_Hills_PVC-free_7b11c56e25.jpg' WHERE mfr_sku='avf01-591-70' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/7/5/csm_Cape_Town_AVF02-590-Acorn_Street_PVC-free_cc37c4026e.jpg' WHERE mfr_sku='avf02-590-71' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/d/b/csm_Cape_Town_AVF02-024-Good_Hope_PVC-free_17d1628b71.jpg' WHERE mfr_sku='avf02-024-71' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/e/9/csm_Verda_AVF03-874-Frost_PVC-free_7010717e19.jpg' WHERE mfr_sku='avf03-874-72' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/b/5/csm_Tanglewood_ABS07-883-Charwood_59082ef0b2.jpg' WHERE mfr_sku='abs07-883-42' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/4/7/csm_Tesoro_AVF04-857-Cinder_PVC-free_e92adb127e.jpg' WHERE mfr_sku='avf04-857-73' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/e/2/csm_High_Plains_AVF06-500-Rock_Crystal_PVC-free_1e0297a3be.jpg' WHERE mfr_sku='avf06-500-75' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/f/2/csm_High_Plains_AVF06-773-Honey_Mist_PVC-free_97ac245014.jpg' WHERE mfr_sku='avf06-773-75' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/3/0/csm_Mirelli_AVF07-188-Basswood_PVC-free_b43ad87ba5.jpg' WHERE mfr_sku='avf07-188-76' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/4/8/csm_Mirelli_AVF07-330-Ocean_Abyss_PVC-free_1178b4350f.jpg' WHERE mfr_sku='avf07-330-76' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/0/a/csm_Lino_AVF10-827-French_Grey_PVC-free_b3085abebe.jpg' WHERE mfr_sku='avf10-827-78' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/8/5/csm_Lino_AVF10-859-Slate_PVC-free_2234f2eda9.jpg' WHERE mfr_sku='avf10-859-78' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/b/b/csm_Barege_Texture_AVF14-295-Aveyron_4964116122.jpg' WHERE mfr_sku='avf14-295-82' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/c/c/csm_Tanglewood_ABS07-346-Hemlock_a757f7220f.jpg' WHERE mfr_sku='abs07-346-42' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/b/a/csm_Aspect_AVF13-898-Solar_Carve_PVC-free_b4b24d625a.jpg' WHERE mfr_sku='avf13-898-81' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/4/7/csm_Barege_Texture_AVF14-885-Granite_34e7e3b946.jpg' WHERE mfr_sku='avf14-885-82' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/7/4/csm_Sisley_AVF18-014-Verbena_PVC-free_09ec169b18.jpg' WHERE mfr_sku='avf18-014-86' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/8/3/csm_Linden_AVF16-325-Mist_PVC-free_15f03f9a6c.jpg' WHERE mfr_sku='avf16-325-84' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/4/0/csm_Linden_AVF16-748-Lily_PVC-free_d7a2303a6a.jpg' WHERE mfr_sku='avf16-748-84' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/5/6/csm_Sisley_AVF18-027-Aspen_PVC-free_9924aabd05.jpg' WHERE mfr_sku='avf18-027-86' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/e/4/csm_Via_Monte_AVF17-772-Halogen_PVC-free_6f52b89792.jpg' WHERE mfr_sku='avf17-772-85' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/d/f/csm_Sisley_AVF18-881-Mountain_Range_PVC-free_1a3fa77108.jpg' WHERE mfr_sku='avf18-881-86' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/e/d/csm_Englewood_AVF20-652-Chestnut_PVC-free_361914c71d.jpg' WHERE mfr_sku='avf20-652-87' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/2/d/csm_Englewood_AVF20-722-Birch_PVC-free_75d4d39b0a.jpg' WHERE mfr_sku='avf20-722-87' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/c/8/csm_Haku_AVF21-271-Mystic_PVC-free_8e0a3a178b.jpg' WHERE mfr_sku='avf21-271-88' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/e/8/csm_Haku_AVF21-387-Serene_PVC-free_77f698bb68.jpg' WHERE mfr_sku='avf21-387-88' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/7/8/csm_Via_Monte_AVF17-218-Ravine_PVC-free_f2c68d1ad5.jpg' WHERE mfr_sku='avf17-218-85' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/5/8/csm_Haku_AVF21-778-Sol_PVC-free_793bce8847.jpg' WHERE mfr_sku='avf21-778-88' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/e/9/csm_Alsace_AVF23-426-Picturesque_PVC-free_2c98fa2cec.jpg' WHERE mfr_sku='avf23-426-89' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/0/0/csm_Alsace_AVF23-898-Dark_Matter_PVC-free_28480389e9.jpg' WHERE mfr_sku='avf23-898-89' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/8/8/csm_Alsace_AVF23-637-Fa%C3%A7ade_PVC-free_3b29ee1f73.jpg' WHERE mfr_sku='avf23-637-89' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/8/2/csm_Terramo_AVF24-341-Daybreak_PVC-free_e9c4aaf73e.jpg' WHERE mfr_sku='avf24-341-90' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/1/b/csm_Terramo_AVF24-892-Compass_PVC-free_cef3240422.jpg' WHERE mfr_sku='avf24-892-90' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/2/4/csm_Douro_AVF25-867-Up_The_Road_PVC-free_b93e59003e.jpg' WHERE mfr_sku='avf25-867-91' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/a/e/csm_Lenox_AVF26-029-Chiffon_PVC-free_7089e19f14.jpg' WHERE mfr_sku='avf26-029-92' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/3/0/csm_Lenox_AVF26-050-Street_Car_PVC-free_38e0695ea6.jpg' WHERE mfr_sku='avf26-050-92' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/5/a/csm_Lenox_AVF26-157-Tapestry_PVC-free_fe4b9290fa.jpg' WHERE mfr_sku='avf26-157-92' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/5/3/csm_Pallas_AVF27-179-Sediment_PVC-free_5d5b3d5e57.jpg' WHERE mfr_sku='avf27-179-93' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/7/8/csm_Pallas_AVF27-893-Midnight_PVC-free_64f101bd35.jpg' WHERE mfr_sku='avf27-893-93' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/f/c/csm_Kaolin_AVF29-801-Cinder_c6d9015627.jpg' WHERE mfr_sku='avf29-801' AND (image_url ILIKE '%data:image%' OR image_url ILIKE '%base64%' OR image_url !~ '^https?://');
COMMIT;