INSERT INTO provider( person_id, identifier, creator, date_created, retired, uuid )
VALUES (
'SELECT orderer FROM orders WHERE orders.orderer IS NOT NULL AND orders.orderer NOT IN (SELECT provider_id FROM provider)', 'CONCAT("prov: ", SUBSTRING(SELECT UUID(), 5))', 1, '01142014', 'false', 'SELECT UUID()'
)