0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people interested in conceptual questions about life and challenges in a world where "cognitive" functions can be mimicked in purely digital environment

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 ('stripe-payments') 
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

edited dec 14

created dec 14 anonymous