INSERT INTO provider( person_id, identifier, creator, date_created, retired, uuid )
VALUES ((SELECT orderer FROM orders WHERE orderer NOT IN (SELECT person_id FROM provider)),
CONCAT( "prov: ", SUBSTRING((SELECT uuid FROM person), 5)) , 1, NOW() , false, UUID())