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 '%html%'
AND p.Tags LIKE '%python%'
AND u.Reputation < 100 
AND p.Body NOT LIKE '%import%'
order by p.CreationDate desc;

fork query

edited mar 8 20

created feb 9 20 Martin.Gergov