SELECT orders.orderer
WHERE users.user_id = orders.orderer, CONCAT( 'prov: ', SUBSTRING(
SELECT UUID( ) , 5 ) ) , 1,
CURRENT_TIMESTAMP , false, (

SELECT UUID( )
)
WHERE orders.orderer IS NOT NULL
AND orders.orderer NOT
IN (

SELECT person_id
FROM provider
));