Posts without answers, from the users with a non default name.

0

Please login or register to vote for this query.

(click on this box to dismiss)

Android Enthusiasts

Q&A for enthusiasts and power users of the Android operating system

-- Find questions without answers, or comments and
-- from users with non default name.
-- quantity: Quantity of posts "Quantity of posts to return"
-- tagname: Posts with a tag "Tag for posts"
-- agemonthsmax: Post's age maximum in months "Post max age (in months)
-- agelimitdays: Post's age minimum in days "Post minimum age (in days)

SELECT 
TOP   ##quantity:int?500##
      p.Id as [Post Link]

FROM
      Posts p

JOIN Users    u  ON p.OwnerUserId = u.Id
JOIN PostTags pt ON pt.PostId     = p.Id
JOIN Tags     t  ON pt.TagId      = t.Id

WHERE
          AnswerCount      =        0
      AND CommentCount     =        0
      AND ClosedDate       IS NULL
      AND UPPER(t.TagName) =        UPPER(##tagname:string?Java##)
      AND u.DisplayName    NOT LIKE 'user[1234567890]%'
      AND DATEADD(month, ##agemonthsmax:int?3##, p.CreationDate) >= DATEADD(day, -1*##agelimitdays:int?7##, GETDATE())
      
ORDER BY p.CreationDate   DESC,
         u.LastAccessDate DESC,
         p.ViewCount      ASC ,         
         u.Reputation     DESC

Enter Parameters

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