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 10 Id, CreationDate, Score, ViewCount, Title, Body, OwnerUserId, LastEditorUserId, LastEditDate, LastActivityDate, Tags, CommentCount, FavoriteCount 
FROM posts WHERE AnswerCount = 0 AND Score > 0 AND Tags LIKE CONCAT('%', ##tag:string?python##, '%')
AND OwnerUserId IN (SELECT ID from users WHERE Reputation >= 100) AND ClosedDate IS NULL
ORDER By CreationDate DESC

view current version

edited dec 8 19

created dec 8 19 Arn