 			AND d.campaign_id = ta.campaign_id
 			AND d.indicator_id = ta.indicator_id
 		)
+		AND d.parent_region_id is not null
 		GROUP BY d.parent_region_id, d.campaign_id, d.indicator_id;
 
 		CREATE UNIQUE INDEX rc_agg_ix ON _tmp_agg(region_id,campaign_id,indicator_id);
 
 		-- OVERRIDES --
 		UPDATE _tmp_agg ta
-			set value = d.value
+		SET   value = d.value
 			, datapoint_id = d.id
 		FROM datapoint d
 		WHERE ta.region_id = d.region_id

		WHERE ta.region_id = ad.region_id
		AND ta.campaign_id = ad.campaign_id
		AND ta.indicator_id = ad.indicator_id;
		--AND ad.value != ta.value;

		-- INSERT NEW --
		INSERT INTO agg_datapoint

			,d.parent_region_id
			,d.campaign_id
			,d.indicator_id
			,SUM(COALESCE(d.value,0.00)) as value
		FROM _to_agg d

		WHERE NOT EXISTS (
