Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping

Q&A for gardeners and landscapers

SELECT  DISTINCT --p.Id as [Post Link], 
        --'https://stackoverflow.com/q/' + CAST(p.Id AS NVARCHAR(250)) as [PostLink], 
        --p.ViewCount as [Views], 
        --p.Score as [PostScore], 
        --p.CreationDate as [PostCreationDate], 
        --u.LastAccessDate as [LastSeenOn],
        'https://stackoverflow.com/users/' + CAST(u.Id AS VARCHAR(11)) AS [UserLink],
        --u.Id as [User Link],
        u.DisplayName as [User],
        --u.WebsiteUrl as [GitHub Link]

FROM  Posts as p
INNER JOIN PostTags as pt ON p.Id = pt.PostId
INNER JOIN Tags as t ON pt.TagId = t.Id
INNER JOIN Users as u ON p.OwnerUserId = u.Id
WHERE t.TagName IN (
  -- AND p.AnswerCount = 0
  AND p.PostTypeId  = 1        -- PostTypeId = 1 -> Question
  --AND p.AcceptedAnswerId is null
  AND p.CommunityOwnedDate is null
  AND p.ClosedDate         is null
  AND p.ViewCount > 50
  --AND p.Score > 3
  --AND u.Reputation > 500
  --AND p.LastActivityDate > '2019-01-01'
  AND p.CreationDate > '2018-06-01'
  --AND u.LastAccessDate > '2019-01-01'
  --AND p.ViewCount >10
  --AND u.AboutMe LIKE '%@gmail%'
  --AND (u.WebsiteUrl LIKE '%github.com%')-- OR u.WebsiteUrl LIKE '%linkedin.com%')
-- ORDER by p.CreationDate DESC;

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results