How many upvotes do I have for each tag?

0

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  users.id as userid,count( *)as posts_num 
from posts,users 
where posts.owneruserid=users.id 
and users.creationdate<='2020-05-15'
and posts.creationdate <='2021-05-16' and posts.creationdate >='2021-04-15'
group by users.id
),
bounts as(
select posts.id as postid,owneruserid as userid
from posts 
where posts.creationdate <='2021-05-17' 
and posts.creationdate >='2020-05-11'
)
select count(*)
from posttags, counts,bounts
where posts_num>=10
and posts_num<=14
and bounts.userid=counts.userid
and posttags.postid=bounts.postid

Enter Parameters

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