Change Details

SELECT u.username User, p.name Project, IF(f.id IS NULL, "NO", "YES") "Has MFA" FROM phabicator_user.user u LEFT JOIN phabricator_user.edge ue ON ue.src = u.phid AND ue.type = 14 LEFT JOIN phabricator_project.project p ON ue.dst = p.phid LEFT JOIN phabricator_auth.auth_factorconfig f ON f.userPHID = u.phid WHERE p.name = 'Dog Project';

SELECT u.username User, p.name Project, IF(f.id IS NULL, "NO", "YES") "Has MFA" FROM phabricator_user.user u LEFT JOIN phabricator_user.edge ue ON ue.src = u.phid AND ue.type = 14 LEFT JOIN phabricator_project.project p ON ue.dst = p.phid LEFT JOIN phabricator_auth.auth_factorconfig f ON f.userPHID = u.phid WHERE p.name = 'Dog Project';

SELECT u.username User, p.name Project, IF(f.id IS NULL, "NO", "YES") "Has MFA" FROM phabricator_user.user u LEFT JOIN phabricator_user.edge ue ON ue.src = u.phid AND ue.type = 14 LEFT JOIN phabricator_project.project p ON ue.dst = p.phid LEFT JOIN phabricator_auth.auth_factorconfig f ON f.userPHID = u.phid WHERE p.name = 'Dog Project';