INSERT INTO sa_device (operator_id, device_uuid, name, device_type_id, identifier, config, customer_id)


SELECT 1001,
'607f9ce7-3727-4f11-b37a-294985unique',
'finalized_device_name', 1, '', '',
sa_customer.id

FROM sa_customer

WHERE sa_customer.extref='7177-6608-9401-5713-1078' AND sa_customer.operator_id=100;