Q&A about the site for Ubuntu users and developers
select Body,Title,tags,Score, ViewCount from Posts where (DeletionDate IS NULL) AND (Title IS NOT NULL) AND score>10 AND Id<1000000 order by ViewCount DESC