0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Japanese language

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