select distinct u.Id , DisplayName, WebsiteUrl, Location,...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

select distinct u.Id , DisplayName, WebsiteUrl, 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'

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results