select pst.* from Posts pst join PostTags ptg on pst.Id =...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Bicycles Meta

Q&A about the site for people who build and repair bicycles, people who train cycling, or commute on bicycles

select pst.*
from Posts pst
join PostTags ptg on pst.Id = ptg.PostId
JOIN Tags t ON (ptg.TagId = t.Id)
where pst.CreationDate >= '2024-01-01 00:00:00'
  and pst.CreationDate < '2024-01-02'
  and pst.Id >= 77734096
  and t.TagName = 'c#'

Enter Parameters

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