Q&A for committed Christians, experts in Christianity and those interested in learning more
select top 10* from Tags --('3', --'16', --'17', --'5', --'1386', --'9', --'2', --'820', --'4', --'58338') --tagid 6398 set rowcount 11 select count(*) as CNT,b.TagId into #temp1 from Posts a left join PostTags b on a.id = b.postid where creationdate between '2017-01-01' AND '2017-12-31' --and Tags like '%css3%' --and PostId in ('41449680','41438403') group by b.TagId order by Count(*) desc --limit 10 select * from #temp1 select top 10* from Posts a --left join #temp1 b on