Tags page in stackoverflow

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Apps

Q&A for apps, scripts, and development with the Stack Exchange API

select x.Id,x.Count,x.TagName,x.body,y.TagId 
from (
(select top 30 t.Id,t.Count,t.TagName,p.body from 
Tags t join Posts p 
on t.ExcerptPostId = p.id 
order by t.Count desc) x
join (
select pt.TagId from PostTags pt join Posts p on pt.PostId = p.Id where p.CreationDate >= getdate()-1) y
on x.Id = y.TagId
) 



/*
select COUNT(p.Id) as numQuestionsToday from (select * from PostTags where TagId=3) a 
join Posts p on a.PostId = p.id 
where p.CreationDate >= getdate()-1

select COUNT(p.Id) as numQuestionsWeek from (select * from PostTags where TagId=3) a 
join Posts p on a.PostId = p.id 
where p.CreationDate >= getdate()-7
*/

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results