SELECT a.[username],
       p.[firstname],
       p.[lastname],
       p.[email],
       p.[createutcdate],
       a.[active],
       p.[emailsent],
       p.[emailshouldbesent]
FROM   [Nextera].[dbo].[person] AS p
       JOIN [Nextera].[dbo].[adminuser] AS a
         ON p.[personid] = a.[personid]
WHERE  p.[email] = 'accountEmail'