SELECT a.*
FROM users a
JOIN (SELECT username, email, COUNT(*)
FROM users 
GROUP BY username, email
HAVING count(*) > 1 ) b
ON a.username = b.username
AND a.email = b.email
ORDER BY a.email

Select(a(SqlAll()))
.From(users.As(a))
.InnerJoin(Select(Count(SqlAll()), username, email)
	.From(users)
	.GroupBy(username, email)
	.Having(Count(SqlAll()) > 1)
	.AsTable(b))
.On(a(username) = b(username) && a(email) = b(email));

select a.* from users as a inner join ((select count(*), username, email from users group by username, email having count(*) > 1) as b) on a.username == b.username and a.email == b.email;

select a.* from users as a inner join (select count(*), username, email from users group by username, email having count(*) > 1) as b on a.username == b.username and a.email == b.email;

Select(a(SqlAll()))
.From(users.As(a))
.InnerJoin(Select(Count(SqlAll()), username, email)
	.From(users)
	.GroupBy(username, email)
	.Having(Count(SqlAll()) > 1))
	.AsTable(b)
.On(a(username) = b(username) && a(email) = b(email));