SELECT operator.*, credentials.id AS credentials.id, credentials.operator_id AS credentials.operator_id, credentials.provider AS credentials.provider, credentials.identifier AS credentials.identifier, credentials.tokens AS credentials.tokens, credentials.createdAt AS credentials.createdAt, credentials.updatedAt AS credentials.updatedAt, credentials.deletedAt AS credentials.deletedAt
FROM (
SELECT operator.id, operator.party_id, operator.username, operator.email, operator.firstName, operator.lastName, operator.phone, operator.altPhone, operator.altEmail, operator.signedEula, operator.lastLogin, operator.isLocked, operator.createdAt, operator.updatedAt, operator.deletedAt
FROM operator AS operator
WHERE (operator.deletedAt IS NULL AND operator.username = 'superadmin') LIMIT 1
) AS operator
LEFT OUTER JOIN credential AS credentials ON operator.id = credentials.operator_id AND credentials.deletedAt IS NULL;