INSERT INTO metter_data (number, obis, DATE, value)
SELECT DISTINCT  
	
	CAST(REGEXP_REPLACE(S.number, '[^0-9]', '') AS UNSIGNED) AS number,
	
	S.obis AS obis,
	
	s.date_from AS date,
	
	s.value_from AS value
FROM skaititaji S
UNION
SELECT DISTINCT
	
	CAST(REGEXP_REPLACE(S.number, '[^0-9]', '') AS UNSIGNED) AS number,
	
	S.obis AS obis,
	
	s.date_to AS date,
	
	s.value_to AS value
FROM skaititaji S;




INSERT INTO metter_meter (ch, NUMBER, len, length)
SELECT DISTINCT 
	CASE WHEN LEFT(S.number, 1) IN ('1','2','3','4','5','6','7','8','9','0') THEN '' ELSE LEFT(S.number, 1) END AS ch,
	
	CAST(REGEXP_REPLACE(S.number, '[^0-9]', '') AS UNSIGNED) AS number,
	
	LENGTH (S.number) AS len,
	
	LENGTH (CASE WHEN S.value_from > S.value_to THEN S.value_from ELSE S.value_to END) AS length
FROM skaititaji S
ORDER BY number;




INSERT INTO metter_object_temp (old_name)
SELECT DISTINCT S.name FROM skaititaji S;