0

Please login or register to vote for this query.

(click on this box to dismiss)

how long before I get tag badges?

Q&A about the site for practitioners of the art and science of signal, image and video processing

select top(20) users.id,  displayname ,users.creationdate,count( badges.id),
(select count( *) from posts where posts.owneruserid=users.id) as posts_num
from users,badges
where users.id=badges.userid 
and reputation between 10000 and 20000 
and users.creationdate <= '2015-01-01 0:0:0'and lastaccessdate >= '2021-03-01 0:0:0'
group by users.id,displayname,users.creationdate
order by newid()

fork query

edited may 12 21 anonymous

created may 24 10 sam.saffron