select concat('INSERT IGNORE INTO products_barcodes (products_attributes_id, products_bar_code) VALUES (', t.products_attributes_id, ',',t.products_bar_code, ');')
from (

SELECT
pb.products_attributes_id
, SUBSTR(pb.products_bar_code, 14*9+1, 13) as products_bar_code
, pb.products_bar_code as products_bar_code_l

FROM incomes_attributes AS ia
JOIN products_barcodes AS pb ON pb.products_attributes_id = ia.products_attributes_id
JOIN products_other AS po ON po.products_attributes_id = ia.products_attributes_id
WHERE ia.incomes_id = 3480
and pb.products_bar_code REGEXP '^[0-9]{13}(,[0-9]{13}){9}'

union


SELECT
pb.products_attributes_id
, SUBSTR(pb.products_bar_code, 14*8+1, 13) as products_bar_code
, pb.products_bar_code as products_bar_code_l

FROM incomes_attributes AS ia
JOIN products_barcodes AS pb ON pb.products_attributes_id = ia.products_attributes_id
JOIN products_other AS po ON po.products_attributes_id = ia.products_attributes_id
WHERE ia.incomes_id = 3480
and pb.products_bar_code REGEXP '^[0-9]{13}(,[0-9]{13}){8}'

union

SELECT
pb.products_attributes_id
, SUBSTR(pb.products_bar_code, 14*7+1, 13) as products_bar_code
, pb.products_bar_code as products_bar_code_l

FROM incomes_attributes AS ia
JOIN products_barcodes AS pb ON pb.products_attributes_id = ia.products_attributes_id
JOIN products_other AS po ON po.products_attributes_id = ia.products_attributes_id
WHERE ia.incomes_id = 3480
and pb.products_bar_code REGEXP '^[0-9]{13}(,[0-9]{13}){7}'

union
SELECT
pb.products_attributes_id
, SUBSTR(pb.products_bar_code, 14*6+1, 13) as products_bar_code
, pb.products_bar_code as products_bar_code_l

FROM incomes_attributes AS ia
JOIN products_barcodes AS pb ON pb.products_attributes_id = ia.products_attributes_id
JOIN products_other AS po ON po.products_attributes_id = ia.products_attributes_id
WHERE ia.incomes_id = 3480
and pb.products_bar_code REGEXP '^[0-9]{13}(,[0-9]{13}){6}'

union

SELECT
pb.products_attributes_id
, SUBSTR(pb.products_bar_code, 14*5+1, 13) as products_bar_code
, pb.products_bar_code as products_bar_code_l

FROM incomes_attributes AS ia
JOIN products_barcodes AS pb ON pb.products_attributes_id = ia.products_attributes_id
JOIN products_other AS po ON po.products_attributes_id = ia.products_attributes_id
WHERE ia.incomes_id = 3480
and pb.products_bar_code REGEXP '^[0-9]{13}(,[0-9]{13}){5}'

union

SELECT
pb.products_attributes_id
, SUBSTR(pb.products_bar_code, 14*4+1, 13) as products_bar_code
, pb.products_bar_code as products_bar_code_l

FROM incomes_attributes AS ia
JOIN products_barcodes AS pb ON pb.products_attributes_id = ia.products_attributes_id
JOIN products_other AS po ON po.products_attributes_id = ia.products_attributes_id
WHERE ia.incomes_id = 3480
and pb.products_bar_code REGEXP '^[0-9]{13}(,[0-9]{13}){4}'

union

SELECT
pb.products_attributes_id
, SUBSTR(pb.products_bar_code, 14*3+1, 13) as products_bar_code
, pb.products_bar_code as products_bar_code_l

FROM incomes_attributes AS ia
JOIN products_barcodes AS pb ON pb.products_attributes_id = ia.products_attributes_id
JOIN products_other AS po ON po.products_attributes_id = ia.products_attributes_id
WHERE ia.incomes_id = 3480
and pb.products_bar_code REGEXP '^[0-9]{13}(,[0-9]{13}){3}'

union


SELECT
pb.products_attributes_id
, SUBSTR(pb.products_bar_code, 14*2+1, 13) as products_bar_code
, pb.products_bar_code as products_bar_code_l

FROM incomes_attributes AS ia
JOIN products_barcodes AS pb ON pb.products_attributes_id = ia.products_attributes_id
JOIN products_other AS po ON po.products_attributes_id = ia.products_attributes_id
WHERE ia.incomes_id = 3480
and pb.products_bar_code REGEXP '^[0-9]{13}(,[0-9]{13}){2}'

union


SELECT
pb.products_attributes_id
, SUBSTR(pb.products_bar_code, 14+1, 13) as products_bar_code
, pb.products_bar_code as products_bar_code_l

FROM incomes_attributes AS ia
JOIN products_barcodes AS pb ON pb.products_attributes_id = ia.products_attributes_id
JOIN products_other AS po ON po.products_attributes_id = ia.products_attributes_id
WHERE ia.incomes_id = 3480
and pb.products_bar_code REGEXP '^[0-9]{13},'

union


SELECT

pb.products_attributes_id
, REGEXP_SUBSTR(pb.products_bar_code, '[0-9]{13}') as products_bar_code
, pb.products_bar_code as products_bar_code_l

FROM incomes_attributes AS ia
JOIN products_barcodes AS pb ON pb.products_attributes_id = ia.products_attributes_id
JOIN products_other AS po ON po.products_attributes_id = ia.products_attributes_id
WHERE ia.incomes_id = 3480
and pb.products_bar_code REGEXP '^[0-9]{13},'

) as t