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 votes.* ,posts_num
from votes, counts,bounts
where posts_num>=30
and posts_num<=32
and bounts.userid=counts.userid
and votes.postid=bounts.postid
order by posts_num DESC

Enter Parameters

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