0

Please login or register to vote for this query.

(click on this box to dismiss)

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;

fork query

edited may 22 20

created may 22 20 Martin.Gergov