rishi554 · May 18, 2023 08:04 · tbhatt-entrata · May 18, 2023 · sdesai03 · May 18, 2023
diff --git a/RFSM.2023.05.18.remove_bad_data_for_template_slots_entrata120_db.sql b/RFSM.2023.05.18.remove_bad_data_for_template_slots_entrata120_db.sql
 -- Task ID : 867806w0y - The Carillon Apartment Residences - ProspectPortal
 -- Databases : entrata120

 UPDATE
 	marketing_media_associations
 SET
 	deleted_by = 8,
 	deleted_on = NOW()
 WHERE
 	id IN ( 109667,109669,109664,109666 )
 	AND cid = 18165;
 	
 UPDATE
 	template_slot_images
 SET
 	updated_by = 8,
 	updated_on = NOW(),
 	marketing_media_association_id = NULL
 WHERE
 	id = 1290689
 	AND website_id = 29146
 	AND cid = 18165;
	-- Task ID : 867806w0y - The Carillon Apartment Residences - ProspectPortal
	-- Databases : entrata120

	UPDATE
	marketing_media_associations
	SET
	deleted_by = 8,
	deleted_on = NOW()
	WHERE
	id IN ( 109667,109669,109664,109666 )
	AND cid = 18165;

	UPDATE
	template_slot_images
	SET
	updated_by = 8,
	updated_on = NOW(),
	marketing_media_association_id = NULL
	WHERE
	id = 1290689
	AND website_id = 29146
	AND cid = 18165;