0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select a.Id as [Post Link], a.Tags, d.DisplayName, d.Reputation,
    (select count(*) from Badges where UserId = a.OwnerUserId) as AskerBadges,
    a.CreationDate, e.DisplayName, e.Reputation,
    (select count(*) from Badges where UserId = b.OwnerUserId) as AnswererBadges
    from Posts a 
    inner join Posts b on b.ParentId=a.Id
    inner join Users d on d.Id=a.OwnerUserId
    inner join Users e on e.Id=b.OwnerUserId
    where a.PostTypeId=1 and a.Tags like '%android%' 
    and a.CreationDate between '2008-03-01 00:00:00' and '2013-03-01 00:00:00'
    order by a.Id

fork query

edited apr 7 13

created apr 7 13 Adam Lear