0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people who love being outdoors enjoying nature and wilderness, and learning about the required skills and equipment

select
   ParentId as [Post Link],
    u.displayname as [User],
   count(a.id)
from posts a
 left outer join users u
  on a.owneruserid = u.id
where posttypeid = 2 
  and (body like '%VIEWSTATE%')  
  and  a.owneruserid =  4039065

group by parentid,  u.displayname
having count(a.id) > -1
order by count(a.id) desc;

fork query

edited jun 23 18

created jun 23 18 anonymous