Cacher is the code snippet organizer for pro developers

SELECT  name, email, status FROM pessoa WHERE EXISTS (SELECT nome, email FROM usuario)

$regex = '\(SELECT)\s.*?(FROM)\';
$replace = ' $1 count(1) as total $2';