0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those involved in the field of teaching Computer Science

SELECT TOP 50000
    p.Id,
    p.Title,
    p.ViewCount,
    p.Score,
    p.Body,
    p.Tags,
    p.CreationDate,
    p.AnswerCount,
    p.FavoriteCount
FROM
    Posts p
WHERE
    p.PostTypeId = 1
    AND p.ViewCount > 0
    AND p.Score > 0
    AND p.AnswerCount > 0
    AND (LEN(p.Tags) - LEN(REPLACE(p.Tags, '><','')) + 1) / 2 >= 4
    AND p.CreationDate >= '2011-01-01'
    AND p.Tags LIKE '%<python>%'
ORDER BY 
    p.ViewCount DESC

fork query

created jun 20 jon.doe44899