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 as [Post Link], v.creationdate
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'

fork query

edited dec 14

created dec 14 anonymous