SELECT CONCAT("https://phabricator.wikimedia.org/p/", u.userName), ue.address AS emailAddress, ua.accountType AS externalAccount, ua.username AS externalAccountName, FROM_UNIXTIME(u.dateCreated) AS creation FROM phabricator_user.user u JOIN phabricator_user.user_email ue JOIN phabricator_user.user_externalaccount ua WHERE ue.userPHID = u.phid AND ua.userPHID = u.phid AND ue.address LIKE "%@wikimedia.org" AND u.isDisabled = 0 AND u.isSystemAgent = 0 AND u.phid IN (SELECT u2.phid FROM phabricator_user.user u2 JOIN phabricator_user.user_externalaccount ua2 ON ua2.userPHID = u2.phid WHERE ua2.accountType = "ldap") AND u.phid NOT IN (SELECT u3.phid FROM phabricator_user.user u3 JOIN phabricator_user.user_externalaccount ua3 ON ua3.userPHID = u3.phid WHERE ua3.accountType = "mediawiki") ORDER BY creation;