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()
    FROM orders
    WHERE orderer = (select distinct person_id from users) and (SELECT orderer FROM orders WHERE
    orderer NOT IN (SELECT person_id FROM provider)) is not null