Test4

0

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.Title,
        --p.Tags, 
        --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]
        --u.AboutMe
        u.Location

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 (
'artificial-intelligence',
'machine-learning', 
'deep-learning',
'reinforcement-learning',
'unsupervised-learning',
'supervised-learning',
'transfer-learning',
'feature-engineering',
'computer-vision',
'nlp',
'natural-language-processing',
'speech-recognition',
'neural-network',
'conv-neural-network',
'recurrent-neural-network',
'generative-adversarial-network',
'lstm',
'tensorflow', 
'keras',
'pytorch', 
'pandas', 
'scikit-learn',
'scipy',
'dataframe', 
'apache-spark',
'random-forest',
'decision-tree',
'linear-regression',
'logistic-regression',
'object-detection',
'word-embedding',
'coreml',
'nltk',
'cross-validation'
)
  -- 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 > 80
  --AND p.Score > 3
  --AND u.Reputation > 500
  --AND p.LastActivityDate > '2019-01-01'
  AND p.CreationDate > '2018-01-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

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