I mentioned this earlier that I was looking for a way to directly connect user e-mail address to specific countries. Here's the SQL code I came up with:
SELECT Customer.Id, Customer.Email, Address.CountryId, Country.Name
FROM Customer INNER JOIN
CustomerAddresses ON CustomerAddresses.Customer_Id = Customer.Id INNER JOIN
Address ON Address.Id = CustomerAddresses.Address_Id INNER JOIN
Country ON Country.Id = Address.CountryId
WHERE (Customer.Email IS NOT NULL)
ORDER BY Customer.Id
If you want to limit the report to one country, you need the country code (Example: US = 1) and add it immediately after (Customer.Email IS NOT NULL) thusly:
WHERE (Customer.Email IS NOT NULL) and (address.CountryId = '1')
It's a quick and dirty way to scroll through your e-mail addresses to pick out obvious "troll" accounts like this one: "[email protected]"