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 > 1000
order by p.ViewCount desc;

Enter Parameters

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