Find posts

0

Please login or register to vote for this query.

(click on this box to dismiss)

Probably not the most efficient way... ordered by creation views

History

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

Enter Parameters

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