Q&A about the site for artists and crafters
SELECT DISTINCT u.Id,DisplayName,Location,Aboutme,EmailHash,AccountId from users u inner join Posts p on p.OwnerUserId = u.Id where p.postTypeId = 2 AND u.Location like '%London%'