0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for power users of Apple hardware and software

SELECT  TOP 100 u.DisplayName, t.TagName, t.Count
        FROM    Users u
        JOIN    Posts pa
        ON      pa.OwnerUserId = U.Id
        JOIN    Posts pq
        ON      pq.Id = pa.ParentId
        JOIN    PostTags pt
        ON      pt.PostId = pq.Id
        JOIN    Tags t
        ON      pt.TagId = t.Id
where t.TagName like '%c#%' and u.Location like '%Chennai%'

fork query

edited apr 10 13 anonymous

created may 31 10 Quassnoi