How many upvotes do I have for each tag?


Please login or register to vote for this query.

(click on this box to dismiss)

how long before I get tag badges?

Stack Overflow Meta en español

Preguntas y respuestas sobre el sitio para programadores y profesionales de la informática

WITH counts AS (
select as userid,count( *)as posts_num 
from posts,users 
and users.creationdate<='2020-05-15'
and posts.creationdate <='2021-05-16' and posts.creationdate >='2021-04-15'
group by
bounts as(
select as postid,owneruserid as userid
from posts 
where posts.creationdate <='2021-05-17' 
and posts.creationdate >='2020-05-11'
select posttags.* ,posts_num
from posttags, counts,bounts
where posts_num>=10 
and bounts.userid=counts.userid
and posttags.postid=bounts.postid
order by posts_num DESC

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results