Get most viewed python questions & answers by tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Russian Language

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

SELECT DISTINCT
    'https://stackoverflow.com/questions/' + CONVERT(VARCHAR, q.Id) as url,
    q.ViewCount,
    q.Title,
    q.Body,
    q.Id,
    q.Tags
FROM Posts q

WHERE q.Tags LIKE '%%python%%'
      AND LEN(q.Body)>20
      AND LEN(q.Title)>20
      AND q.Tags NOT LIKE '%python%'
      AND q.Tags NOT LIKE '%ruby%'
      AND q.Tags NOT LIKE '%go%'
      AND q.Tags NOT LIKE '%php%'
      AND q.ViewCount>0
      
ORDER BY q.ViewCount DESC;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results