SELECT TOP(800) p.Id, p.Title, p.ViewCount, p.Body, p.Cre...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TOP(800)
    p.Id, p.Title, p.ViewCount, p.Body, p.CreationDate
FROM
    Posts as p
    JOIN Users as u
      ON u.Id = p.OwnerUserId
WHERE
    p.AnswerCount = 0
AND p.Tags LIKE '%python%'
AND u.Reputation < 400
AND p.ViewCount > 10000
order by p.CreationDate desc;

Enter Parameters

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