Add Universal Furniture to Beds Subcategory

EXECUTE:
INSERT INTO wordpress_jk_intranet_links (manufacturer_id, subcategory_id, url, title, active, created_at)
SELECT
m.id,
s.id,
“https://www.universalfurniture.com/furniture/bedroom/beds”,
“Universal Furniture – Beds”,
1,
NOW()
FROM wordpress_jk_intranet_manufacturers m
CROSS JOIN wordpress_jk_intranet_subcategories s
WHERE m.name = “Universal Furniture”
AND s.name = “Beds”
AND s.category_id = (SELECT id FROM wordpress_jk_intranet_categories WHERE name = “Bedroom”)
AND NOT EXISTS (
SELECT 1 FROM wordpress_jk_intranet_links l
WHERE l.manufacturer_id = m.id AND l.subcategory_id = s.id
);