Probably not the most efficient way... ordered by creation views
Q&A for historians and history buffs
-- Find posts tagged with only one tag. -- Ordered by views select top 200 p.id as [Post Link], p.tags, p.viewcount, p.ClosedDate from posts as p where (p.posttypeid=1) and (p.ClosedDate is null) and p.tags like '%java%' order by p.viewcount desc