DELETE_statistics_by_entity_id.sql

-- WARNING DELETION!!!
-- WARNING DELETION!!!
DELETE FROM PUBLIC.STATISTICS_SHORT_TERM
WHERE
	PUBLIC.STATISTICS_SHORT_TERM.METADATA_ID IN (
		SELECT
			ID
		FROM
			PUBLIC.STATISTICS_META
		WHERE
			STATISTICS_META.STATISTIC_ID IN (
				'sensor.invertor_batteries_charging_monthly_kwh',
				'sensor.invertor_battery_charging_power_kwh'
			)
	);
-- WARNING DELETION!!!
-- WARNING DELETION!!!
DELETE FROM PUBLIC.STATISTICS
WHERE
	PUBLIC.STATISTICS.METADATA_ID IN (
		SELECT
			ID
		FROM
			PUBLIC.STATISTICS_META
		WHERE
			STATISTICS_META.STATISTIC_ID IN (
				'sensor.invertor_batteries_charging_monthly_kwh',
				'sensor.invertor_battery_charging_power_kwh'
			)
	);
-- WARNING DELETION!!!
-- WARNING DELETION!!!