INSERT INTO provider( person_id, identifier, creator, date_created, retired, uuid )
    SELECT (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()