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
        --,COUNT(u.Location) as [Count]

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 > 50
  --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;
AND u.Location IN (
'United States',
'USA',
'New York, NY, United States',
'Toronto, ON, Canada',
'Canada',
'New York, NY, USA',
'Boston, MA, United States',
'San Francisco, CA, United States',
'New York, United States',
'San Francisco Bay Area',
'San Francisco, CA, USA',
'San Francisco, CA',
'Los Angeles, CA, United States',
'Chicago, IL, United States',
'Chicago, IL, USA',
'New York, NY',
'Boston, MA, USA',
'Montreal, QC, Canada',
'Los Angeles, CA, USA',
'California',
'Seattle, WA, United States',
'Vancouver, BC, Canada',
'California, United States',
'Seattle, WA, USA',
'Boston',
'Washington, DC, United States',
'Los Angeles, CA',
'San Jose, CA, United States',
'Chicago, IL',
'San Diego, CA, United States',
'Austin, TX, United States',
'Calgary, AB, Canada',
'Mountain View, CA',
'Atlanta, GA, United States',
'Irvine, CA, United States',
'Seattle, WA',
'New York',
'Toronto, Canada',
'San Jose, CA, USA',
'Cambridge, MA, United States',
'Ottawa, ON, Canada',
'Atlanta, GA',
'Dallas, TX, United States',
'San Diego, CA, USA',
'Atlanta, GA, USA',
'Pittsburgh, PA, United States',
'Austin, TX, USA',
'Cambridge, MA',
'Washington, DC, USA',
'San Diego, CA',
'Toronto',
'Denver, CO',
'Austin, TX',
'NYC',
'San Jose, CA',
'Pittsburgh, PA',
'New York City',
'Portland, OR'
)

OR LOWER(u.Location) LIKE '%usa%'
OR LOWER(u.Location) LIKE '%canada%'
OR LOWER(u.Location) LIKE '%united states%'
--GROUP BY u.Location
--HAVING [Count] >= 10
--ORDER BY [Count] DESC

Enter Parameters

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