0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for anime and manga fans

select p.id, count(*)
from posts p
inner join posttags pt on pt.postid = p.id
inner join tags t on t.id = pt.tagid and t.tagname in ('google-apps-script') 
inner join votes v on v.postid = p.id
where p.posttypeid = 1
and p.creationdate between v.creationdate and dateadd(d, 1,v.creationdate)
and p.creationdate > '2024-10-01'
group by p.id
order by count(*) desc

fork query

created dec 14 anonymous