Top 200k Posts

0

Please login or register to vote for this query.

(click on this box to dismiss)

Lifehacks

Q&A for people looking to bypass life's everyday problems with simple tricks

Select Distinct TOP 200000 Id
,Score
,ViewCount
,REPLACE(Title,',','')
,REPLACE(Body,',','')
,Tags
,OwnerUserId
,OwnerDisplayName

From Posts

Where ViewCount > 31000
And ViewCount <= 40673 -- ViewCount of the last element in Query3_Results 

And Id <> 7271005 -- Id of the last post in Query3_Results

Order By ViewCount DESC;

Enter Parameters

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