select * FROM posts where posts.ViewCount > 20000 and pos...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

select * FROM posts
where posts.ViewCount > 20000
and posts.id NOT IN
(
SELECT TOP 150000 posts.id 
FROM posts 
ORDER BY posts.ViewCount DESC, posts.id ASC
) 
ORDER BY posts.ViewCount DESC, posts.id ASC;

Enter Parameters

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